FIX: SQLDISCONNECT() May Cause Exception Error in Visual FoxPro (140613)

Microsoft Visual FoxPro for Windows 3.0

Microsoft Data Access Components 2.5

This article was previously published under Q140613

SYMPTOMS

In Visual FoxPro 3.0, Using the SQLDISCONNECT() function sometimes causes Visual FoxPro to quit and display an "Exception error."

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Visual FoxPro 3.0b for Windows.

MORE INFORMATION

Steps to Reproduce Problem

To reproduce this problem, a valid ODBC Data Source setup must be available on the system.

In the Command window, type the following code:
```
   ?SQLSTRINGCONNECT()
						
```
Click Cancel when the SQL Data Source dialog box appears or click OK if an 'Execution was canceled by user' dialog box appears.
Type the following in the Command window:
```
   ?SQLCONNECT()
						
```
Select a valid DataSource. You should receive a 1 for a connection handle.
Type the following in the Command window:
```
   ?SQLDISCONNECT(1).
						
```
Visual FoxPro quits with "Exception error" or "This program has performed an illegal operation and will be shut down."

Modification Type:

Major

Last Reviewed:

10/15/2003

Keywords:

kbbug kbfix KB140613