Browse By Tags

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…

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?

I got login from client pc . This error appeared (cannot access database error 40960 ) .How to fix this?

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…

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 ClarkM and Erzsi_I I see that that a similar question was posted by slacka 6 months ago, and remains unfixed. I don't understand why this issue hasn't been taken seriously. This seems to be a critical issue in the way a client is able to, or in…

I turned my timeslips 2017 and the main.db was missing. i now can't find it to access my data. can someone please call me at 310-556-1001 or refer me to someone who can find it? I found my tseg.fdb file but that is it.

Where can I find the time an order was created? I can only seem to find the day in the ORDDATE field in the OEORDH table. Does Sage store this somewhere in the database tables? Thank you

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!

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?

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

Hi all, I keep on encountering the error below while trying to do my database setup on Sage 7.0 Can anyone help with this please? Thank you.

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…

We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…

I am using ODBC and want a BASIC listing of all transactions. e.g. Date, AccountId, amount. So far I have looked at the tables starting with GENERAL_ (e.g. GENERAL_GL) but have not been able to tie them back to the reports that would be run in the front…