Connect request timed out after 1000 milliseconds

[jasper.hsia]

how can I fix it ?
this dbexpress not stable for multi-user .
sometime error is :
---------------------------
Debugger Exception Notification
---------------------------
Project cca_Server.exe raised exception class TDBXError with message 'Connect request timed out after 1000 milliseconds'.
---------------------------
Break Continue Help
---------------------------

dbxdrivers.ini
==========
[DevartMSSQL]
GetDriverFunc=getSQLDriverSQLServer
LibraryName=dbexpsda40.dll
VendorLib=sqloledb.dll
BlobSize=-1
HostName=127.0.0.1
DataBase=cca
User_Name=cca
Password=cca123
ProductName=MSSQL
DriverAssemblyLoader=Devart.DbxSda.DriverLoader.TCRDynalinkDriverLoader,Devart.DbxSda.DriverLoader,Version=1.0.0.5001,Culture=neutral,PublicKeyToken=09af7300eec23701
DriverUnit=DBXDevartSQLServer
EnableBCD=True
ParamPrefix=True
MSSQL TransIsolation=ReadCommited
OS Authentication=False
CommandTimeout=10

TDSServerClass
===========
object dsscCCA: TDSServerClass
OnGetClass = dsscCCAGetClass
Server = DSServer1
LifeCycle = 'Session'
Left = 6
Top = 96
end

procedure TdssmCCA.DSServerModuleCreate(Sender: TObject);
begin
CoInitialize(nil);
sqlServer.Connected := False;
sqlServer.DriverName := 'DevartMSSQL';
//sqlServer.AutoClone := False;
sqlServer.Connected := True;
sqlServer.Connected := False;
end;

procedure TdssmCCA.DSServerModuleDestroy(Sender: TObject);
begin
CoUninitialize;
end;

{newborn} thank for help

[Dimon]

To solve the problem try to increase the connection timeout. For this you should specify the Connection Timeout parameter of TSQLConnection, like this:

Code: Select all

SQLConnection.Params.Add('Connection Timeout=10000');