We have an application in ASP running under IIS on Windows 2000. Our Informix database is on HP-UX . The database is in Buffered mode and not in ANSI mode.
When we use <connectionobject>.begintrans on a buffered database I get the error
"Current provider does not support transactions."
The connection string we use is
Provider=Ifxoledbc;Persist Security Info=False;User ID=<userid>;Password=<password>;Data Source=<dbname>@<server>;Extended Properties=''
The OLE-DB provider we are using is Informix OLE DB provider version 2.60.
Is there any way I can support transactions in a Buffered database. It works fine with ANSI mode database