Solved

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

Posted on 2004-09-02
8
1,772 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
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
 
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
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

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
 
LVL 12

Expert Comment

by:Ivanov_G
ID: 11982306
0
 

Author Comment

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

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now