Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unknown Datasession
Message
From
05/10/1999 14:25:11
 
 
To
05/10/1999 14:21:38
Monte Murdock
Universal American Mortgage Company
Clearwater, Florida, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00272841
Message ID:
00272847
Views:
21
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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform