Hi,
Is it possible use transactions with fox2.6 and Visual Basic with ADO 2.0?

I am converting existing Informix New Era programs to Visual Basic.
New Era, using Intersolv's 2.11 driver has the capability to begin a
transaction (actually, its automatic) and commit or rollback.

I need to replicate this behaviour with Visual Basic using the
ADO.connection object but I am getting the message :

'The operation requested by the application is not supported by the
provider'

when I try to myFoxConn.BeginTrans

I have had no problems with transactions on SQL Server and Informix
databases.

My question is - is there a 32 bit foxpro driver out there that supports transactions? If not, is there a workaround? And also, if not, why is there a 16 bit foxpro driver that can support transactions and not a 32 bit with the same capability.

Environment: NT4 SP4, VB5, ADO2.0, DASDK (ADO2.0)
The FoxDriver (3.51.171300) is from the MS DASDK

Well, that's it - if anyone has any suggestions I'd be mightily happy....

Thank you,
John