Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connectivity Error: Invalid cursor state
Message
De
02/04/2005 18:29:13
 
 
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:
01001055
Vues:
22
>>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?
>
>WAG, try GO TOP.

Thanks for the reply, Sergey, but it doesn't work. There are a number of connection properties but I have no experience with them at all. What does WAG mean?

Thanks a lot.

Alex
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform