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,