MySQL ADO connection and catastrophic failure

[BiggerBrother]

I've been using the vbMySQLDirect dll for a few of my apps, but now I need to use an ADO connection for reports and some controls.

I have downloaded and installed the ODBC from the mysql site, and followed all the dos and dont's. I now get an error every time I try and connect to the db, which is 2147418113 - Catastrophic failure.

My connection is:

conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=" & .dbLocation & ";" _
& "PORT=3306;" _
& "DATABASE=" & .dbName & ";" _
& "UID=" & .dbUser & ";PWD=" & .dbPass & ";"
conn.Open

Where am I going wrong? Many thanks

BB

 

[BiggerBrother]

Found it. It's an error with the driver ver 3.51.10-2.

http://forums.mysql.com/read.php?37,10499,10745#msg-10745

Fix is to download an archieve version of the driver and use that for the time being. Keep an eye out for newer version coming soon.

BB