- This topic has 8 replies, 4 voices, and was last updated 16 years, 7 months ago by .
-
Topic
-
We are running 5.4 on a AIX clusterd machine with a SQL Server installation on its own Windows cluster. We configured tcl scripts to connect to different tables within the SQL database. These scripts make an initial connection and keep that connection until the process is cycled. However, if we loose connection to our SQL server we have found that our tcl scripts do not auto reconnect and all our messages end up going to the error database. The connection is not reestablished until the process is cycled. We are wondering if anyone that deals with ODBC connections typically uses persistant or non-persistant connections? And how have you dealt with reestablishing a connection if it is lost in a persistant connection world without having to cycle the QDX process?
Thanks,
Barb Dozier
- The forum ‘Cloverleaf’ is closed to new topics and replies.