Sybase ase driver timeout on IIS - 10-09-2003 , 02:36 AM
We have an IIS 5, Win2K server, which has a Sybase ASE 12 driver
installed ( I believe that's aka open client ). ASPs on that machine
connect to a Sybase ASE 126.96.36.199 HP-UX server via ODBC 3.5. We are
finding that our connection object in the vb script code becomes
disconnected after 60 seconds and we can see the connection is dropped
in sql advantage using sp_who. We are not setting any command timeouts
in our vb script. What is dropping this connection? And how can we
prevent it? We are also connecting to mssql 2000 server without a
problem. Is there a client timeout value setting somewhere that is
causing this that we can change?
Thank you for your help.