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

ID: Q128733

The information in this article applies to:

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

Last Reviewed: June 27, 1995