Solved

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

Posted on 2004-09-02
8
1,783 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
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Delphi XE10 Round Image 2 128
Print Graphic and Text to Epson TM-T88v 12 259
Working with hours 3 58
can't find the executable in Simulator 1 90
The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
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 video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

777 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