PRB: Problems using App/ClassWizard with WATCOM ODBC driver |
Q113777
The information in this article applies to:
-
The AppWizard and ClassWizard,
-
Microsoft Visual C++, 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.
Additional query words:
1.50 kbNoUpdate