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/