Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connectivity Error: Invalid cursor state
Message
 
 
À
02/04/2005 17:58:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01001052
Message ID:
01001100
Vues:
15
This message has been marked as the solution to the initial question of the thread.
>A form uses a remote view into a SQL Server database. One of the fields is Varchar 8000 bytes which comes over as memo field. As the form is opened and the contents of the field are accessed in the corresponding editbox init, there is a message Connectivity Error: [Microsoft][ODBC Driver Manager] Invalid cursor state. I placed a set step on in the editbox init, and voila, no error appears.
>
>Suspecting a timing problem I added a delay. This solves the problem but requires about a 7 second delay. Is there a way to have VFP make the first record available immediately and continue fetching in the background?
>
>TIA, Alex

I know you found your solution, but I encountered this error recently and it was because my SQLGETPROP(0, 'Transactions') was somehow set to 0. When I set it back to 1 (default), I no longer had the problem. The zero setting was behaving like setting 2 for manual transactions. So I had to issue either a SQLCOMMIT() or SQLROLLBACK(). Just a guess, but using TABLE buffering may also help.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform