To generate a Connector/ODBC log, do the following:
Within Windows, enable the
Connector/ODBC option flag in the Connector/ODBC
connect/configure screen. The log is written to file
C:\myodbc.log. If the trace option is
not remembered when you are going back to the above
screen, it means that you are not using the
myodbcd.dll driver, see
Section 5.3.3, “Troubleshooting ODBC Connection Problems”.
On OS X, Unix, or if you are using a DSN-less connection,
OPTION=4 in the
connection string, or set the corresponding keyword/value
pair in the DSN.
Start your application and try to get it to fail. Then check the Connector/ODBC trace file to find out what could be wrong.
If you need help determining what is wrong, see Section 9.1, “Connector/ODBC Community Support”.