.NET Web service driver error

[leszcz]

Hi all,

I'm trying to develop distributed application in .NET (C#) using Web Services. When I connect to Progress using MERANT 3.60 ODBC Driver or Progress OpenEdge 10.1A driver I get the following error:

ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented. ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed. ERROR [25000] [Microsoft][ODBC Driver Manager] Failed to enlist on calling object's transaction

The code of Web Service is listed below:

public class Service : System.Web.Services.WebService
{
    public Service () {}

    [WebMethod(TransactionOption = System.EnterpriseServices.TransactionOption.RequiresNew)]
    public void test() 
    {
        OdbcConnection conn = new OdbcConnection("DSN=baza;UID=xyz;PWD=xyz");
        conn.Open();
        //...
    }
}

This error occurs only when I use TransactionOption attribute.

Any help would be appreciated.

 

[Casper]

It looks like this is a not supported feature for the driver.
What does this TransactionOption do?
Does it enforces the driver to start a transaction as well?
If so, what happens if you set TransactionOption to Supported?

Ok, I must admit that I'm walking on very thin ice here, since I don't use SQL very often. (Neither .NET by the way.... )

Regards,

Casper.

 

[leszcz]

Thank You Casper,

You have right about that.
I've just got news that distributed transactions are not yet supported by Progress drivers.

Regards,
leszcz