How can I access an SQL table located on another server/instance with an SQL login user/password?
With the assignment in the configuration file, such as
MPStamm Server. Demo. VFinanz. MPStamm
it works. But how can I add user and password to the linkage with server/Instance?
DEFAULT-CONNECTION value-is-the -server-name
A-MSSQL-DATABASE - database name
A-MSSQL-LOCK-DB - the lock database name
If I have two different connections in the identical program, can I reset the variables before the table is open? In that case, it solves my problem.