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

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

From: Chris Gamache <cgg007(at)yahoo(dot)com>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: PostgreSQL+ (Beta) and Active Server Pages with @TRANSACTION=REQUIRED
Date: 2002-09-12 16:44:41
Message-ID: 20020912164441.96976.qmail@web13804.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Perhaps, but the MS Access ODBC Driver would run in an MTS transaction, even
though there is no transaction support in access.

I use ODBC like I drive my car. I put in the key, turn it, and it just works.
What could I do to get under the hood and find out what this mysterious "Set"
thing might require to function properly?

I don't care to even have the PostgreSQL transaction auto-roll-back when the
MTS Transaction fails. I need the transaction support for the larger operation
of which the database transactions are a small part.

CG

--- Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> wrote:
> 
> 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/


__________________________________________________
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com

In response to

pgsql-odbc by date

Next:From: robinDate: 2002-09-13 06:21:40
Subject: how to write odbc sql in visual c++6.0
Previous:From: Dave PageDate: 2002-09-12 10:27:45
Subject: Re: [HACKERS] ODBC problem/question

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