provider is not registered

[cp84]

I would like to connect to a MySQL database running on a Linux machine called pigster, so on my vb.net development machine running win2000 I have set up a system dsn use MySQL ODBC 3.51 Driver called GilstoneMySql, and set up grants in MySQL all Tested ok.

In vb.net the connection string is
conStr = "Provider=GilstoneMySql;" & _
"Data source=pigster;" & _
"Database=Gilstone;" & _
"uid=harry;pwd=ueu8dyY9;"
same as in dsn

The following code is:
Dim OLEDBConnection As New OleDbConnection(conStr)
OLEDBConnection.Open()

This throws an error "The 'GilstoneMySql' provider is not registered on the local machine"

Is this possible to achieve? or are there better ways of doing it.

Many thanks for any help

 

[mansii]

What about

conStr = "Provider=[blue]MySQL ODBC 3.51[/blue];" & _
         "Data source=GilstoneMySql;" & _
         "Database=Gilstone;" & _
         "uid=harry;pwd=ueu8dyY9;"

I'm not sure about the blue line. You can check the manual book.
For more connection strings:

http://www.connectionstrings.com/

Regards.