Sage 100

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…

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…

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 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…

The name limit for the local computer network adapter card was exceeded. We have to manually start the backup every night. Then it will complete successfully.

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…

Hi all! Just curious what your experiences are because Sage doesn't officially validate individual SQL Server builds with Sage 100 Premium. If you can supply the version of Sage 100 Premium (e.g., 2017 ) and the SQL Server build # (e.g., 12.00.5546…

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…

We've recently moved from Sage 100 providex to SQL. Upon looking at our tables in SQL it appears that every field of type datetime now has been set to not allow null values. As a result all of those fields now automatically populate with 1753-01-01 (SQL…

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…

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…

Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?

Our Sage 100 version 4.40 server had a few files fail the integrity test with either read or write errors. I selected OK to rebuild them but now all the records are gone. The log file shows all the records were recovered. Is this normal? I can import…