Sage Construction & Real Estate

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.

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…

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…

Many of us are not using SQL replicator as the hardware requirements are up there, server and client, and we have enough data that I believe we would need full SQL vs express. Especially if your accounting dept wants the data to be live.(which ours does…

We set up SQL replication last week and it is working well. However I am having trouble finding where our HH2 imports actually end up in the SQL database. We import a HH2 payroll each week via the import tool in Payroll > Tools > Import Time... Where…

In log viewer it is possible to Archive & Delete but it is extremely slow, only being able to handle 200,000 records at a time and the archive only writes 10,000 per file. I don't want to archive, I just want to delete. I have tried ODBC connect and using…

Has anyone had experience with archiving the PO module? According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module. Clean out all those old records. I have done this in a test environment and can…

Making queries from excel / crystal reports is easy on a windows computer using the ODBC connections, but is this something that has been done from Linux computers on the network? For instance, if we have an application running on a random computer controlling…

I'm trying to connect Crystal Reports 2012 to Sage 100 Contractor v20.5 via an ODBC connection. I have created the ODBC connection successfully by allowing access from other applications (DAT->Advanced Settings...->Advanced SQL Server Settings->Edit Approval…

How can the Sage 100 Contractor 2016 (version 20.4.51.0 or greater) databases be accessed using Microsoft Access 2010? I would like to link to the data source by creating a linked table. To do this I have created a Machine Data Source using ODBC in…

Problem: ODBC Syntax error when referencing Check column of table APM_MASTER__INVOICE_PAYMENT.Check, while other columns respond as expected Background 32-bit ODBC driver – installed OK Sage Role/user verified – OK DSN – User DSN and System…

I am having trouble connecting to timberline from my asp.net mvc 4 application. MY CODE String connection = "DSN=Timberline Data Source;Uid=<myusername>;Pwd=<mypassword>;"; OdbcConnection timberlineConnection = new OdbcConnection(connection); timberlineConnection…

Hello All, I have a problem I have been researching lately regarding slow queries over ODBC to our sage server. I have seen people with similar issues on other sites, but no real solutions.... We have a web server that uses PHP to query several database…