PxPlus User Forum

Twitter Twitter Twitter

Author Topic: Sage/ProvideX ODBC  (Read 1188 times)

mm_coder

  • Member
  • **
  • Posts: 5
    • View Profile
Sage/ProvideX ODBC
« on: December 09, 2020, 05:38:53 PM »
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?



Mike King

  • Diamond Member
  • *****
  • Posts: 3811
  • Mike King
    • View Profile
    • BBSysco Consulting
Re: Sage/ProvideX ODBC
« Reply #1 on: December 09, 2020, 07:49:18 PM »
Unfortunately the ODBC driver that Sage100 uses is different than the PxPlus SQL ODBC driver.  Although the underlying database and file structures are similar, the enhanced PxPlus version comes in both a 32 and 64 bit version as well as versions for various Linux/Mac platforms.

You would need to contact Sage for assistance with their driver.
Mike King
President - BBSysco Consulting
eMail: mike.king@bbsysco.com