Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Just a PSA- Had a customer who users MS Query extensively reach out today to tell me that it seemed that the MS Query function seemed to have been removed. Fortunately it's racy to add it back.
Open Excel, select "File" from the toolbar, then "Options…
Upgraded from Sage 100 v2020 to v2023.1 - We are still on the 32 bit version of Sage.
Uninstalled old CSODBC service and Installed it again from the v2023 directory.
3 times today the CSODBC service has hung up and needed to be restarted.
Here is…
This is happening with a single table MS Query in Excel 64-Bit when accessing large individual I/M and P/R files and continues after rebuilding them (Ex. IM_ItemTransactionHistory) . I reviewed the other thread on this error, but nothing applies other…
I have been attempting to simply change the data type of a column for a query I am running through the ProvideX ODBC but I keep getting errors, and I am wondering if this scalar function is not available here. Simply, I am trying to query the IM_PeriodPostingHistory…
I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message:
"VI JOB_NAME Unable to open [wdx][odb]<dsn_name>"
I don't get this message…
Hi All.
We're in the process of upgrading to Sage 2022 and I'm trying to recreate some SSIS packages (SQL Server 2019 and Visual Studio 2022) that connect to Sage 2022 via the ODBC 64-bit driver and copies to one of our SQL Server 2019 tables.
I'm…
In our SQL Agent Data Warehouse load job, we are running into intermittent issues with connecting to our ODBC driver. We had run into this issue previously, but it essentially disappeared on its own; however, once I upgraded the SQL server's OS to Windows…
Hi All,
Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script.
I right clicked on the…
Greetings,
I'm running into a roadblock attempting to add an ODBC data source via Power BI Service via +New / Data sources page from the following URL. https://app.powerbi.com/groups/me/gateways
Here are a few facts:
The ODBC driver (for Sage…
I have an excel spreadsheet that uses the SOTAMAS90 ODBC 64 Bit System DSN to update some data from our AP tables.
When I open this spreadsheet on the server with Sage 100 advanced installed the query completes and data is updated is less than 5 seconds…
I've connected a single table from Sage 100c 2021 to Excel (data model) via a silent ODBC connection with saved username/password. All works great for me, but if anyone else uses this excel workbook and tries to refresh the data it makes them log in a…
I am encountering an intermittent "[ProvideX][ODBC Driver]Internal error" within an Excel workbook containing several worksheets, each of which contains a Microsoft Query (MSQuery) to various Sage 100 Advanced v. 2019 PU 2 files/tables. The query results…
I'm new to Sage and ODBC connections in general, so I'm looking for a bit of help here. I have set up a System DSN on the server, and am able to get a successful connection using PHP. However, whenever I try to run any sort of query, it doesn't pull any…
We are querying invoice data to read from MAS using the ProvideX ODBC driver from within a custom application. Within the custom application, we have tried specifying credentials explicitly within the connection string used to open the ODBC connection…
I am upgrading a client to Sage 100 V2020 and am running into issues with some Excel spreadsheets that have been working for years in prior versions of Sage 100. In V2020 the client upgraded their Excel version from 2013 to Excel 365 Enterprise 64 bit…
Probably a long shot here but whilst trying to import Sage data tables into the Power Pivot table wizard i get the following error:
'Object reference not set to an instance of an object'
Any thoughts?
User 1 created an excel file that pulls in data from Sage 100 Standard via ODBC.
Created same dsn connection (same dsn name) on User 2's computer. "Test Connection" successful with saved username/pw.
User 2 opens the same excel file and tried to refresh…
If we currently do NOT have ODBC Security within Role Maintenance enabled , what are the abilities/restrictions of users to create an ODBC data source connection?
I have a client that wants to create a dashboard using Power BI, but not with Sage Intelligence. Has anyone created an ODBC connection for use with Power BI? If so, can you outline what you did?
Thanks,
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…
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…