Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connection Busy - Oracle 8/MS ODBC
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00123916
Message ID:
00123941
Vues:
27
Josh,
A definate step in the right direction. Situation is this: I have asynchronous checked in the connection, I'm only using 1 remote view in my test form. If I have the FrechSize set to anything less than the total number of records then I get the 'Connection Busy' error. If I have change the ShareConnection setting in the view, same problem. (Which I guess makes sense because their is only one remote view for the form).
->My problem is that I don't want to have to fetch ALL the records, I just want to fetch one at a time. Is this possible? And even if it is, is it a dumb idea to do so? My assumption is that if user#1 changes a record, then user#2 will see the change right away (when they go to the 'changed' record) if the 'fetching' gizmo is set to 1, right?

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.
ICQ 10556 (ya), 254117
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform