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
Connection Timeout
Re: Connection Timeout
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!
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!