Access mysql longtext field from excel

  • Thread starter Thread starter hheckner
  • Start date Start date
H

hheckner

Hi

In my result set i have one column of (mysql type longtext) which i
cannot read from my vbscript

myRecordSet.Fields.Item(col).value is Null

although the watch point on the resultset shows the right text string
stored in the database.

Any ideas?

Best regards
Hannes
 
If the watch is getting data, then there is data. Yo may have a lot of white
character yo are not seeing. Try adding this line of code

msgbox("The length of the cell is : "len(myRecordSet.Fields.Item(col).value))

Another possiblity is the object is not text but some sort of picture?
 
In your connection string - what driver are you specifying?

If you're using out of the box ODBC longtext won't be supported.
 
In your connection string - what driver are you specifying?

If you're using out of the box ODBClongtextwon't be supported.
Click to expand...

Hi,

we use the following connection string:
oConn.Open "DRIVER={MySQL ODBC 5.1 Driver};SERVER=" & curPreset.host &
";USER=" & user & ";PASSWORD=" & password & ";database=" &
curPreset.db & ";"

Any alternatives?

Thanks
Hannes
 
If the watch is getting data, then there is data.  Yo may have a lot ofwhite
character yo are not seeing.  Try adding this line of code

msgbox("The length of the cell is : "len(myRecordSet.Fields.Item(col).value))

Another possiblity is the object is not text but some sort of picture?
Click to expand...

No there is text in there. No pictures.
Funny thing is that we can see the text string in the debugger, but we
cannot get it work in the script.
 
Back
Top