Hello, people. I have installed MySQL connector and started VB 6.0. I have Windows 7.
When it was going to be executed (F5), there is this error:
"Provider Not Found. It may have not properly been installed."
What causes that? It was ALL OK before that.
Here's my connection string:
Code:
connStr = "DRIVER={MySQL ODBC 5.1 Driver};server=192.168.1.254;DATABASE=test;uid=root;pwd=qwerty1234;OPTION=1"
With conn
If conn.State = 0 Then
.ConnectionString = connStr
.Open
.CursorLocation = adUseClient
End If
End With
I tried removing all the programs in this order:
1. Uninstall:
- MySQL Connector 5.1.1.0 32-bit
- MySQL Query Analyzer
- MySQL Server 5.5
- Crystal Report 9
- Visual Studio 6
restarting my computer each before uninstalling other applications, deleting MySQL all config in C:\Users\ApplicationData\MySQL and C:\Users\ALLUSERS\ApplicationData\MySQL, and deleting all files in C:\Program FIles\MYSQL
, then I restarted my computer and install in this order:
2. Install:
- Visual Studio
- Crystal Report 9
- MySQL Server 5.5
- MySQL Connector 5.1.1.0 32-bit
- MySQL Query Analyzer
THE DRIVER APPEARS ON WINDOWS ODBC TRUE 32-BIT LIST (on C:\windows\SYSWOW64\Odbcad32.exe). It's stated as "MySQL ODBC 5.1 Driver".
I have tried uninstalling and reinstalling 3 times.