PRB: Specified Driver Could Not Be Loaded: Watcom SQL Server

 Last reviewed: June 27, 1995
Article ID: Q128733
The information in this article applies to:
  • Microsoft FoxPro for Windows, version 2.6a

SYMPTOMS

When using the DBConnect() function to connect with Watcom SQL Server, the following error message may be produced: 

   ODBC error IM003 (0): [Microsoft][ODBC DLL]
   Specified driver could not be loaded.
This article explains how to resolve this error message when working with a copy of Watcom SQL Server that was bundled with PowerBuilder.

RESOLUTION

To verify that the Watcom driver is correctly installed, attempt to establish a connection to the Watcom SQL Server from a different client, such as PowerBuilder or Microsoft Query. If it is not possible to establish a connection to the Watcom SQL Server from these clients, it is likely that the Watcom driver is incorrectly installed. In this case, the Watcom documentation should be consulted to ensure that the driver and SQL Server are installed correctly.

If it is possible to establish a connection to the Watcom SQL Server from PowerBuilder or Microsoft Query, but the "Specified driver could not be loaded" error message is experienced when attempting to connect to the server from FoxPro, check the driver name specified as the first parameter of the DBConnect() function. If the data source name specified as the first parameter of the DBConnect() function is correct, it is possible that the PowerBuilder directory is not in the MS-DOS path. In some cases, it may not be possible to use the Watcom SQL Server ODBC driver from FoxPro if the PowerBuilder directory is not in the MS-DOS path. If the PowerBuilder directory is not in the MS-DOS path, edit the AUTOEXEC.BAT file to add the PowerBuilder directory to the path, then reboot the computer so this change becomes effective. As a temporary measure, the PowerBuilder directory can also be added to the MS-DOS path at the MS-DOS command line.

Additional reference words: FoxWin 2.60a
KBCategory: kbother kbprb
KBSubcategory: FxotherGeneral

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 27, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.