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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only