Connecting to MySQL database via ADO (VB6)

[crisedefoie]

It's the first time I work with MySQL.

I tried to connect my VB6 application to a little database via ADO connection.

Here is my connection code :
DBConn.Open ("Provider=MySqlProv.3.0;" & "Data Source=" & MyDataBase;&quot

But I always met the same error message on this line :

"ADO could not find the specified provider. Error 3706"

As I can edit my database via MySQL Control Center, I though
I have all necessary tools to access MySQL database from my application. It seems I haven't.

I try many other way but, I'm about to loose my hair!

 

[ingresman]

interesting, Ive never seen an OLDEDB provider for mysql where did you get it ??

To get up up abd runnijg I would suggest seting up an ODBC data source e.g dsn1 and supply the connection as "DSN=dsn1" an it should all burst into life