Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC call hangs NT4
Message
From
29/06/2000 05:45:17
Alec Dearden
Peterborough Hospitals Nhs Trust
Peterborough, United Kingdom
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
ODBC call hangs NT4
Miscellaneous
Thread ID:
00386330
Message ID:
00386330
Views:
46
Hi,

I am using SPT calls to a Sybase server via ODBC. The call is bring back large amounts of data to a local table for storage and thus takes a long time (about 30 minutes). This all works OK and the fact that the query takes 30 minutes is not a problem.
However, whilst the query is executing, NT4 (workstation) seems to hang and does not allow other applications to start up, if you look in task manager, VFP is shown as "not responding".
Is there anyway to prevent this, should I try using Asynchronous calls ?

Hope someone can help !
Alec.
Next
Reply
Map
View

Click here to load this message in the networking platform