Hi everyone, I have this problem of creating a ado connection to mysql. I am using mysql server 4.1.8. I have installed myodbc 3.5.1, created a system dsn and tested the connection. Connection was successful. However when i try to use this connection in my visual basic 6 project, it always give me this error, Runtimr error -2147418113. Catastrohic Failure.The connection string i used is this: oConn.ConnectionString = "DSN=CS;" & _
"Uid=root;" & _
Btw the OS i am using is XP wif Serivce Pack 2. Have anyone has the same prob
n how to solve it.Pls help cos it is holding up my project.