Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connection Busy - Oracle 8/MS ODBC
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00123916
Message ID:
00123931
Views:
26
Victor,

Usually, a connection busy error occurs when you have two commands executing over the same connection at once. This can happen when views share a connection and the connection is set for asynchronous execution, or if one or more of the views sharing a connection have the FetchSize (# of records to fetch at a time) set to something other than -1 (all).

>I'm using Oracle 8 tables, the MS ODBC Driver for Oracle, and Remote Views. When I try to do a =TableUpDate(.T., .T.) I keep getting a 'connection xxxxx busy' error. I don't think I've had this problem until recently. I've tried changing the 'share connection' option in the remote view, but still same problem. My guess (GUESS being the operative word here - I'm new to Oracle & Remote Views & ODBC) is that I've screwed up the view somehow. Anyone have any ideas on where I should look? Thanks.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform