Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Connections
Message
From
27/10/2003 03:36:47
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
SQL Connections
Miscellaneous
Thread ID:
00842822
Message ID:
00842822
Views:
42
I have a program that needs to connect to 6 servers and get data from each, this data collection happens every 3 or 4 mins 24/7

At present I connect and disconnect to each server in turn and disconnect after the data has been gathered. I am using

CONNECTION_STRING='DRIVER={SQL Server};SERVER='+LCSERVER +';' + ; 'DATABASE='+LCDATABASE+';UID=useername ;PWD=password

*!* Connect to SQL Server

GNCONNHANDLE=SQLSTRINGCONN(CONNECTION_STRING)

but this create a high server overhead, so I would like to have all servers connect connect at the same time and not drop them. but how can I find if the connect is still valid without causing an error, and being able to re connect the lossed server again.
Next
Reply
Map
View

Click here to load this message in the networking platform