• sage mas90 odbc version 3.3.100 error can't start transaction

    Hello i wanna to connect mas90 using odbc i know mas90 odbc is only read information, but i need also write some values in some tables for example on Purchase Orders when we received a pdf invoice read information from there and put on file detail of…
  • Attempting to use ODBC Driver returns `[S0000] [ProvideX][ODBC Driver][FILEIO]Table is not accessible (12)`

    I'm attempting to pull data from Sage across the ProvideX ODBC connection via external application (Python, C#, etc). After I establish a connection using the existing Data Source, every subsequent attempt to read any table returns the following error…
  • Server-mounted PowerBI Gateway

    Having trouble with a server-mounted, On-Premises Gateway communicating with my silent ODBC for Sage 100 access. On-Premises Gateway successfully installed on my server (also the Sage server), and my published Power BI semantic model recognizes it.…
  • Same SQL daily insert okay until today: "[ProvideX][ODBC Driver][PVKIO]Invalid segment number"

    How can we check/fix the bad data causing "invalid segment number"? We need the SQL Export data for our daily reporting. ==>SQL EXPRESS select qry (linked to cloud-hosted SAGE100c 2022v3 Standard) has been working up until error today (12/6/2023) SELECT…
  • Sage Cloud Excel ODBC connector

    Hi, I have the basic Sage cloud but on downloding the audit trail to Excel, I thought there must be some ODBC drive to pull the data into Excel, where can this be found, or is the system so simple that it does not exist?
  • 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…
  • How to import Sales Forecast by Customer and Item

    We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…
  • 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…
  • General Journal Posting - duplicating

    Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…
  • Passing parameters from SSRS

    How do you pass an SSRS report parameter to Sage? It seems you can pass an explicit value in the sql where clause but cannot pass it from a parameter. The only place to further narrow the data is to add it as a filter to the report. Is there a more…
  • 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…
  • Best option for extracting data out of Sage 100 into Third-Party software

    We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
  • 100E - Sage 100 - Object Interface Course

    Hi, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…
  • 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…
  • Sage 100 Premium 2020 SQL Server Transactional Replication for Reporting

    Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…
  • 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…
  • ODBC Time Compare

    FormerMember
    FormerMember
    I'm trying to do a compare of Sage 100 TIME (hours past midnight - fractional) column in a SQL WHERE statement. I was able to get the DATE field to work with {d '2021-09-16'} but there doesn't seem to be a [t '17.500000'} like scalar function for TIME…
  • [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…
  • Object Reference Pointers

    FormerMember
    FormerMember
    Within the ProvideX environment Sage 100 references their objects by an ID value starting at 100001 for SY_Session . When scripting is used, does 100 create an OLE reference (iDispatch pointer) to the object and pass that to WScript Host ? If so what…
  • WEB BOI

    FormerMember
    FormerMember
    The ScriptBasic distribution comes with a web server version of the language. It runs as a Windows process and is multi-threaded. The best part is you can run your BOI external scripts on the web server with no modification to your BOI specific code.…