Browse By Tags

We currently have Sage 100 Contractor being hosted on Azure VM. I would like to know if it's possible to connect Power BI to our Sage database to create dashboard from Power BI.

Sage 300 Version: 23.1.1.72 I am working on a simple interaction between an Excel spreadsheet that extracts data from specific tables within the Sage 300 database. With my "admin" credentials it works but with a specific user's credentials it fails…

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…

Hello, After updating to p34, when trying to create a client (GESBPC) the following error appears: Checking the database, the table in question does not exist: What do we need to do to adjust this information, is it on the X3 or SEI?

How do I obtain BWGAccess? Does it come standard as part of the BusinessWorks kit or is it a separate paid for application?

I am trying to setup Power BI to be able to view data from Sage 50 Canadian Premium. I can access data tables, and specifically tproject using an ODBC connector. dStrExpBal (starting balance) for a project is correct, which is up to and including LAST…

I work for a software dev company that is setting up an application for a client. They have been using the Timberline Data driver (using ttsimba.dll) to create an ODBC DSN to their Sage 300 CRE data in Access and run some update queries. We are replacing…

Hello i wanna to connect mas90 using odbc i know mas90 odbc is only read information, but i need also write some values in some tables for example on Purchase Orders when we received a pdf invoice read information from there and put on file detail of…

Sage 50 Pro ... Win 10 Pro 64b ... Office Pro 2019 32b ... ms Access 32b ... Mysql ODBC 32b ... ODBC connection read-only appears to work fine to retrieve customer data ... however ... any attempt to make a read/write connection to make corrections/changes…

Hi, Can someone please explain to me why in 32bit version of Sage, there's a 64 ODBC .msi and in the new 64 bit version of Sage v30, there's 32bit version of ODBCs .msi? Am I missing something? Thought this would have to match the OS and architecture…

I'm attempting to pull data from Sage across the ProvideX ODBC connection via external application (Python, C#, etc). After I establish a connection using the existing Data Source, every subsequent attempt to read any table returns the following error…

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

Our Sage local DB environment was setup in 2017 hosted on a Windows Server 2016. I am attempting to gain access to the data. Currently an active SQL Instance is named SAGESQLGATEWAY and when connected to it, only lists SqlGatewayConfiguration database…

Hi Since updating to version 6.1b we have added two new companies (once copied from an existing and one completely new). ODBC set up was added, users were added and the apply changes were made. All our existing companies can generate both SMART reports…

Bonjour Quand j'essaye de connecter à sage il m'affiche l'erreur en PJ

I use Excel VBA macros to update vairous tables. I have an Excel spreadsheet to update the ACA Dependents database for my 1095 preparation. Despite the SQL query only selecting one record for updating, when I update records it updates numerous records…

I've created an ODBC connection to my data and linked a few of the tables in an Access database. The data opens fine but every time I try to create and run a query my MS Access will crash, shut down, and try to reopen. Hoping someone can help me!

Hi there! I hope you're all doing well. I'm attempting to modify the SQL query of an ODBC Import Job, but it crashes when I press the Test button. I'd like to know if there's a resource where I can find the exact syntax of SQL required for VI Jobs…

How can we check/fix the bad data causing "invalid segment number"? We need the SQL Export data for our daily reporting. ==>SQL EXPRESS select qry (linked to cloud-hosted SAGE100c 2022v3 Standard) has been working up until error today (12/6/2023) SELECT…

Hi, I have the basic Sage cloud but on downloding the audit trail to Excel, I thought there must be some ODBC drive to pull the data into Excel, where can this be found, or is the system so simple that it does not exist?

Hello I'm upgrading from 2018 Advance to 2022 Premium. When on the server we can run canned reports within Sage 2022 without error. When we try and run reports from a client 2022 workstation we get "The database login failed. Error in File GL_ChartofAccountxxx…

I am getting this error when trying to update Job Custom fields through ODBC. Has anyone seen this or know how to determine what the error is? Michelle Outler

I am trying to read MKD file using pervasive odbc driver but i am not able connect pervasive odbc driver. anyone help me on this

Hi, I can see an ODBC connection available (default name WINFAS32) but can't connect to it. I'd like to automate some spreadsheets that can verify VIN#s on our insurance policies. I've tried integrated security and specified user names, but neither…

Hello, We currently have Windows services (written in C#, .NET) that push data out from some Sage tables to a custom API, which then stores it in a private SQL Server Database. Depending on the service, it might trigger every minute, every 5 minutes…