Search found 4 matches

by 719
09.03.2020, 11:50
Forum: ZeosLib 7.2 Forum
Topic: tsqlquery extrem slow with ado
Replies: 5
Views: 270

Re: tsqlquery extrem slow with ado

hello marsupilami,

thank you for the actual .dll files! that helped me a lot.

best regards

sven
by 719
06.03.2020, 11:58
Forum: ZeosLib 7.2 Forum
Topic: tsqlquery extrem slow with ado
Replies: 5
Views: 270

Re: tsqlquery extrem slow with ado

hello marsupilami, you sayed, i should use freetds. I've wanted that for a long time but the problem is: i can´t find any windows-dll on the net to download. have searched for hours -nothing. only linux github stuff, you have to compile... the ftp-link ( ftp://ftp.freepascal.org/fpc/contrib/windows/...
by 719
06.03.2020, 10:04
Forum: ZeosLib 7.2 Forum
Topic: tsqlquery extrem slow with ado
Replies: 5
Views: 270

Re: tsqlquery extrem slow with ado

thanky you for the answer but i have found the solution by accident:

the problem was the "DRIVER=SQL Server" in the connection-string. i have it changed to "Provider=SQLOLEDB.1" and now the query
takes only 1 second !

:D
by 719
05.03.2020, 11:34
Forum: ZeosLib 7.2 Forum
Topic: tsqlquery extrem slow with ado
Replies: 5
Views: 270

tsqlquery extrem slow with ado

hi, i use zeos 7.2.6.1 with lazarus 2.0.6 (32 bit) under win10 (64bit) and connect to an ms-sql server 2012. my problem is, that querys run with TZQuery are extremly slow and i can´t figured out why. i have a dbgrid, connected to a datasource and the datasource.dataset is connected to a tzquery. the...