Connection Timeout

[THKalle]

Hi,

I can not seem to get the Connection Timeout to work.
The Connection Timeout does not have any impact.

SQLConnection1.DriverName := 'DevartSQLServer';
SQLConnection1.LibraryName := 'dbexpsda40.dll';
SQLConnection1.VendorLib := 'msoledbsql';
SQLConnection1.GetDriverFunc := 'getSQLDriverSQLServer';
SQLConnection1.Params.Clear;
SQLConnection1.Params.Add('User_Name=wsA');
SQLConnection1.Params.Add('Password=XXX');
SQLConnection1.Params.Add('HostName=jwindows.net');
SQLConnection1.Params.Add('Database=WDB');
SQLConnection1.Params.Add('Connection Timeout=3');
SQLConnection1.Open;

TK

[Stellar]

Hi there!

Thank you for contacting our forum!

The time-out for connecting to the server is set in seconds; by default, the parameter is set to a 15 seconds value.
Please also note that the actual time-out may be slightly longer than the specified value.

Should you have any questions, do not hesitate to ask!