[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
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:

&#164; Hi,
&#164;
&#164; I have an ASP.NET project (2.0) I want to be able to access a MySQL
&#164; database.
&#164;
&#164; I use a connection string like this:
&#164;
&#164; "DRIVER={MySQL ODBC 3.51
&#164; Driver};SERVER=server;DATABASE=db;UID=user;PASSWORD=pwd;OPTION=3;pooling=false;Allow
&#164; Zero Datetime=True;"
&#164;
&#164; This works like a charm on my co-workers'' computers, who have installed
&#164; local MySQL servers, but no ODBC driver.
&#164;
&#164; However on my own PC (running Windows XP Professional, SP 2 - maybe this
&#164; is the reason?) I receive the following exception:
&#164;
&#164; "ERROR [IM002] [Microsoft][ODBC Driver Manager] The Data Source Name was
&#164; not found and no standard driver was specified."
&#164;
&#164; So I installed the ODBC driver, which appears as "MySQL ODBC 3.51
&#164; Driver" in the driver list.
&#164; Did this help? No :-(.
&#164;
&#164; After this, I even did a full install of the newest version of the MySQL
&#164; server, and just to be sure I also installed the ADO.NET driver.
&#164; Yet the problem remains.
&#164;
&#164; Google told me the connection string is correct (I also tried the one
&#164; from connectionstrings.com, no difference).
&#164;
&#164; I''m really lost here and any help will be appreciated.
&#164;

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