• 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.…
  • Visual Integrator SQL syntax

    Hi there! I hope you're all doing well. I'm attempting to modify the SQL query of an ODBC Import Job, but it crashes when I press the Test button. I'd like to know if there's a resource where I can find the exact syntax of SQL required for VI Jobs…
  • 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?
  • 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…
  • 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…
  • Access to employee data via ODBC

    I have a customer who would like to connect a third party timekeeping program to Sage 100 (v 2021.2 Advanced). With the PII Encryption in place on the employee/payroll data, is that still possible or are there extra steps required to make that happen…
  • 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…
  • Read & Write data in Sage100 using Business Object Interface

    Hi, I am new to Sage100 and customer is using Sage100 advanced which comes with ProvideX ODBC driver which only allows to read data from Sage100. I did some research on the functionality to write back the data in Sage100 but was not able to find any…
  • Sage100 Advanced to Sage100 Premium Migration

    Hi, I need to upgrade Sage100 desktop application from Sage100 Advanced to Sage100 Premium. Question 1 - What are the perquisites for upgrading/migrating? Question 2 - What will happen to my data if I switched from Sage100 Advanced to Sage100 Premium…
  • 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…
  • 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…