Recent

Author Topic: ODBC - Sage 100 Slow  (Read 649 times)

mm_coder

  • Jr. Member
  • **
  • Posts: 50
ODBC - Sage 100 Slow
« on: December 08, 2020, 04:07:07 am »
Using Lazarus to connect to Sage 100 ProvideX db using ODBCCONN.

Condition 1: When the Sage 100 ERP client is open on a client machine (Win 10 or Win 7), an ODBC connection
takes approx 4 seconds.

Condition 2: When the Sage 100 ERP client is NOT open on a client machine (Win 10 or Win 7), an ODBC connection
takes approx 1 seconds.

Anything I should know regarding ODBC parameters that may make this work better?

An Access application using the same ODBC driver has no delay regardless of Sage client state.

Regards,

 

TinyPortal © 2005-2018