Error Message
If you are getting above error while making connection to mysql database with ASP.NET application then you can add ODBC 5.x DSN connection on Windows VPS.
You can follow below steps for that:
Code:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
You can follow below steps for that:
- Login to windows VPS and click on Start menu.
- Go to Administrative Tools >> click Data Sources (ODBC).
- Now a new window will open the ODBC Data Source Administrator.
- You can create System DSN, you have to click on System DSN tab and if you want to create User DSN then click on User DSN which can only be used for current user. After that click on Add button.
- Now select ODBC driver, here you have to select MySQL ODBC 5.x Driver for Connector/ODBC and click on finish.
- Now you have to configure specific fields with Connection Parameters dialog.
- You have to enter all the details like Data Source Name, Description, Server, Port, User, Password and Database.
- Click on "Ok”.