Solved

Provider cannot be found. It may not be properly installed. Context ADO-MySQL-Delphi

Posted on 2004-09-02
8
1,805 Views
Last Modified: 2007-12-19
I installed the ODBC driver for MySQL on W2K (Have Delphi 7 enterprise)
The ODBC shows everything right
When trying using ADO in Delphi, I get : Provider cannot be found. It may not be properly installed.
as soon as I try to connect.
The Provider properties does not show the "MySQLProv" but I force it in the connectionstring...
0
Comment
Question by:LeTay
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 17

Expert Comment

by:Wim ten Brink
ID: 11963724
Apparantly you don't have an ADO provider for MySQL... Try connection by using an ODBC connection to MySQL instead.
0
 
LVL 17

Expert Comment

by:geobul
ID: 11963781
Hi,

Install MyOLEDB driver for ADO instead of using ODBC.

Regards, Geo
0
 

Author Comment

by:LeTay
ID: 11964591
A little bit better with MyOLEDB for ADO installed
Now when in the Delphi development I 'build' in the connectionstring, I get the list of provider and MysqlProv is there. I continue setting, click on 'test connection'.
There I get a MySQL data source name setup screen (look ODBC ???)
It look correct (says default in the name, but server and db and UID are okay)
I click ok and now I get this : "test connection failed because of an error in initializing provider. unspecified error"
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 17

Accepted Solution

by:
Wim ten Brink earned 250 total points
ID: 11965363
Isn't it just easier to use DBExpress instead, btw? That's more focussed on using MySQL anyway. And I believe there's also a specific MySQL component set that can be used with Delphi. ADO will slow things down a bit and might keep causing problems, especially once you start moving that application around to other systems. And while you might think that this will keep your code compatible with other database systems, in my experience this is sometimes not the case. Besides, if you ever want to run your application on a Linux system (Kylix) then forget about ADO since Unix doesn't has ADO. (But Kylix does support DBExpress...)
0
 

Author Comment

by:LeTay
ID: 11970694
Good suggestion, Alex.
I will try that DBExpress.
Hope I don't have too many things to install on that of W2K and Delphi 7 ...
0
 

Author Comment

by:LeTay
ID: 11973511
Well, I had to find the 'right' libmysql.dll as the one provided with the Windows client for mysql was not working (5.x)
I succeeded to access a remote DB mysql on another machine, with a user without password.
But now when I put a password and adapt the connection parameter accordingly it fails (invalid username/password).
Trying however with a tool like mysql from a prompt it works, the connection is established.
Looking on the server (show status) I see the abort_connects increased by 1 each time I try activating the connection from Delphi.
I wonder if I shouldn't do something special to have that password correctly passed to the DB ?
0
 

Author Comment

by:LeTay
ID: 11987868
Found the problem : no authorisation on the database.
Now everything runs fine
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question