• "Logon Failed" error attempting to read Sage 100 ERP 2014 data using ASP.NET & IIS 8

    I have an ASP.NET 4.0 site running on IIS 8. The application pool is set to enable 32bit applications. I have created a 32bit DSN that accesses Sage 100 ERP 2014 data. It successfully returns tables when I test it. When I try to read any data from Sage…
  • Multiple connections to SOTAMAS90 in Crystal Report

    This is occurring in Crystal Reports XI R2 with Sage 100 ERP 4.5. Client has created a custom report pulling data from AR_InvoiceHistoryHeader, AR_Salesperson, and AR_Customer. Link to AR_Customer from AR_InvoiceHistoryHeader is a left outer join connecting…