[ 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,
withoutrequiring you to interact with the transaction itself. A transaction scope can select and manage the ambient
transactionautomatically. Due to its ease of use and efficiency, it is recommended that you use the TransactionScope
classwhen 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
automaticallyenlist. 


(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