5.3.3 Troubleshooting ODBC Connection Problems

This section answers Connector/ODBC connection-related questions.

• While configuring a Connector/ODBC DSN, a Could Not Load Translator or Setup Library error occurs

  For more information, refer to MS KnowledgeBase Article(Q260558). Also, make sure you have the latest valid ctl3d32.dll in your system directory.

• The Connector/ODBC .dll (Windows) and .so (Linux) file names depend on several factors:

  Connector/ODBC Version: A digit in the file name indicates the major Connector/ODBC version number. For example, a file named myodbc9w.dll is for Connector/ODBC 9.x whereas myodbc5w.dll is for Connector/ODBC 5.x.

  Driver Type: The Unicode driver adds the letter "w" to file names to indicate that wide characters are supported. For example, myodbc9w.dll is for the Unicode driver. The ANSI driver adds the letter "a" instead of a "w", like myodbc9a.dll.

  GUI Setup module: The GUI setup module files add the letter "S" to file names.

• Enabling Debug Mode: typically debug mode is not enabled as it decreases performance. The driver must be compiled with debug mode enabled.