Asp Forum
Home
|
Login
|
Register
|
Search
Forums
>
microsoft.public.dotnet.framework.odbcnet
MySQL ODBC Driver Not Found
Marvin Massih
2/24/2006 10:08:00 AM
Hi,
I have an ASP.NET project (2.0) I want to be able to access a MySQL
database.
I use a connection string like this:
"DRIVER={MySQL ODBC 3.51
Driver};SERVER=server;DATABASE=db;UID=user;PASSWORD=pwd;OPTION=3;pooling=false;Allow
Zero Datetime=True;"
This works like a charm on my co-workers' computers, who have installed
local MySQL servers, but no ODBC driver.
However on my own PC (running Windows XP Professional, SP 2 - maybe this
is the reason?) I receive the following exception:
"ERROR [IM002] [Microsoft][ODBC Driver Manager] The Data Source Name was
not found and no standard driver was specified."
So I installed the ODBC driver, which appears as "MySQL ODBC 3.51
Driver" in the driver list.
Did this help? No :-(.
After this, I even did a full install of the newest version of the MySQL
server, and just to be sure I also installed the ADO.NET driver.
Yet the problem remains.
Google told me the connection string is correct (I also tried the one
from connectionstrings.com, no difference).
I'm really lost here and any help will be appreciated.
Regards,
Marvin
(x-post, f'up2 set)
--
http://groenndem...
2 Answers
Paul Clement
2/27/2006 6:31:00 PM
0
On Fri, 24 Feb 2006 11:07:39 +0100, Marvin Massih <news@groenndemon.de> wrote:
¤ Hi,
¤
¤ I have an ASP.NET project (2.0) I want to be able to access a MySQL
¤ database.
¤
¤ I use a connection string like this:
¤
¤ "DRIVER={MySQL ODBC 3.51
¤ Driver};SERVER=server;DATABASE=db;UID=user;PASSWORD=pwd;OPTION=3;pooling=false;Allow
¤ Zero Datetime=True;"
¤
¤ This works like a charm on my co-workers'' computers, who have installed
¤ local MySQL servers, but no ODBC driver.
¤
¤ However on my own PC (running Windows XP Professional, SP 2 - maybe this
¤ is the reason?) I receive the following exception:
¤
¤ "ERROR [IM002] [Microsoft][ODBC Driver Manager] The Data Source Name was
¤ not found and no standard driver was specified."
¤
¤ So I installed the ODBC driver, which appears as "MySQL ODBC 3.51
¤ Driver" in the driver list.
¤ Did this help? No :-(.
¤
¤ After this, I even did a full install of the newest version of the MySQL
¤ server, and just to be sure I also installed the ADO.NET driver.
¤ Yet the problem remains.
¤
¤ Google told me the connection string is correct (I also tried the one
¤ from connectionstrings.com, no difference).
¤
¤ I''m really lost here and any help will be appreciated.
¤
See if any of the following helps:
http://support.microsoft.com/kb/306...
Paul
~~~~
Microsoft MVP (Visual Basic)
Marvin Massih
2/27/2006 6:46:00 PM
0
Paul,
in the meanwhile I''ve found out that I can access the database using
impersonation, which is an ugly workaround,...
Paul Clement wrote:
> See if any of the following helps:
>
>
http://support.microsoft.com/kb/306...
....so your link comes very handy.
Thanks a lot!
-Marvin
--
http://groenndem...
Servizio di avviso nuovi messaggi
Ricevi direttamente nella tua mail i nuovi messaggi per
MySQL ODBC Driver Not Found
Inserendo la tua e-mail nella casella sotto, riceverai un avviso tramite posta elettronica ogni volta che il motore di ricerca troverà un nuovo messaggio per te
Il servizio è completamente GRATUITO!
x
Login to ForumsZone
Login with Google
Login with E-Mail & Password