🚀 go-pugleaf

We have an existing multi-user database on VDB 5.5 using DBF files over a
network.

In an experiment to see if we can get better performance (especially from
another site linked by a 28k leased line) we are playing with MS SQL server
6.5 (evaluation) version.

We have successfully set up SQL server driver through ODBC and BDECFG so
that we can see SQL databases in VDB, but cannot get transaction processing
to work.

for example if we do

open database lops
set database to lops
use customer
goto bottom
begintrans()

we get "General SQL error" It's as though the goto operation is opening an
implicit transaction or something.

Are we doing something wrong or what?

Thanks

John Jameson