MySQL ODBC Connector - Problem accessing numeric data in mysql 5 using VB6

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Problem accessing numeric data in mysql 5 using VB6

jdst

2006-01-26, 4:56 pm

Hi,

I'm using mysql (version 5.0.18) with myodbc driver (version 3.51.10).
i made a VB6 (sp6) client app that accesses an mysql INNODB table using
ADO. When I try to get VARCHAR data from the table, there's no
problem. But when I try to SELECT numeric / decimal data, i get the
following error:

Runtime Error '-2147467259 (80004005)'
[Microsoft][ODBC Driver manager] Program type out of range

I'm using the exact same code when the mysql version was still 4.x and
there wasn't any problem like this back then. I'm guessing it may have
something to do with the myodbc driver since I read somewhere that
mysql 5 made some changes to one or more of its numeric data types.

Any help or insights will be greatly appreciated.

Jay

Sponsored Links