We use Sage 100 which uses a ProvideX backend DB running on a virtual 2012 server VM
Clients tested Windows 10 64, Windows 7 64
We access Sage 100 using the SOTOMAS ODBC driver
Under Lazarus/Delphi pascal program
Here's the problem.
When a Sage 100 client is running on a client machine, we have a 4 second delay before an ODBC connection completes.
When a Sage 100 client is NOT running on a client machine, we have a 1 second ODBC connection time.
Access can make the connection in 1 second regardless of the Sage client running or not.
Any ideas why?