Slow connection to sqlserver 2005 express

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
Joaquin
Posts: 1
Joined: Thu 27 Mar 2014 16:54

Slow connection to sqlserver 2005 express

Post by Joaquin » Thu 27 Mar 2014 16:57

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

Dimon
Devart Team
Posts: 2890
Joined: Mon 05 Mar 2007 16:32

Re: Slow connection to sqlserver 2005 express

Post by Dimon » Fri 28 Mar 2014 09:22

We can not reproduce the problem.
Please, try to use standard dbExpress drivers supplied by Embarcadero and check if the issue still persist.

Post Reply