Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Difference between connection handle and string?
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Difference between connection handle and string?
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01388455
Message ID:
01388455
Views:
121
What are the differences between remote views opened with the statement handle vs. the connection string?

I switched from the Use .... ConnString cString to Use ... ConnString nHandle to improve performance but it has caused a host of serious problems. I get sporadic 'Connection Busy' messages and, when testing via remote desktop, received some serious error messages including a "Server System Failure" message that terminated the RDC session. Obviously, using the statement handle requires some other modifications. What are they? Is there a difference between the lShared parameter and the cString,lSharable form of SqlStringConnect? Obviously performance is of little importance if the application no longer runs!
Next
Reply
Map
View

Click here to load this message in the networking platform