Re: SQL Server connection

From: MeCeX (admin_at_mehmetcelik.com)
Date: 04/29/04


Date: Thu, 29 Apr 2004 14:03:00 +0300

is sql server is running ?
your connection to server may be lost
or the username and password you want to connect may be wrong
or sql server may accept only incoming connections
or you may be trying to connect to other sql server which is not available

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

yes standard way is like that

MeCeX

"nazeer" <nazeer.jr@hammerhead.net>, iletide şunu yazdı
news:4090de70$1@newsgroups.borland.com...
>
> 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 2000 slow
    ... If I close the connection (moving the Open/Close ... ADO) and the dll gives twice the performance. ... > Are there any known performance issues with .NET accessing Sql Server ...
    (microsoft.public.dotnet.framework.performance)
  • Re: CoInitialize failure with many processes
    ... I could not find a good reference about ADO connection pooling, ... its own connection to the SQL Server. ... Regarding the Performance Monitor, I haven't seen anything out of the ...
    (microsoft.public.win32.programmer.ole)
  • Re: Cross Transactions between ADO & ADO.Net
    ... MARS session pool limited to one connection?). ... > There is one thing that might help here, if you're using SQL Server. ... We even call ADO code from ... >> the DTC cordinator from COM+ to handle the transactions between ADO.Net ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Server extremely slow
    ... my personal experience with a similar setup as your (Sql Server ODBC ... against the sql server (ADO was specifically designed for use with sql ... the connection is closed. ...
    (comp.databases.ms-access)
  • Re: absolute newbie question - connecting to SQL server in ADO.net
    ... How do I get the above connection working? ... > experience of ADO prior to this was in Access 2000. ... Have I wasted my money buying VB.net standard because it can't connect to ... > an SQL server 2000 server? ...
    (microsoft.public.dotnet.framework.adonet)