To generate a Connector/ODBC log, do the following:
Within Windows, enable the
Trace Connector/ODBCoption 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.dlldriver, see Section 126.96.36.199, “Troubleshooting ODBC Connection Problems”.
On macOS, Unix, or if you are using a DSN-less connection, either supply
OPTION=4in 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 6.9.1, “Connector/ODBC Community Support”.