Recent

Author Topic: SLOW ODBC - Sage 100  (Read 3678 times)

mm_coder

  • Jr. Member
  • **
  • Posts: 50
SLOW ODBC - Sage 100
« on: December 09, 2020, 08:22:06 am »
Not trying to be rude, but also not sure if the original post (text below) was in the correct forum...so I re-posted here.
I will add, that I'm going to try using LibreOffice Base to see the behavior of ODBC speed as well as the below post.
So far it looks like Lazarus ODBC speed for this particular DB (ProvideX) is needing some tweaking, but not sure.
Best

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,

eldonfsr

  • Sr. Member
  • ****
  • Posts: 458
Re: SLOW ODBC - Sage 100
« Reply #1 on: December 22, 2022, 07:30:36 pm »
Hello I trying to connect to mas90 files  can you tell me a lite bit how you connect or your connection string please...?

this my connection string

STRcON:= 'DSN=MAS90_ODBC;Driver=MAS 90 32-Bit ODBC Driver;';
  STRcON:=STRcON+'SQL=SQL Server';
  STRcON:=STRcON+'Directory=C:\Best\version4\mas90;';
  STRcON:=STRcON+'Description=MAS 90 32-Bit ODBC Driver;';
  STRcON:=STRcON+'Company=001;';
  STRcON:=STRcON+'IniFile=providex.ddf;' ;
  STRcON:=STRcON+'PWD=5807;';
  STRcON:=STRcON+'UID=rudy;';
  STRcON:=STRcON+'Debug=0;';
  STRcON:=STRcON+'BurstMode=1;';
  STRcON:=STRcON+'DirtyReads=1;';
  STRcON:=STRcON+'CacheSize=4;';
  STRcON:=STRcON+'EnforceDouble=0';
  STRcON:=STRcON+'EnforceNULLDate=0;';
  STRcON:=STRcON+'KeyRestrict=0;';
  STRcON:=STRcON+'Prefix=C:\Best\version4\mas90\soa\;';
  STRcON:=STRcON+'RemotePVKIOHost= ;' ;
  STRcON:=STRcON+'RemotePVKIOPort= ;';
  STRcON:=STRcON+'SID= ;';
  STRcON:=STRcON+'ViewDll=C:\Best\version4\mas90\Home\;';
  STRcON:=STRcON+'MAS90RootDirectory=C:\Best\version4\mas90\;';
  STRcON:=STRcON+'DataDictPath=C:\Best\version4\mas90\DDICTS\;';
  STRcON:=STRcON+'LogFile=\PVXODB32.LOG;';
  STRcON:=STRcON+'SILENT=0';   

 

TinyPortal © 2005-2018