Re: 1 minute to conected???

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 03/31/04


Date: Tue, 30 Mar 2004 21:27:04 -0600


>cString := ' Provider=MSDASQL; Persist Security Info=false; Driver={SQL
>Server}; Server=192.168.0.5; DataBase=cr025; UID=energy; PWD=xxxxx;
>
>I use the structure above to connect to the sql-server in a windows 2000
>professional, the problem is that this being long about 1 minute to connect,
>somebody has some suggestion.
How long does it take you to connect using Enterprise Manager?
Are you sure you are measuring just the connection time when and not the opening
of some queries?

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com


Relevant Pages

  • Re: unable to start SQL Service ... error code 3417
    ... you might have to remove/reinstall SQL-Server. ... Sylvain Lafontaine, ing. ... MVP - Windows Live Platform ... error message below, I see this has happened to others, where the service ...
    (microsoft.public.sqlserver.server)
  • ASP.NET great technology but unaffordable?
    ... want to build a asp.net application based upon a windows 2003 server ... ASP.NET, One central SQL-Server login, internal user ... database - no windows authentication. ... External Connector licence. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: MSDE2000 auf WinXP
    ... 1: NT Authentifizierung ... Ich habe zwei Rechner mit Windows XP Professional ... Dann habe ich auf dem SQL-Server Rech- ...
    (microsoft.public.de.sqlserver)
  • Re: SQL-Server Aliasname =?ISO-8859-1?Q?=FCber?= Host
    ... > haben die SQL-Server logischerweise unterschiedliche Namen. ... > Entwicklernotebook einfach die jeweiligen Kundenserver in die ... unter Windows XP funktioniert dieses Handling ...
    (microsoft.public.de.german.windowsxp.sonstiges)
  • Re: Windows 95 und SQL-Server 2005
    ... Rechner schaffe ich den Zugriff auf den SQL-Server 2005 nicht. ... Wenn Du Standard-Sicherheit aktiviert ist, ... (Windows 95 original verwendete Named Pipes als Standard) ...
    (microsoft.public.de.sqlserver)