Hi all,

I have a local database with a connection to mssql database (2012 release)

When I do:

OPEN DATABASE ngaslgu
CREATE CONNECTION MyConn DATASOURCE "&cDSNName" USERID "&cDbUserId" PASSWORD "&cDbPassword" DATABASE "&cDbName"
=MESSAGEBOX( sqlconnect('MyConn' ) )

All seems fine, and a following command "=MESSAGEBOX( sqlconnect('MyConn' ) )" returns 1

After this, what I need is an automatic update from any saved local record to the MsSql database.. But... nothing works..

To deal with that, I tried the "wizard upsizing" procedure... but, the message to run "sp_dbcmptlevel" with level 65 comes up... On MSsql I tried to run "EXEC sp_dbcmptlevel ngaslgu, 100;" (try both 90, 100, 110)... but, nope!

Please, can someone point me a path to deal with this situation... Any help will be appreciated.

TIA