My install using the new driver (ODBC) seems to have helped me a great deal. Unfortunately one of my night jobs uses a dynamic cube product that does a record set. I am not certain but I have the feeling it is leaving the connection open. After a few days (always at night when the program runs) I end up running out of connections (was set to 600 I upped it a bit). Is there something I can do to ensure they get closed in a given period of time?
Joel Fradkin
|