We've got a C/S app that can use various back ends, depending on the client's environment. Among the back ends supported is VFP. In this configuration we use the VFP ODBC driver to connect to the VFP DBC at the back end from our VFP app on the front end.

This has worked fine, but now we're adding transaction processing with a new module. After establishing a connection handle with SQLCONNECT(), sending the SQLEXEC(nhandle,"BEGIN TRANSACTION") command always returns -1. The same code works for SQL Server and Oracle via ODBC, but not for VFP.

Can anyone shed light on what's happening here?