Getting intermittent 800a01fb errors - repost... - Mailing list pgsql-odbc

From Chris Gamache
Subject Getting intermittent 800a01fb errors - repost...
Date
Msg-id 20030619154027.47659.qmail@web13806.mail.yahoo.com
Whole thread Raw
List pgsql-odbc
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

pgsql-odbc by date:

Previous
From: Chris Gamache
Date:
Subject: Getting intermittent 800a01fb errors
Next
From: "Dave Page"
Date:
Subject: Re: Bug in ODBC driver doing UPDATES and DELETES (fwd)