How to set the connection timeout period?
lazarus / 16-Databases

----------------------------------------------------------------------
zhuyl · 2021-11-18 09:13

How to set the connection timeout period? The database is MSSQL.

----------------------------------------------------------------------
Zvoni · 2021-11-18 09:25

At a guess: Use the Params-Property of TMSSQLConnection.
Something like (Aircode)
Code: [Select]MyMSSQLConn:=TMSSQLConnection.Create;
//Set other Properties, Databasename, Host, Port etc.
MyMSSQLConn.Params.Add('Connect Timeout=30');
MyMSSQLConn.Open;

----------------------------------------------------------------------
zhuyl · 2021-11-18 09:37

Thanks!
How to set the execution timeout of SQLQuery1?

----------------------------------------------------------------------
Zvoni · 2021-11-18 11:13

Quote from: zhuyl on November 18, 2021, 10:37:43 amThanks!
How to set the execution timeout of SQLQuery1?
You don't. AFAIK, it's a Server-Side Parameter which is valid for all
queries.
In that vein: It's a connection Parameter (see above)