Bug #25325 Data source name not found and no default driver specified

• Submitted: 29 Dec 2006 6:50
• Modified: 29 Dec 2006 7:47
• Reporter: nilesh paladiya
• Status: Closed
• Category: Connector / ODBC
• Severity: S2 (Serious)
• Version: 3.51
• OS: Windows (Windows server 2003)
• CPU Architecture: Any
• Tags: Microsoft visual studio .net 2003 + windows server 2003 + mysql 5.0.11 + mysql o

[29 Dec 2006 6:50] nilesh paladiya

Description:
Hello guys,

I am using below stuff.

1 Microsoft visual studio .net 2003 
2 Windows server 2003 
3 mysql 5.0.11 
4 mysql odbc 3.51 driver

Now when I make connection to mysql server with odbcconnection, I get below error.

System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at System.Data.Odbc.OdbcConnection.Open() 

Could you please help me in this matter?

Thanks in advance

How to repeat:
Hello guys,

I am using below stuff.

1 Microsoft visual studio .net 2003 
2 Windows server 2003 
3 mysql 5.0.11 
4 mysql odbc 3.51 driver

Now when I make connection to mysql server with odbcconnection, I get below error.

System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at System.Data.Odbc.OdbcConnection.Open() 

Could you please help me in this matter?

Thanks in advance

[29 Dec 2006 7:27] Valeriy Kravchuk

Thank you for a problem report. Please, specify the exact version of Connector/ODBC used (3.51.x). Is it 64-bit Windows?

[29 Dec 2006 7:30] nilesh paladiya

I got the solution.

I have to give rights for asp.net to mysql odbc driver in registry.

You can close this bugs.

Thanks.

[29 Dec 2006 7:47] Valeriy Kravchuk

Closed as problem was not a result of bug in MySQL's code.

[15 Jun 2007 4:12] NULL ! NULL !

I'm facing the exact problem.

nilesh paladiya, may i know how do u solve it for asp.net - mysql in the registry?

Alots of thanks.