Sage 100

Hello. My client uses SAGE 100 ERP. I've been tasked with building a new ETL using VS2017 and SQL 2017 Azure. I need the ODBC drivers for the SAGE DB. How can obtain them? Thanks.

We use ODBC to connect to MS Access for several custom reports we use. After upgrading from Sage 100 Standard ver 2015 to 2017, ODBC connects to most files. However, when we try to connect to the AR Invoice History Header file it will display data correctly…

Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging. Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…

I am writing out a program and I keep getting this error on my sql statement Error: Expected lexical element not found: <identifier> (State:37000, Native Code: 3F7) Here below is my sql statement. I am nesting a select statement. SELECT ItemCode…

I have inherited a project that requires some querying to a SAGE 100 database. I would like to do this from a PHP script. I have read a number of questions/articles about connecting to SAGE 100 ODBC via PHP and it seems straightforward. However, this…

We have a customer that uses view tables created to optimize queries run in MS Query. These queries run in 32-bit ODBC and 32-bit Excel, but do not run with the 64-bit versions of the same. All other tables aside from view tables are able to be accessed…

Have a client whose ODBC is suddenly not working. You can create a company-specific connection and it works fine, but if you try to use SOTAMAS90 or create a new one with no company stored, it will not prompt for the company (grayed out, can't drop down…

I'm new to MAS, recently hired on to a company using MAS 200 4.40. I'm trying to utilize some of my experience with querying SQL databases to streamline work and am stumbling over how to avoid typing in my username and password to refresh my data in Excel…

Hi all; I've been having some serious difficulty finding an answer to this issue, which has led me to create my first post here. I have an access database that pulls tables from all companies by use of pass through queries. Connection strings are handled…

We have a client that is having a very strange issue with ODBC drivers when we try to setup a linked server in SQL. No matter what we try we get an error that seems to suggest that the login is failing but ONLY when we try to access it from SQL. Using…

I am attempting to run the following query in an ODBC to Sage. I am getting the following error: Unexpected Inner token: INNER Here is the query: SELECT AR_InvoiceHistoryHeader.InvoiceNo, AR_InvoiceHistoryHeader.InvoiceDate, AR_InvoiceHistoryHeader…

SSRS MS SQL ODBC connection to SFAServ I am looking for instructions on how to query data from MS SQL Studio and SSRS. If needed, how to I install requried ODBC drivers and where do I acquire them? We own the Sage Fixed Assets - Reporting Product, does…

MAS 90 version = 4.30.0.23 ProvideX driver version = 4.21.1000 I am attempting to query MAS 90 data using the ProvideX ODCB driver. My queries are running, but no data is returned. 1) MAS 90 has been set up with a role that gives me read access to all…

We use SSIS to grab all the information from MAS for use in reporting. We use the ODBC driver to do this. This works with no issues the majority of the time. Occasionally, but still often enough, there will be an issue with the extraction, causing…

We have installed 64 bit ODBC driver and the Sage 100 Standard ERP 2014 workstation software on our new Windows server 2012 Datacenter server with SQL 2014 Standard. The system's ODBC connections have been configured and can access the table count and…

I would like to have a list of all email address associated with every account, but I am not aware of a method to do this.

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?

Mas200 4.4 (yes, we are updating now) client running on Win7 64 machine. When I run a VI import job on my machine I have no problems. When I try to run the same job on the problem machine the job fails with the message above. Same Windows logon (domain…