Access mysql longtext field from excel

[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

 

[joel]

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?

 

[gimme_this_gimme_that]

In your connection string - what driver are you specifying?

If you're using out of the box ODBC longtext won't be supported.

 

[hheckner]

In your connection string - what driver are you specifying?

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

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

 

[hheckner]

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?

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.

 

[gimme_this_gimme_that]

5.1 is fairly recent.

It's likely that the value must be read as a stream.

I googled and found this link.

Try something like this:

http://www.aspfree.com/c/a/Database/ADOs-Stream-Object/2/

 

[Alan Linnane]

It's about 3 years later and now I have the same problem ... did you find a solution that you remember?

I've done a lot of work and now have this issue is undermining all my effort?

can't find a solution via google (yet).

Best regards.