Are you closing all of your open database connections after using them?
: Hi Guys,
: My Code is
: set conn = server.createobject("adodb.connection")
: conn.open connstr
: sql = "select something from sometable;"
: This will run fine for days, and then suddenly start to malfunction on every 5th (or so) page pull. When this happens, the number of database connections to
: postgresql grows linearly and won't shrink until I restart webservices on IIS (5.0). After the restart (or a simple unload of the isloated app) Everything runs fine until the next time the error occurs.
: I am developing on Windows 2000 Server
: If any one can Help... Thanx in advance
'// Programmed By: Zantos