Hi, I am getting error while running displaynames.aspx.
The error is :

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

....

Stack Trace:


[OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
System.Data.Odbc.OdbcConnection.Open() +638
ASP.displaynames_aspx.OnInit(EventArgs e) +101
System.Web.UI.Control.InitRecursive(Control namingContainer) +241
System.Web.UI.Page.ProcessRequestMain() +174


Please advise,
Thank you,

Emanuel

Found it..!! downloaded MySQL driver and installed -
.. works fine
emanuel

I am getting the same error. I downloaded the MySqlCS driver and installed it but I'm getting the same error. Any thoughts?

I resolved the same problem when I made both (user and system dsn)

Hi Emanuel,

Thank you very much for the help. I had the same problem, I downloaded MySQL Driver and it worked very well. The source of MySQL Driver is as follows.
http://mysql.netvisao.pt/downloads/connector/odbc/3.51.html

Cheers,

Ismail

hi Emanuel and Ismail,

thanks a lot...it solve my problelm too..:)

Hi,

I was wondering what solution you came up with to be able to connect to the MySQL datasource. I built reports using Report Designer module in Visual Studio .NET 2003, I am able to preview the data and all, but when I deploy those reports and run them, I get the error message:

...
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

The MySQL ODBC connection is a system DSN, using the 3.51 driver: I have tested it and it works fine in other development environment such as Access 2000.

I am wondering if I am missing something in building the connection string on the data source in Report Designer.

I appreciate any help you can give...

Daniel.

Under 'Administrative Tools' in the 'Control Panel'
Open the 'Data Sources ODBC'
click on the 'Drivers' tab, 'MySQL ODBC 3.51 Driver' should be listed toward the bottom. If it is not, the driver has not been installed yet!

You actually need all three drivers to do it.
1. Microsoft MDAC 2.8 (the foundation classes)
2. ODBC .NET Data Provider
3. MySQL ODBC 3.51 Driver

You can get the MySQL driver from: http://dev.mysql.com/downloads/connector/odbc/3.51.html

The connection strings can be found at: http://www.connectionstrings.com Click on MySQL or the one you want.

DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPassword;OPTION=3;"

I don't know what 'OPTION=3' stands for, and it may be case sensitive, I haven't tried.

Peter

Hi,
Just Edit the connectionstring on your webconfig file (Provided Below) on your project, then rebuild the project
---------------------------------------------

MyODBC 3.51 Local database:

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPassword;OPTION=3;"



MyODBC 3.51 Remote database:

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=data.domain.com;PORT=3306;DATABASE=myDatabase; USER=myUsername;PASSWORD=myPassword;OPTION=3;"

just make OPTION=1; instead of OPTION=3;