Re: How to connect MySQL 5.x from VB6.0 using OLEDB

[Jay Alverson]

I use the MYSQL 5.1 ODBC driver and can connect with the following...

'	test the connect...
dim MySQLConn, sqlstr
Set MySQLConn = CreateObject("ADODB.Connection")
MySQLConn.ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;DATABASE=test;UID=root;PWD=mysql;"
MySQLConn.open

You can also use a .DSN file, with the same connection information.

As for rs.Update, it's been a while, but I think you have to use .UpdateBatch;
well you can try it. Also make sure the cursor location is correct if that
doesn't work.

>

Thanks, Jay