Browse By Tags

Can someone please assist. I think there are few companies still running systems on 64 bit Excel. Why can't I run or create my ODBC queries on Excel 64 bit? Who would want to downgrade to get results? Is there another way arround this issue please…

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…

Hi everyone, I have some customers with Sage 300 2022 and they have and use to setup ODBs for companies/sytem SQL Server Native Client 11.0. But with a customer we are upgrading to that same Sage 300 2022 version, and we dont found it. We download…

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…

We have a new Windows Server 2019 and SQL Server 2019 for our Sage 500 upgrade to version 2021. We use Sage via RDP. The Client is not installed on user PCs. They RDP to the server which is configured to launch a Sage session for the user. Sage is working…

Hi, Context: Sage X3: v12 Patch 33 Application folder (symbolic link): C:\ -> UNC Path at Amazon FSx DB: SQL Server 2019 Std. DB Cluster: Active/Passive Availability Group (AG). Using AG listener name and port. Followed: https://www.sagecity…

Hi, We've been using Business Works for years and now need to integrate Order and Invoice data into our in-house proprietary external database that manages our operations. We have a few questions: Can we use SQL to set up an ODBC connection? …

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…

Context: - X3 Console's Database setup: Manual configuration. - At AWS RDS, no install of AdxAdmin and SQLComponent. From the manual configuration screen, it ask me this. For the bottom 2 fields, how do I fill them up when I have no details…

Hello, we are using Sage 50 CA Quantum accounting 2023 (version 30) in our company, and we would like to build a bi-dashboard using Tableau or Power BI with our data. The Sage installation for this version does not include the Sage ODBC driver on our…

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…

I have a bunch of excel files that ready from different AP, AR, JC etc tables using a User DSN with the Timberline Data driver. Prior to upgrading today, they all worked. Since the upgrade, I'm getting an error that the "required credential settings are…

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…

Hi, I have the ODBC link set up to extract info from Sage for our monthly accounts, by month and nominal codes. We don't close our ledgers until our Stat accounts are completed so the ledger is still showing prior year. Is there a way I can change…

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 did some searching on your site and see that KB 39468 may assist in resolving this issue but cannot locate where your KB's are stored. And, if someone has insight into this error, please advise. Is this a firewall error or possible port issue?

I am trying to establish a ODBC connection to Sage 300 using Powershell ODBC. I am getting below error. I have tried using the same username and password for importing via ODBC in MS Access and it works. What am I missing? Exception calling "Open…

Hello Colleagues, I have a problem connecting to Sage 50 from ODBC, when I try to connect to the database from excel or another program it does not validate my credentials. I have done all the processes in the documentation, I enabled the permissions…

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…

Hi, I am a business intelligence developer in my company, importing data from sage50 database into Microsoft Power bi right now. One specific table, Update_Ledger, is not showing any data and this is the main table for our reporting needs. Why is it…