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-10 16:32:06 |
Message-ID: | 20020910163206.9398.qmail@web13807.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Anyone ever tried this successfully?
...from something.asp
<% @TRANSACTION=REQUIRED LANGUAGE=VBSCRIPT %>
<%
response.buffer = true
connstr = "Provider=MSDASQL.1;Persist Security Info=False;Extended
Properties=""DRIVER={PostgreSQL+
(Beta)};DATABASE=somedb;SERVER=db.something.com;PORT=5432;UID=someuser;PWD=somepwd;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=8190;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0"""
set conn = server.createobject("adodb.connection")
conn.open 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?
CG
__________________________________________________
Yahoo! - We Remember
9-11: A tribute to the more than 3,000 lives lost
http://dir.remember.yahoo.com/tribute
From | Date | Subject | |
---|---|---|---|
Next Message | lee johnson | 2002-09-10 16:35:30 | Re: Declare/Fetch with For Update |
Previous Message | alexandre :: aldeia digital | 2002-09-10 14:21:13 | Declare/Fetch with For Update |