Browse By Tags

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…

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…

Hello. We are having a bizarre issue with Microsoft Office 2016 and an ODBC connection to Sage 100 Advanced 2018 ERP. We use a system DSN to connect to Sage from Access to run queries and reports not available in Sage and have been doing this for years…

Hi folks, I have a client that uses Sage 50 (2018.1 + Connection Manager v7.0). They host Sage on a MS Azure server. They have 6 Companies (DBs) that I'd like to be able to connect to so that I can pull some high-level data into a custom reporting tool…

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…

I'm looking to pull the current balance of the GL for each account, basically exactly what is in the History Tab of account inquiry. Whats the best way to accomplish this? I've looked around the GL tables for any sort of summary. Will I have to sum the…