>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

John,

Fox 2.X doesn't support Transaction handling. I believe its the data source not ADO that has to handle Transactions. Fox 3.0 and above have true database containters and can handle transactions.

You could get updated ODBC drivers from the MS VFP Site msdn.microsoft.com/vfoxpro

DJ