I would start by creating a DSN entry to your database in /etc/odbc.ini then use isql to check that that works, and then try using the DSN free connection string you are using.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have a game server running on Amazon EC2 (Amazon Linux)
I have a MySQL database called pathogen
I connect using:
DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;PORT=3306;DATABASE=pathogen;UID=root;PWD=…;
The error I get is:
Data source name not found, and no default driver specified
IM002
This worked fine on Windows. Do I have to change "MySQL ODBC 5.1 Driver"? Why can't it find the data source?
Is there a mailing list I can ask this? UnixODBC?
Hi,
The thing to check is that the entry in {} matches the entry in /etc/odbcinst.ini
There are mailing lists at: http://mailman.unixodbc.org/mailman/listinfo
I would start by creating a DSN entry to your database in /etc/odbc.ini then use isql to check that that works, and then try using the DSN free connection string you are using.