I've got VB6 and MyODBC 3.51 on a client computer
I've got a server with MySQL(specifically, RedHat 7.0 that comes with MySQL 3.23).
I've gotten the MyODBC on the client successfully "talking" to the MySQL server (I get a "test successful" from the test connection button on the setup).
now, when I use the data-source in a VB6 data environment, the Recordset functions are not behaving properly. ie#1: the .Open() is successful, but it seemingly always returns an empty set, even when pulling up entire tables. ie#2: the EOF() and BOF() funcs are both returning TRUE, but the both should be FALSE if the recordset is empty.
if anyone has any ideas on solutions to this, I'd be most grateful.
thanks in advance!!
-this is posted in a few other boards where it is applicable.