[ psqlodbc-Bugs-1000624 ] TransactionScope using{...} block throws exception in .NET 2

Bugs item #1000624, was opened at 2006-05-03 03:13
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10006 24&group_id=1000125

Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Patrick Donelan (patspam)
Assigned to: Hiroshi Inoue (hinoue)
Summary: TransactionScope using{...} block throws exception in .NET 2

Initial Comment:
Summary:
--------
psqlodbc version 8.02.00.02 throws an exception when trying to use System.Transactions.TransactionScope to manage transactions.

How to reproduce:
-----------------
The following code:

using System.Transactions;
using System.Data.Odbc;
using (TransactionScope ts = new TransactionScope())
{
OdbcConnection cnDB = new OdbcConnection(builder.ConnectionString);
cnDB.Open();
}

Throws: ERROR [HY000] Unsupported connect attribute (Set)

My psqlodbc log is attached.

Detailed Information:
---------------------
From MSDN: The TransactionScope class provides a simple way to mark a block of code as participating in a transaction, without requiring you to interact with the transaction itself. A transaction scope can select and manage the ambient transaction automatically. Due to its ease of use and efficiency, it is recommended that you use the TransactionScope class when developing a transaction application.

In addition, you do not need to enlist resources explicitly with the transaction. Any System.Transactions resource manager (such as SQL Server 2005) can detect the existence of an ambient transaction created by the scope and automatically enlist.

(ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.VisualStudio.v80.en/dv _fxtransactions/html/1ddba95e-7587-48b2-8838-708c275e7199.ht m)

------------------------------------------------------------ ----------

Comment By: Patrick Donelan (patspam)
Date: 2006-05-19 02:29

Message:
It works great. Thanks Hiroshi! Very much appreciated :)

Regards,

Patrick

------------------------------------------------------------ ----------

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-05-13 23:45

Message:
Sorry for the late reply.

Please look at the page http://support.microsoft.com/default.aspx?scid=kb;EN-US;8170 66
and try the latest dll at
http://www.geocities.jp/inocchichichi/index.html .

regards,
Hiroshi Inoue

------------------------------------------------------------ ----------

Comment By: Patrick Donelan (patspam)
Date: 2006-05-03 14:59

Message:
Trying again (missed the attach checkbox).

Patrick

------------------------------------------------------------ ----------

Comment By: Patrick Donelan (patspam)
Date: 2006-05-03 14:57

Message:
mylog attached.

Regards,

Patrick

------------------------------------------------------------ ----------

Comment By: Hiroshi Inoue (hinoue)
Date: 2006-05-03 10:16

Message:
Please send me the Mylog output.

regards,
Hiroshi Inoue

------------------------------------------------------------ ----------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10006 24&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend