SQL Server connection

From: nazeer (nazeer.jr_at_hammerhead.net)
Date: 04/29/04


Date: 29 Apr 2004 03:52:32 -0700


Hi,

I just want to know why does the following error come up:
"[DBNETLIB][Connection Open(Connect()].SQLServer does not exit or access denied". What does it mean Connection Open?

Also I want verify my ADO Connection Linking. I usually, open my ADO Connection when the main form creates itself. I use the following convention:

Try
  ADOConnection.Open;
Except
On E:Exception do
  ADOConnection.Close;
End;

Is this the standard way to connect the ADOConnection, if it is not how do you all connect the ADO to SQL Server 2000?



Relevant Pages

  • Re: SQL_Server_does_not_exist_or_access_denied
    ... SQL Server authentication, and have you tried both (e.g. maybe the domain ... Can other machines connect to the SQL Server machine during this time (e.g. ... Is there a firewall, router, or other hardware between the ADO connection ... It SEEMS to be running low on resources. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL_Server_does_not_exist_or_access_denied
    ... SQL Server authentication, and have you tried both (e.g. maybe the domain ... Can other machines connect to the SQL Server machine during this time (e.g. ... Is there a firewall, router, or other hardware between the ADO connection ... It SEEMS to be running low on resources. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL_Server_does_not_exist_or_access_denied
    ... SQL Server authentication, and have you tried both (e.g. maybe the domain ... Can other machines connect to the SQL Server machine during this time (e.g. ... Is there a firewall, router, or other hardware between the ADO connection ... It SEEMS to be running low on resources. ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL_Server_does_not_exist_or_access_denied
    ... SQL Server authentication, and have you tried both (e.g. maybe the domain ... Can other machines connect to the SQL Server machine during this time (e.g. ... Is there a firewall, router, or other hardware between the ADO connection ... It SEEMS to be running low on resources. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL_Server_does_not_exist_or_access_denied
    ... SQL Server authentication, and have you tried both (e.g. maybe the domain ... Can other machines connect to the SQL Server machine during this time (e.g. ... Is there a firewall, router, or other hardware between the ADO connection ... It SEEMS to be running low on resources. ...
    (microsoft.public.sqlserver.clients)