Problems in connections to mysql

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.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!