Skip site navigation (1) Skip section navigation (2)

PostgreSQL+ (Beta) and Active Server Pages with @TRANSACTION=REQUIRED

From: Chris Gamache <cgg007(at)yahoo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: PostgreSQL+ (Beta) and Active Server Pages with @TRANSACTION=REQUIRED
Date: 2002-09-05 19:18:31
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
Anyone ever tried this successfully?

...from something.asp

response.buffer = true
connstr = "Provider=MSDASQL.1;Persist Security Info=False;Extended

set conn = server.createobject("adodb.connection") connstr
sql = "select * from some_table where some_column = 'something';"
set rs = conn.execute(sql)

I then get...

Microsoft OLE DB Provider for ODBC Drivers error '8004d00a' 

Unknown connect option (Set) 

something.asp, line 7


Running the script outside of an MTS transaction works fine. It crashes inside.
I was hoping that PostgreSQL+ would address this... Any ideas?


Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes

In response to


pgsql-odbc by date

Next:From: Jason KoeningerDate: 2002-09-06 02:39:15
Subject: Thread Safety of ODBC Driver
Previous:From: Marc BirkettDate: 2002-09-05 09:02:33
Subject: psqlODBC and MS-Access

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group