Have installed MySQL connector and all set but Provider Not found.
Have installed MySQL connector and all set but Provider Not found.
Have installed MySQL connector and all set but Provider Not found.
Have installed MySQL connector and all set but Provider Not found.
Have installed MySQL connector and all set but Provider Not found.
Have installed MySQL connector and all set but Provider Not found. Have installed MySQL connector and all set but Provider Not found. Have installed MySQL connector and all set but Provider Not found. Have installed MySQL connector and all set but Provider Not found. Have installed MySQL connector and all set but Provider Not found. Have installed MySQL connector and all set but Provider Not found. Have installed MySQL connector and all set but Provider Not found. Have installed MySQL connector and all set but Provider Not found.
Have installed MySQL connector and all set but Provider Not found. Have installed MySQL connector and all set but Provider Not found.
Have installed MySQL connector and all set but Provider Not found.
Go Back  Xtreme Visual Basic Talk > > > Have installed MySQL connector and all set but Provider Not found.


Reply
 
Thread Tools Display Modes
  #1  
Old 07-28-2016, 01:01 AM
andrern2000 andrern2000 is offline
Newcomer
 
Join Date: Oct 2010
Posts: 10
Default 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 01:11 AM.
Reply With Quote
  #2  
Old 09-20-2016, 02:46 AM
Dennis DVR's Avatar
Dennis DVRHave installed MySQL connector and all set but Provider Not found. Dennis DVR is offline
Back in the Game

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Manila Philippines
Posts: 3,576
Default

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
Reply With Quote
Reply

Tags
mysql, connector, odbc, installed, 5.1.1.0, computer, studio, deleting, install, driver, visual, analyzer, query, server, crystal, report, 32-bit, provider, found, connstr, uninstalling, applications, restarting, started, people


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Have installed MySQL connector and all set but Provider Not found.
Have installed MySQL connector and all set but Provider Not found.
Have installed MySQL connector and all set but Provider Not found. Have installed MySQL connector and all set but Provider Not found.
Have installed MySQL connector and all set but Provider Not found.
Have installed MySQL connector and all set but Provider Not found.
Have installed MySQL connector and all set but Provider Not found. Have installed MySQL connector and all set but Provider Not found. Have installed MySQL connector and all set but Provider Not found. Have installed MySQL connector and all set but Provider Not found. Have installed MySQL connector and all set but Provider Not found. Have installed MySQL connector and all set but Provider Not found. Have installed MySQL connector and all set but Provider Not found.
Have installed MySQL connector and all set but Provider Not found.
Have installed MySQL connector and all set but Provider Not found.
 
Have installed MySQL connector and all set but Provider Not found.
Have installed MySQL connector and all set but Provider Not found.
 
-->