Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Connections
Message
De
27/10/2003 03:36:47
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
SQL Connections
Divers
Thread ID:
00842822
Message ID:
00842822
Vues:
43
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform