Click here to Skip to main content
15,907,001 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
Hi I recently installed MySql Server 5.5 and MySql Connector/Odbc 5.2. Now, my old which worked perfectly in MySql Server 5.1 and Odbc Connector 3.51 generates an exception upon database operations.

The exception generated is: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I've changed the connection string to:
Driver={MySQL ODBC 5.2w Driver};Server=localhost;Database=efloxdb;User=root;Password=admin;Option=3;

The documentations haven't specified any further changes to be made. Can anyone find a solution to my problem? Any help would be appreciated
Updated 10-Jan-13 21:32pm

1 solution

Share this answer
Deepak Joy Jose 11-Jan-13 4:42am    
The ODBC Connector I've installed is 64 bit version itself. So There's no need to specify the Provider in the ConnectionString, they have mentioned. I have used the same connection string as they have given

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900