Sage 100

 View Only

  • 1.  ODBC Connection when Sage is on a different Domain

    Posted 12-16-2024 17:07

    I have a client that is moving from one domain to another. Their Sage is on one domain, while their users are on another one. On their shipping workstations, they use UPS and FedEx applications. They have created a silent connection to get data. With this change the ODBC is not working. 

    Anyone have an idea on how I can get the ODBC to work across networks? I tried a Mapped Drive, IP and using the server Named but none work. Client is on Sage Advance. 

    Thank you,



    ------------------------------
    Tina Meacham
    RKL eSolutions, LLC
    ------------------------------


  • 2.  RE: ODBC Connection when Sage is on a different Domain

    Posted 12-16-2024 17:17
    Edited by Kevin Moyes 12-16-2024 17:18

    For Providex ODBC the domain doesn't matter... only Windows permissions do.

    Windows Credentials Manager might help.

    Edit:  Check firewall permissions too.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: ODBC Connection when Sage is on a different Domain

    Posted 12-17-2024 10:26

    We did try the Windows Credentials and confirmed that the user name and password were entered. I'll check firewalls next. 



    ------------------------------
    Tina Meacham
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 4.  RE: ODBC Connection when Sage is on a different Domain

    Posted 12-17-2024 10:57

    Do those credentials have proper permissions on the \\server\share\MAS90 folder?



    ------------------------------
    Phil McIntosh
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 5.  RE: ODBC Connection when Sage is on a different Domain

    Posted 12-17-2024 16:59

    For Advanced, if you are using CS/ODBC, be sure to check tab 2 of the silent DSN... which is where that setting is enabled.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


Related Content