Hi,

We have a simple transactual ASP page (style MTS 2.0 within the ASP scripts) which works fine with MS SQL 6.5 However, when tested against a Sybase 11.5 database (with Intersolv ODBC drivers) it failes and gives the error :

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Failed to enlist on calling object's transaction

We switched to the Intersolv drivers since we know the standard Sybase SQL drivers don't work with MTS, but the Intersolv do !

We also heard, the Microsoft ODBC drivers that come with SQL 6.5 might work against a Sybase 11.5 SQL server. This is true for normal operation, but when turning on transaction required it gives the same error.

I have not included the ASP script, since this that is not the problem.

Can anyone say how he did get the same situation working. I also called Sybase, but the could not give me a direct answer.