Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2004-09-02
8
Medium Priority
?
1,868 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 17

Accepted Solution

by:
Wim ten Brink earned 1000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
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…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

618 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