Skip to main content

SQL-Access

  • March 9, 2018
  • 6 replies
  • 0 views
Paschi Lehmann

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

    6 replies

    Stephen Hjerpe
    • Stephen Hjerpe
    • Participating Frequently
    • March 9, 2018

    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?
    Paschi Lehmann
    • Paschi Lehmann
    • Author
    • New Participant
    • March 9, 2018

    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
    Stephen Hjerpe
    • Stephen Hjerpe
    • Participating Frequently
    • March 9, 2018

    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
    Paschi Lehmann
    • Paschi Lehmann
    • Author
    • New Participant
    • March 12, 2018

    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.
    Stephen Hjerpe
    • Stephen Hjerpe
    • Participating Frequently
    • March 12, 2018

    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]
    D

    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.

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement