PRB: Query with DBEXEC() Causes GP Fault Under Windows NT

- Microsoft FoxPro for Windows, versions 2.5, 2.5a, 2.5b, and 2.6

SYMPTOMS

When you use the DBEXEC() function (in the FoxPro Connectivity Kit) to execute a query using one of the ODBC Desktop Database Drivers, a general protection (GP) fault occurs.

CAUSE

The files associated with the ODBC Desktop Database Drivers conflict with the FoxPro Connectivity Kit when FoxPro for Windows is running under Windows NT version 3.1.

RESOLUTION

A resolution has not yet been determined. To avoid this problem, do not use the ODBC Desktop Database Drivers with FoxPro for Windows when FoxPro is running under Windows NT version 3.1.

STATUS

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

The Microsoft ODBC Desktop Database Drivers use a common database engine that resides in a file called SIMBA.DLL. The ODBC Desktop Database Drivers that use SIMBA.DLL include drivers used to access the following file types: Microsoft Access, Microsoft FoxPro, dBASE III, dBASE IV, Paradox, Btrieve, and Microsoft Excel.

Since these drivers all use SIMBA.DLL, a GP fault may occur when these drivers are used with the Connectivity Kit when FoxPro for Windows is running under Windows NT 3.1.

Sample Code

   SET LIBRARY TO FPSQL ADDITIVE
   xhandle = dbconnect(<data source name>,'','')  &data source has already
                       * been set up using the ODBC icon in Control Panel.
   z=dbexec(xhandle,"Select * from CUSTOMER")
   BROWSE
   =dbdisconnect(xhandle)
   RELEASE LIBRARY FPSQL