Re: Connection Time is too long

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If you connect on the actual SQL Server is there an issue? If not, then you
are looking at an application server or network issue.


"Adal" <Adal@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5287E88B-270C-4A92-8FF6-2F1E0A252A64@xxxxxxxxxxxxxxxx
> I'm using ado to connect to a sql server 2000, and suddendly the line that
> does the connection (conx.open) is taking a long time. All the apps that
> connecto to the server take a long time also. Additionally, when you use
the
> sql manager, when you retrieve the rows from a table it takes a long time.
It
> is not a network problem, because we have pretty good speed in our
network.
> It's something to do with the sql server, but I have not figure out what
is
> it. I cheked the current activity in the server, and doesn't have a lot of
> processes running and half of them are sleeping.
>
> any ideas how to solve this issue?
>
> Thanks


.

Relevant Pages

  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • Cant connect to SQL Server from Novell workstation
    ... My customer is trying to get my VB.net program to access SQL Server 2000 ... over a Novell network and they're getting a connection error. ...
    (microsoft.public.sqlserver.connect)
  • Re: Pass-through queries fail even after SQL Server reconnected
    ... indicates network connectivity problems. ... ODBC is a pretty old way to connect to SQL Server. ... pass-through queries fail due to intermittent connection failures. ... I can easily restablish a connection for ADO. ...
    (comp.databases.ms-access)
  • RE: java.sql.SQLException (Error establishing socket)
    ... | Error: No active Connection ... Since you are making connections to a remote SQL Server via the Internet, ... If the network is fine, ... Please reply only to the newsgroups. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: ASP .Net connection to Sql Server
    ... Using "dbmssocn" tells it to use the TCP/IP network driver, ... It is connecting via a connection string similiar to: ... > string to our production SQL server and everything runs fine. ...
    (microsoft.public.dotnet.framework.aspnet)