Strange problem with MySQL ODBC

Hi. I'm trying to use MyODBC 3.51 to access a DB from VB 6.0.

I followed the examples shown in the ADO samples section, and everything 
works fine. I.e., I sucessfully established a connection to a server, and 
retrieved an ADODB.Resultset that I can iterate without any complications.

The problems appear as I try to bind such Resultset to an ADODC object. I 
mean, a snippet of the form:

Sub Form_Load()
   oConn.Open "DRIVER={MySQL ODBC 3.51 Driver};" & _ ...
   rs.CursorLocation = adUseClient
   rs.Open "SELECT * from test_table", oConn

   Set adodc.Recordset = rs
   adodc.Refresh
End Sub

simply doesn't show any records in a Datagrid having as data source such 
ADODC object. I can't figure out why. To make things worse, the followign 
snippet:

   adodc.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" & _ ...
   adodc.RecordSource = "SELECT * from test_table"
   adodc.Refresh

works fine (in the sense that shows the fetched records in the Datagrid 
having as source the ADODC), but an error is triggered each time I try to 
navigate the Datagrid using the arrow keys or the mouse.

The contribute even more to my confusion, rs.BOF is false, even immediately 
after the query or after executing a rs.MoveFirst.

Well, that's it. I would really appreciate any help about these issues.
Thanks in advance,
Pablo

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx