• Sage 100 2022 Premium Crystal Reports Database Login Failed. Unable to connect: Incorrect log on parameters

    Hello I'm upgrading from 2018 Advance to 2022 Premium. When on the server we can run canned reports within Sage 2022 without error. When we try and run reports from a client 2022 workstation we get "The database login failed. Error in File GL_ChartofAccountxxx…
  • Detect when table gets updated

    Hello, We currently have Windows services (written in C#, .NET) that push data out from some Sage tables to a custom API, which then stores it in a private SQL Server Database. Depending on the service, it might trigger every minute, every 5 minutes…
  • ODBC Driver to Sage works, Linked Server fails with SQLSetConnectAttr failed

    Hello- I'm having trouble getting a linked server to our Sage instance working. The ODBC driver tests successfully, but the linked server always returns the same error- SQLSetConnectAttr failed. Confoundingly it does work on our Staging environment…
  • Linked server connection fails but ODBC DSN always works

    I setup a 64 bit System DSN to Sage 2022. It's configured as a silent connection and the debug option always works. I'm trying to setup a linked server connection using that system DSN but it always fails. Here's the error. Cannot initialize the data…
  • ODBC String For Mas90 4.05

    Hello I Have MAS90 version 4.05, I tried to connect using ODBC driver but i don't get connect send a error could bot connected Driver keyword syntax error, I created new odbc and when i tested sad is ok don't error but i called from app send error my…
  • MS Access - Import Table -The decimal field's precision is too small to accept the numeric you attempted to add.

    I was originally trying to do a linked table in MS Access to JC_Job, but I got an ODBC call failed. I have no problem pulling other tables, so I tried import instead of link and I get "The decimal field's precision is too small to accept the numeric you…
  • Export PO Header and Lines to MS Access Sage 100 Advanced 2021- Lines wont export.

    I am having difficulty exporting PO's from Sage 100 2021 Advanced to MS Access via the ODBC connection. I can export headers just fine but I can't seem to export lines. I know I can get the data via linked tables, but it doesn't allow me to do what I…
  • ODBC Connectivity for PHP PDO under Windows

    I'm trying to connect via ODBC to Sage from PHP and I keep getting this error: Uncaught PDOException: SQLSTATE[S0000] SQLDriverConnect: 145 [ProvideX][ODBC Driver][PVKIO]Logon failed in X I made a 64 bit DSN, configured it, went to Debug tab, Test…
  • ODBC System DNS Not Working

    We have the MAS 90 4.0 ODBC Driver installed and I've setup a system DSN connection that we link to an Access DB. The DB is saved on the Sage server, on our network I have an excel spreadsheet that is pulling data from a query in that DB, it refreshes…
  • Connection string for ODBC connection SOTAMAS90 with powerBi Gateway?

    I have seen some similar threads but none of them seem to work. Here is my situation, and bear with me I am very green with ODBC connections: I am wanting to connect to SOTAMAS90 through PowerBI gateway to get my data on a constant refresh. This would…
  • Forms/Reports/BIE blank after upgrade

    Had an upgrade from v2016 to v2021 Advanced. Migration/conversion went well with no errors. However forms, reports, bie within sage 100 doesn't display data and even trying to do a crystal report outside of sage doesn't display data. I could see that…
  • [ProvideX][ODBC Driver][FILEIO] Unable to allocate memory to perform requested operation (#14) in MS Access Sage 100 2019

    In MS Access we have used ODBC to connect to the Sage 100 ver 2019 data files. We get an ODBC error when accessing the AP_InvoiceHistoryDetail table (a very large file). In MS Access we see the linked file. I open it and go to the last record. It works…
  • Connection to Sage Data with postgresql fails

    Any help is greatly appreciated. Using Sage 100cloud Standard. My company uses Access to query Sage data. This works well, but I'd like to run more advanced and rapid queries. My system administrator has allowed me to install Postgresql on my computer…
  • Sage 100 - ODBC - Performance

    We have Sage 100 2014 running on a Server 2012 VM. We have a custom application that runs on a client machine which reads data from a couple system tables. Here's the odd thing. When Sage is running on the client machine, everything works fine on…
  • Get quantity of some Components shipped

    Hello, I'm trying to use MS Query to get quantity of some Components shipped to each country in past years. I am able to get such list of data for Items using tables of AR_InvoiceHistoryHeader/Detail. How can I get to quantity of Component then? I…
  • ODBC for VI using Access Split Database

    Hi all, would like a better understanding of best practice in setting up an ODBC link for Sage 100 VI jobs. We are currently still on Sage 100C Advanced 2018, and I am working to beef up what began as a home-grown Access solution to meet a specific accounting…
  • SQL Data Warehouse from Sage 100 2018 ProvideX tables

    I have set up a linked server in SQL 2017 set up from Sage 100 using the v4.40.0004 ProvideX ODBC Driver. We are looking to create a data warehouse to mirror Sage 100 ProvideX tables in full and refresh deltas throughout the day. Pulling FULL tables…
  • linked server "SAGE" returned message "[ProvideX][ODBC Driver]Expected lexical element not found: <identifier>".

    I have this query returning the error message. Any idea? SELECT A.SalesOrderNo, B.UDF_COMPLETE_PART, B.UDF_CUST_PART, E.ExtendedDescriptionText, B.UDF_Serial, A.CustomerPONo, A.UDF_EXT_CUST_PO, A.ARDivisionNo, D.CustomerNo, D.CustomerName, A.ConfirmTo…
  • Connecting to Azure database from Visual Integrator fails with error: "Unable to open [wdx][ODB]"

    I'm trying to create a Visual Integrator job that will import items located in an Azure SQL database. I've created ODBC connections to the database, and can connect to the database from the server with the Sage client installed. However, when I try to…
  • Cannot get an Excel query to return updated information

    Using Sage 100 ERP v2017. I am trying to run a very basic MS Excel query in order to build a database for our new website. Literally, all I am trying to get is the product part number, description and the name of the item image. My query is as follows…
  • How do I use crystal reports for sage to connect with sage Premium 100 so I can create my own reports?

    We are using Sage Premium 100, and have crystal reports for sage installed. We have the SQL version of sage. My user role is an 'admin' in sage. I know how to get to the place to make a new database connection, however, I am lost after that. I would appreciate…
  • Has anyone created an OLAP Cube for Sage 100?

    I have a client asking if there is any Cube functionality in Sage 100. Has anyone done anything with Cubes? Thanks, Suzanne.
  • What does Commit Check Clear Utility actually do?

    I recently found a discrepancy in values between the quantities tab and the cost detail tab within Item inquiry on a few items. After researching in the Knowledge Base, I came across the following steps to clear out the issue: Update all transactions…
  • No longer able to Import Data into Excel

    Across our network users have previously been able to run the data query as explained in the Sage article https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=51308&sliceId=1&noCount=true&isLoadPublishedVer=&docType=kc&docTypeID…
  • How to update excel connections built with sage100 2015 to new sage100 2018?

    Hello, My company just upgraded from Sage 100 2015, to Sage 100 2018. The installation path is different and we have a plethora of excel reports calling for data connections with the 2015 version. Is there a fast and quick way to manage all these…