I was working with MySQL ODBC 5.1 on my website (ASP.NET 4.5), but due to this problem: I Try setting MySQL to ODBC 5.3.4 and change the connection string from 5.1 to 5.3. Now I have not got the name of the error [IM002] [Microsoft] [ODBC driver manager] data source and no default driver is specified
exception that many others have done.
Nevertheless, uninstalled I 5.3 and 5.1 and then 5.1 64bit was installed on my Windows 8.1 64 but I still get the same exception! I tried to restart and reinstalled / installed, but it throws the same exception.
I have tried to add the driver (pointing the server) to Controlpanel> ODBC Data Source 64> System DSN but it still does not work.
Edit: I can work with the database without problems and work with the MySQL workbench without problems.
Exact exception: error [IM002] [Microsoft] [ODBC Driver Manager] The name of the data source is not found and no default driver is specified
This is the current connection string:
& lt; Add name = "MySite" connectionString = "driver = {MySQL ODBC 5.1 driver}; server = 127.0.0.1; port = 3306; database = 195414-mice site; USER = [myuser]; password = [mypassword] OPTION = 3" / & Gt;
The server has been set to 127.0.0.1 because BSAS is using SSH and has worked well before that.
I tried uninstalling all mysql odbc drivers and then installed 32 bit 5.1 and Worked fine! Although it still does not work with 5.3 32 bit.
No comments:
Post a Comment