Sage 100

We currently run sage 100 advanced 2016 update 5 on a 2012r2 server and access sage via RDS (separate server). Currently using the Sage 100 ERP Client Server ODBC Driver Service. We notice that when ever we go into the user or role maintenance and make…

I am trying to use subqueries and joins in my PHP script that is pulling data from SAGE, but I keep getting this error: Warning : odbc_exec(): SQL error: [ProvideX][ODBC Driver]Expected lexical element not found: <identifier> Here is my query: SELECT…

We have an application that wraps around the Sage 100 data base using the Sage 100/Providex 64-bit ODBC driver as a linked server to an instance of MS SQL Server 2014 Express 64-bit. Various views are then defined against the S100 tables in the SQL Server…

We have a client that is using Sage 100 Advanced version 2016. He uses Access to run multiple queries from the Sage data tables. He had been occasionally receiving ODBC - call Failed when running his queries on large databases. He recently installed a…

Hello everyone, Is there anyone who would be kind enough to provide us with a tutorial to link Sage 100c (Cloud) v3 to PHP? Thank you.

Hi all, The odbc connection was working fine all along with excel with one time sign in, but now I have to sign in into odbc multiple times even though the login credentials are correct. Also the odbc test is successful, we're on windows 7 64 bit…

Table: AR_InvoiceHistoryTracking Field: StarshipShipVia I check the FileLayouts and it says that this field is 15 characters. When I pull this table via ODBC, I can only pull 15 characters. However, when I view the data in DFDM, there's more than…

I'm trying to install the 64-Bit ODBC Driver and am getting the message "Unable to detect an installation of Sage 100..." I've uninstalled and re-run wksetup as Administrator, UAC is off, all he prerequisites are installed as far as I know. There…

I've installed Sage 100 2017 workstation on my Windows Server 2008, which is running MS SQL Server 2012. Now i want to install the 64 bit ODBC driver, but i'm getting the following error when i try to install it: "Setup was unable to detect an installation…

I have looked high and low and the answer is probably easy, but I just keep getting ProvideX ODBC Driver Expected lexical element not found., or Column not found: ItemNumber I am trying to do this with a date column. Here is the query: SELECT IM5_TransactionDetail…

Receive error message Database Connector Error: S0000[ProvideX][ODBC Driver FILEIO Unable to allocate memory to perform requested operation [Database Vendor Code: 14] - crystal report What do I need to do?

On a Windows Server 2008 R2 SP1 running SQL Server 2014 64 bit trying to create a link server to Sage 100 2016 Standard. Created a silent DSN 64 bit. When I try to setup the linked server I receive the following error message. Has anyone seen this? …

Using a silent ODBC connection to allow a third-party application to Sage 100 Advanced data. One user works fine, all the time. When I attempt to use another user (with a "read-only" role). It fails, prompting for user name and password. Of course, this…

Hello, My 64 bit Windows 7 PC can't connect to SOTAMAS90 because of the system error code 193 I see that the error has been mentioned a few times in this forum but could not find a resolution/suggestion worked for me. Would someone please kindly…

Okay, so let me start out by saying that I've searched these forums and Google for the last few days and while I find many similar situations, I still haven't been able to find a solution to my problem. I have setup linked servers in SQL and they have…

When connecting to Excel PowerPivot I receive the following error: Failed to retrieve data from AR_Customer. Reason: ERROR [S0000] [ProvideX][ODBC Driver][FILEIO]Table is not accessible I saw previous posts from over a year ago, but none were resolved…

Good Morning Sage Community...I need help getting a listing of Data Tables and the fields within each. I've found info on other versions of Sage but I can't seem to find how to do it in Sage 100. Is there someplace easy to pull each table and the fields…

We are running several companies and I created a MS Access DB to consolidate data for reporting. The tables are linked via ODBC. For certain events the user must refresh the data and enter their credentials. If the user enters a wrong username or password…

Have an issue with what I believe is a corrupted date value. It resides in purchase order detail required date and PO header PO date. Running the open order report on "required expire date" for date greater than 12/30 will result in "Vendor Code 9"…

Is there a simple query tool I can use for pvx? I'm an MS SQL server person, in the MS SQL world we use SQL Server Management Studio - what is the pvx equivalent? I know I can do Select * from OpenRowSet(blah blah) but that seems to be horribly inefficient…

I am using a SQL query that works fine with other DBMS, but is not working with the PVX ODBC driver. It seems to be caused by the GROUP BY keyword not recognized column aliases. Here is a sample query: SELECT {fn MONTH(InvoiceDate)} as TheColumn,…

I have access database that makes silent odbc connection to Sage 100. I create pass-through query dynamically and it works fine. The issue is that i have to switch between Sage 100 companies in access and although I update query to pull from a different…

We are using the ODBC driver for some read-only data access on a Windows 7 workstation with a Sage 100 ERP 2013 Advanced client installation also on the machine. For some reason, the very first ODBC connection that my application attempts causes the registration…