BUG: Error "Invalid Page Fault" When Connecting to Sybase

 Last reviewed: April 24, 1997
Article ID: Q163935
The information in this article applies to:
  • Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 5.0a

SYMPTOMS

The following error occurs after disconnecting from Sybase server and reconnecting: 

   "VFP caused an invalid page fault in module LIBCOMN.DLL"
This error occurs if the SQLCONNECT() function is used for connecting, and two or more connections have been made to Sybase 10 or 11. When any connection that was created before the last connection is terminated and then another connection is created, the error occurs. However, it only occurs with Sybase and the Sybase ODBC driver from Intersolv. Other database servers, such as SQL Server and Oracle, work correctly.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

If an SQL connection is created with the SQLCONNECT() function, a numerical value is stored to the connection handle of the connection. If the value is greater than zero, then the connection is valid. The first connection usually has a value of one, and the second of two, and so forth. When one of the connections before the last connection is terminated, that termination leaves a lower number available for a future connection to use. Creating a new connection that uses one of these lower numbers causes the error.

Steps to Reproduce Behavior

Issuing the following code in a program (.PRG) file or from the Command window will cause the error to occur. After issuing each SQLCONNECT() function, you need to select the data source for Sybase and enter the correct UserId and password in the Logon dialog box. Note that x and y must return numbers greater than zero to ensure a valid connection: 

      x = SQLCONNECT()
      ? x
      y = SQLCONNECT()
      ? y
      = SQLDISCONN(x)
      z = SQLCONNECT()
      ? z

Keywords : BUGLIST3.00 BUGLIST3.00b BUGLIST5.00 FxprgClientsvr kb3rdparty vfpbug5.0a kbbuglist
Version : 5.0a 3.0 3.0b 5.0
Platform : WINDOWS
Issue type : kbbug

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: April 24, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.