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
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