Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reconnect a remote view to SQL server.
Message
From
05/07/2006 05:24:05
Aleksey Tsingauz
Microsoft
Seattle, Washington, United States
 
 
To
05/07/2006 03:03:15
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Reconnect a remote view to SQL server.
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01133536
Message ID:
01133746
Views:
33
>but in a test I already tried that. Sometimes success, sometimes it just does not work: The view won't reconnect.
>

Hi Walter,

This may happen with shared connection. If ODBC connection is shared between multiple SPT connections, SQLIDLEDISCONNECT() must be called for all of them, ODBChdbc property should return 0 in order to automatically reestablish "broken" connection.

Thanks,
Aleksey.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform