hi,

I need to connect to MySQL from my VB application. To open a connection,as hkmai said, I used the code:

Dim cn As New ADODB.Connection

'To establish connection string to MYSQL database

cn.Open "Provider=MSDASQL;Driver=MySQL;Data Source=[datasource name];Database=[name of database];Server=[IP address where MySQL database resides];UID=[username];PWD=[password];PORT=3306;FLAG=1;"

where:
[datasource name] --> DSN as in control panel
[name of database] --> database name as in MySQL
[username] --> root
[password] --> I left it blank



When I try connecting i get an error message "ADO could not fing the secifies provider"

What is it that I've got to do to correct this?

Thanks a lot.

[Edited by rammy on 04-06-2000 at 04:26 AM]