PostgreSQL+ (Beta) and Active Server Pages with @TRANSACTION=REQUIRED
От | Chris Gamache |
---|---|
Тема | PostgreSQL+ (Beta) and Active Server Pages with @TRANSACTION=REQUIRED |
Дата | |
Msg-id | 20020905191831.40236.qmail@web13805.mail.yahoo.com обсуждение исходный текст |
Ответ на | psqlODBC and MS-Access ("Marc Birkett" <MBirkett@emc-ltd.co.uk>) |
Ответы |
PostgreSQL+ (Beta) and Active Server Pages with @TRANSACTION=REQUIRED
|
Список | 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 __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com
В списке pgsql-odbc по дате отправления: