Skip to content

Categories:

odbc 3.51 Invalid string or buffer length error

I’m using ODBC 3.51 to connect an ASP scripted site to MySql. I got very strange errors when calling the update function: “Invalid string or buffer length error”.
It turns out that the following line is mandatory for the ODBC driver:

The problem is the CursorLocation, the solution is that sentence

rs.CursorLocation = 3 or rs.CursorLocation = adUseClient

Just in case someone is pulling their hair out over this also…

Will version 3.51 ever update? I’ve seen this version for years and 5.1 has been in alpha for the same amount of time…

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks

Posted in code. Tagged with , .

0 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.

Some HTML is OK

(required)

(required, but never shared)

or, reply to this post via trackback.