ODBC - Sage 100 Slow
lazarus / 16-Databases

----------------------------------------------------------------------
mm_coder · 2020-12-08 03:07

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,