We have Sage 100 2014 running on a Server 2012 VM.

We have a custom application that runs on a client machine which reads data from a couple system tables.

Here's the odd thing.

When Sage is running on the client machine, everything works fine on the Sage client application. While I don't know this, I'm assuming Sage is

using BOI type calls to interact with the ProvideX database server. My assumptions is it's not using ODBC.

When my application runs (Lazarus Pascal .exe) a simple query of the sy_companies database takes to long, I mean seconds too long.

HOWEVER, when I close the Sage 100 client, the ODBC performance is excellent on my application.

I've tried this under Windows 7 Pro 64 and Windows 10 Pro 64. Both have the same problem.

So, who has some ideas?

I noticed in the WKSETUP folder here: C:\Sage\Sage 100 Advanced ERP\MAS90\wksetup\Prerequisites\64Bit ODBC

there is a 64bit odbc installer. Is that an answer.

Anyone been here and have some advice, love to hear from you,

Bret