MySQL and DSN driver issues

[Jensen Ackles]

Hello,
I have a problem with my new installed MySql database, the DSN drivers are not working with the MySql database. I am trying to install and configure them but both of them really not working , do not know why they are some what incompatible with each other. So, if you have any idea regarding it, then please let me know. Thanks in advance.

[SoftWore]

Hello,
I think you can even use the ODBC drivers with MySql to do the same thing. First you must download and install the MySQL ODBC driver. Then, create a DSN in the ODBC manager sources:

panel Panel / Administrative Tools / ODBC Sources

tab system, the DSN is created in the registry and all the Logins, tab User DSN created for the user is currently in session tab file. The DSN is created in a file. I recommend the first of three solutions, they should help you.

[GlassFish]

Hello,
If you are using MyODBC 3.51, then this should be the configuration

ConnStr = "DRIVER = (MySQL ODBC 3.51 Driver); \ 
SER = localhost; \ 
DATABASE = test; \ 
USER = come; \ 
PASSWORD = come; \ 
OPTION = 3; "
If your programming language converts the backslash followed by space in space, it is preferable to specify the connection string in the form of a long string, or use the concatenation several channels, without adding a space between:
ConnStr = "DRIVER = (MySQL ODBC 3.51 Driver);" 
"SER = localhost;" 
"DATABASE = test;" 
"USER = come;" 
"PASSWORD = come;" 
"OPTION = 3;"

[Beverly Archer]

Hello,
I have a MySQL database created from the migration of an Access database. For some reason, I had to keep all the same Access database so that I have an Access database containing tables related to those of the MySQL database (so far, no problem). Everything went well until an exception on an SQL telling me "ODBC - call failed to. What is the reason for this now, I have no idea and the computer hangs completely, if you know how to solve this problem then please let me know. Thanks in advance.

[Windowed]

Hello,
For MyODBC 2.50:
Here is the configuration you will have to do

ConnectionString = "DRIVER = (MySQL); \ 
SER = localhost; \ 
DATABASE = test; \ 
USER = come; \ 
PASSWORD = come; \ 
OPTION = 3; "

Hope this will solve your problem.