Have installed MySQL connector and all set but Provider Not found.

07-28-2016, 12:01 AM

andrern2000 andrern2000 is offline

Newcomer

Join Date: Oct 2010

Posts: 10

Have installed MySQL connector and all set but Provider Not found.

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.

Last edited by andrern2000; 07-28-2016 at 12:11 AM.

09-20-2016, 01:46 AM

Dennis DVR

Have installed MySQL connector and all set but Provider Not found.

Back in the Game

Forum Leader
* Expert *

Join Date: Nov 2003

Location: Manila Philippines

Posts: 3,577

This is somewhat strange. If you really installed the 32bit version of ODBC, VB should be able to find it unless of course what you have is a 64bit ODBC Driver.

If you have a 64bit Windows Operating System, the new version of ODBC Driver will install to Program Files for 64bit version and Program Files (x86) for the 32bit version.

Have you tried replacing it with version 5.3?

__________________
Avatar by Lebb

[Posting Guidelines] [Standards & Practices Tutorial] [Participate here effectively]
Our knowledge can only be finite, while our ignorance must necessarily be infinite. Karl Popper