Sage 100

 View Only

  • 1.  Sage 100 2019 ODBC Connection

    Posted 11-12-2019 19:13
    ​​I recently upgraded client from Sage 100 Premium 2014 to Sage 100 Premium 2019. There are a few reports I need to tweak in Crystal Reports, but I am not getting the standard login screen when I try to connect to the database to add fields or browse data. In the past, I would just change the data source from the silent connection string that is specific to the report to the SOTAMAS90 DSN that is installed when you run workstation setup. However, Sage no longer loads the SOTAMAS90 DSN in workstation setup, so I am stuck with this Connection Information dialogue box that isn't accepting any credentials I type in. The information the dialogue box prompts for is:

    Server
    User ID
    Password

    For the Server, I have tried the Sage host server name (simple and fqdn) and the Sage SQL database server name (with and without the SQL Server instance name) For the User ID and Password, I have tried a domain user/password, several Sage users/passwords, and the SQL sa user/password.

    I thought about re-creating the SOTAMAS90 DSN, but then I would have to roll out that DSN to all workstations for the report to work. I may end up doing that eventually, but I would much rather just leave it alone and log in using the dialogue box.

    Has anyone seen any documentation on this that doesn't tell you to revert to the SOTAMAS90 DSN?

    ------------------------------
    Raymond Westcott
    MBSG
    ------------------------------


  • 2.  RE: Sage 100 2019 ODBC Connection

    Posted 11-12-2019 23:27
    I believe you may need to update the Mas_Reports password in the SQL setting utility. That gets assigned dynamically (randomly?) At the time of install. Try updating that then using that account and see if it lets you log in.

    ------------------------------
    Michelle Forsey
    Eide Bailly, Inc.
    801-456-5470
    ------------------------------



  • 3.  RE: Sage 100 2019 ODBC Connection

    Posted 11-13-2019 13:13
    I changed the MAS_REPORTS password in SQL and updated it in the Sage 100 Premium 2019 SQL Settings tool. I am still getting the following error when I try to log in to the data connection from Crystal Reports:

    Logon failed.
    Details: S0000:[ProvideX][ODBC Driver][PVKIO]Logon failed [Database Vendor Code: 145 ]

    This is so odd to me. You would think that there would be some documentation somewhere on which credentials to use.

    This is now a moot point, however. I was able to find the error in the report formula without having to connect to the database and fix it.

    ------------------------------
    Raymond Westcott
    MBSG
    ------------------------------

    Original Message


  • 4.  RE: Sage 100 2019 ODBC Connection

    Posted 11-13-2019 13:16
    Did you run mascrcw.exe?

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------

    Original Message


  • 5.  RE: Sage 100 2019 ODBC Connection

    Posted 11-13-2019 13:18
    I did after the first migration for testing, but not after the second go live migration. I will try it on that one report file and see if that helps.

    ------Original Message------

    Did you run mascrcw.exe?

    ------------------------------
    Doug Higgs
    Assistant Technical Support / Building Maintenance Specialist
    Midwest Commerce Solutions, Inc
    ------------------------------


  • 6.  RE: Sage 100 2019 ODBC Connection

    Posted 11-14-2019 15:33

    Hi Ray,

       In Premium, you are not connecting to a Providex database via the Sage ODBC but rather you use the SQL connector.  I constantly forget that.. 

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378 ext. 402    f 714.282.0235

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    MCP_SE_Small.bmp

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     

     

     

     



    ------Original Message------

    ​​I recently upgraded client from Sage 100 Premium 2014 to Sage 100 Premium 2019. There are a few reports I need to tweak in Crystal Reports, but I am not getting the standard login screen when I try to connect to the database to add fields or browse data. In the past, I would just change the data source from the silent connection string that is specific to the report to the SOTAMAS90 DSN that is installed when you run workstation setup. However, Sage no longer loads the SOTAMAS90 DSN in workstation setup, so I am stuck with this Connection Information dialogue box that isn't accepting any credentials I type in. The information the dialogue box prompts for is:

    Server
    User ID
    Password

    For the Server, I have tried the Sage host server name (simple and fqdn) and the Sage SQL database server name (with and without the SQL Server instance name) For the User ID and Password, I have tried a domain user/password, several Sage users/passwords, and the SQL sa user/password.

    I thought about re-creating the SOTAMAS90 DSN, but then I would have to roll out that DSN to all workstations for the report to work. I may end up doing that eventually, but I would much rather just leave it alone and log in using the dialogue box.

    Has anyone seen any documentation on this that doesn't tell you to revert to the SOTAMAS90 DSN?

    ------------------------------
    Raymond Westcott
    MBSG
    ------------------------------


Related Content