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.
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.…
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…
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 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…
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 have a client who is migrating from Sage 100 4.5 to Sage Intacct. I'm trying to take Job Cost lines posted to the GL and break out (tag) the summary lines by job number and cost code (dimensions). But when I look at the JC tables such as JC Transaction…
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…
What are the differences between 'Time Created' and 'Time Updated' fields in the invoice history? Assuming they are my local times and that it is based on a 24 hour clock with decimals as fractions of the hour (e.g. 15.5 = 3:30 PM)?
Had a Crystal report using the JTDActualCosts and JTDInvoiceBilled fields from the JC1 data file. Recently upgraded to 2018 and the JC data file no longer has these fields. Where can I find them?
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…
Hello. We are attempting to get two years of pay history out of Sage 100 as well as other employee information. I have attempted to use an Excel Query, but I really have no idea what I am doing. Where do I go to find an expert that knows how to retrieve…
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…