Thread: Getting intermittent 800a01fb errors - repost...

Getting intermittent 800a01fb errors - repost...

From
Chris Gamache
Date:
PgODBC 7.02.50.00

Microsoft VBScript runtime error '800a01fb'

An exception occurred: 'conn.execute'

/script.asp, line 75

-=-

Line 75 in (pseudo) context:

set conn = server.createobject("adodb.connection")
conn.open connstr
sql = "select something from sometable;"
conn.execute(sql) 'dies here

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...

Any ideas?

CG

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com