General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thank you John for the quick response, I am using SQLSTRINGCONNECT, however, I don't want to fire SQLDISCONNECT, because it will be used other places in the Application; and, yes, I do close the cursor I create with the stored procedure.
>Hi Monte,
>
>If you're calling an sp, you must be using SQLCONNECT...are you cleaning things up with SQLDISCONNECT? And are you explicitly closing the cursor returned from the SP? VFP won't do that automatically.
>
>
>>I have a form that calls a SQL Server stored procedure that returns a view. The form runs fine, however, after the form is closed, it leaves what I call a hanging datasession open. After, I run the form and the stored procedure fires, I close the form...and it closes O.K., but, the Data Session window shows that a data session still exists it reads "Current Session: Unknown(2)" Does anyone know what's going on here?
>>
>>Thank you,
>>
>>MOnTe
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only