query timeout using ado protocol to mssql

[woec]

Hi,

I experienced a query timeout after 30 seconds on executing a query lasting longer than this limit on querying from the sql-server (2008R2) using the ADO protocol.
How can I set the query timeout to a higher value? I did not find any possibility for that.
Supplying additional parameters on the connection string (database property) as "ConnectionTimeout" or "CommandTimeout" as found in several hints did not help ...

I use Zeoslib 7.2-beta-3477 together with Lazarus 1.4.2 / fpc 2.6.4 on windows (32bit)

regards,
woec

[marsupilami]

Hello woec,

I would assume that with the ADO protocol this is an option to set in the ADO connection string. In your IDE there should pop up some assistant do create such a connection string and maybe there you can find the required option.
With best regards,

Jan

[woec]

Hi Jan,

thank you for your reply. Up to now, I did not find any possibility to supply a working parameter neither any support from the IDE in any of the used class object properties. Can you give me more specific hints, where to find the IDE pop-up support you meant?

Regards,
Johann

[marsupilami]

Hello Johann,

the things that I do:
- drop a TZConnection object on your data module
- set the Protocol to ado
- click into the Database property. There is a small button on the right hand side labeled '...' -> press it.

If the settings you can do there don't help we could have a look at the ado driver. Bus I suspect that a query timeout is something to be set in the ADO connection sting.

With best regards,

Jan

[woec]

Hi, Jan

if try what you suggest, I get the file-selection dialog opened, so the object expects a file reference to a database. There is no possibility to select connection properties.
Do you have any further suggestions?

Best regards,
Johann