Hi, sorry for my englih, it isn't my native languaje.
Object Computers
OS: windows 8 OS 64 bits, processor x64
CPU: AMD E1-1200 APU with Radeon(tm) Graphics 1.40 GHz
RAM: 4,00 Gb
OS: Windows 8 OS 64 bits, processor x64
CPU: AMD C-70 APU with Radeon(tm) Graphics 1.00 GHz
RAM: 4,00 Gb
DATABASE SERVER: SQL SERVER 2005 express
I'm working with delphi 2010 and delphi 7 and I configure de connection object at this way:
if SqlCnxn.Connected then
SqlCnxn.Connected := False;
SqlCnxn.DriverName := 'DevArtSQLServer';
SqlCnxn.LibraryName := 'dbexpsda40.dll';
SqlCnxn.GetDriverFunc := 'getSQLDriverSQLServer';
SqlCnxn.VendorLib := 'sqlncli10.dll';
SqlCnxn.LoginPrompt := False;
SqlCnxn.Params.Clear;
SqlCnxn.Params.Add('HostName=' + FCfgInfo.HostName);
SqlCnxn.Params.Add('Database=' + FCfgInfo.DataBaseName);
SqlCnxn.Params.Add('User_Name=' + Usr);
SqlCnxn.Params.Add('Password=' + Pwd);
SqlCnxn.Params.Add('BlobSize=-1');
SqlCnxn.Params.Add('FetchAll=True');
SqlCnxn.Params.Add('EnableBCD=False');
SqlCnxn.Params.Add('MSSQL TransIsolation=ReadCommited');
SqlCnxn.Params.Add('ErrorResourceFile=');
SqlCnxn.Params.Add('LocaleCode=0000');
SqlCnxn.Params.Add('longstrings=True');
SqlCnxn.Params.Add('OS Authentication=False');
ShowMessage('Open connection');
SqlCnxn.Open;
ShowMessage('Connection active');
and de second message delay 3 minutes.
It also occurs in some computer manufactured by compact. I also try with the last trial dbExpress driver 6.3.5 for SQL Server
with same results.
Best regards
Joaquin
Slow connection to sqlserver 2005 express
Re: Slow connection to sqlserver 2005 express
We can not reproduce the problem.
Please, try to use standard dbExpress drivers supplied by Embarcadero and check if the issue still persist.
Please, try to use standard dbExpress drivers supplied by Embarcadero and check if the issue still persist.