To generate a Connector/ODBC log, do the following:
-
Within Windows, enable the
Trace Connector/ODBC
option flag in the Connector/ODBC connect/configure screen. The log is written to fileC:\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 themyodbcd.dll
driver, see Section 5.3.3, “Troubleshooting ODBC Connection Problems”.On macOS, Unix, or if you are using a DSN-less connection, either supply
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”.