Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLView in VFP - connection busy
Message
From
12/04/2005 10:24:52
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQLView in VFP - connection busy
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01003731
Message ID:
01003731
Views:
119
Hi all!

We've encountered a strange problem in our software concerning VFP-SQLViews.

* we create several SQLViews in our VFP code (CREATE SQL VIEW ... REMOTE CONNECTION ... AS SELECT ...).
* we use TABLEUPDATE(.T.) to save the changes

During this above mentioned process sometimes the error message 1541 CONNECTION IS BUSY appears when using TABLEUPDATE(.T.).

Can anybody tell us what causes this error and how to get rid of this error.

TIA
robert.oh.
Next
Reply
Map
View

Click here to load this message in the networking platform