Slow connection to sqlserver 2005 express
Posted: 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
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