Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connectivity Error: Invalid cursor state
Message
 
 
To
02/04/2005 17:58:26
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01001052
Message ID:
01001100
Views:
14
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform