Skip to main content

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?


#Acu4GL

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?


#Acu4GL
which COBOL product are you using? Visual COBOL (if so, this post should be placed in the Visual COBOL portion of the forum), AcuCOBOL, and if so, Acu4GL for MSSQL or AcuSQL?

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?


#Acu4GL
Acu4GL for MSSQL

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?


#Acu4GL
The configuration variables:
DEFAULT-CONNECTION value-is-the -server-name
A-MSSQL-LOGIN login-name
A-MSSQL-PASSWD password-value
A-MSSQL-DATABASE - database name
A-MSSQL-LOCK-DB - the lock database name

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?


#Acu4GL
I am aware of these variables.
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.

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?


#Acu4GL
[deleted]

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?


#Acu4GL
Acu4GL makes a connection to only one server, and that connection cannot be reset to a different server. You can access tables on another server with an alias, "MYTABLE OTHERSERVER.DBNAME.DBO.MYTABLE" but I don't think that will work if the credentials are different. What you should probably do is create a Linked Server to the second server within the first server.
Terms & ConditionsAccessibility statement