Getting intermittent 800a01fb errors - repost...

From: Chris Gamache <cgg007(at)yahoo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Getting intermittent 800a01fb errors - repost...
Date: 2003-06-19 15:40:27
Message-ID: 20030619154027.47659.qmail@web13806.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2003-06-19 16:11:13 Re: Bug in ODBC driver doing UPDATES and DELETES (fwd)
Previous Message Chris Gamache 2003-06-19 15:36:17 Getting intermittent 800a01fb errors