>create database tovistar
I am not 100& sure, but I think you are setting to manual transactions the wrong connection handle.

>create sql view &mtable remote connection tovistar as select * from &mtable

See, the above has no SHARED in it...so when you do this:

>SELECT 2
>USE (MDATATABLE)

You are actually creating a new connection to the SQL server.  I would say either add a shared to the view... or... after you do the above do:

nTestHandle = cursorgetprop('ConnectHandle',mdatatable)

If you compare nTestHandle to nHandle I think they will be different.

So, when you do this:
>	sqlsetprop(nHandle, 'transactions', 2)
>	sqlsetprop(nHandle, 'PacketSize', 40960)

You are really setting properties of the wrong connection.

Let me know if this is the solution.

BOb