[ 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=1000624&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Patrick Donelan (patspam)
Assigned to: Nobody (None)
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.htm)

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

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