PRB: Problems using App/ClassWizard with WATCOM ODBC driver

The information in this article applies to:

• The AppWizard and ClassWizard, included with: Microsoft Visual C++ for Windows, version 1.5

SYMPTOMS

The following problems can occur when connecting to a WATCOM SQL datasource with AppWizard or ClassWizard:

   - The "Select a table" dialog displays without any tables and
     then quickly disappears.

   - or -

   - after selecting a table from the list of tables for a
     WATCOM SQL datasource, a messagebox is displayed with the
     following error:

        SQLGetInfo on SQL_QUALIFIER_NAME_SEPARATOR failed

RESOLUTION

If you are using WATCOM SQL with Visual C++, you must use version 3.2b or higher. Newer versions of WATCOM SQL are available by calling WATCOM Internatioal at 1-800-265-4555.

Once you have version 3.2b or higher, check the following two items:

• Verify that the ODBC.DLL which comes with VC++ 1.5 is being used rather than the one shipped and installed by WATCOM. (NOTE: Currently, WATCOM SQL version 3.2b has an older ODBC.DLL than Visual C++ 1.5. This is the cause of the disappearing table list. Future versions of their product may contain newer versions in which case you shouldn't need to use the ODBC.DLL which is supplied with Visual C++. If uncertain about which ODBC.DLL is newer, run the Visual C++ setup again. Select "Custom Installation" and "MFC Database" to tell the setup program to copy over the ODBC.DLL and other drivers. The setup program will only copy over DLLs such as ODBC.DLL if they are newer.)
• To avoid the SQLGetInfo error shown above, select two checkboxes, "Microsoft Applications" and "Prevent Driver not Capable Errors", when configuring the WATCOM SQL datasource with the ODBC Administrator.