Hi,
I am facing problem while connecting to MYSQL server (linux) from Win32 VB client
through OLEDB provider from MYSQL.
I am successfully connecting to server through MyODBC using DSN but
unable to connect to through OLEDB provider ( downloaded from www.MYSQL.com)
Following is the script in VB
MySQL server is on 192.168.100.101 and database is Test . This is allowed to be
connected from any IP and any user
Private Sub Form_Load()
Dim dcncentral As ADODB.Connection
Set dcncentral = New ADODB.Connection
Dim str1$
str1 = "Provider=MySQLProv;Data Source=192.168.100.101;DB=Test
dcncentral.Open str1 --------- Giving Catastrophic Error
End Sub
This function is not opening the database and giving "Catastrophic Error".
What should be the connection string for database ?
Please help. Kindly note that I want to connect to MYSQL database without a DSN
Thanks in Advance
Asit Saha
