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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement