Re: PostgreSQL+ (Beta) and Active Server Pages with

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: cgg007(at)yahoo(dot)com
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: PostgreSQL+ (Beta) and Active Server Pages with
Date: 2002-09-12 10:07:13
Message-ID: 3D806751.F6BAB81D@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Chris Gamache wrote:
>
> 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?

Maybe MTS requires Distributed transaction support but
PostgreSQL(and of cource psqlodbc driver) doesn't support it.
I'm not sure if MTS provides the option to work with non-
distributed system.

regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2002-09-12 10:27:45 Re: [HACKERS] ODBC problem/question
Previous Message Michael Meskes 2002-09-11 17:32:32 Re: [HACKERS] ODBC problem/question