ADOConnection.Connected does not show lost connection.

From: Marco Napoli (marco_at_avantitec.com)
Date: 10/03/04 

Date: Sun, 3 Oct 2004 15:31:46 -0400

I am using ADOConnection object in order to connect to an MS SQL Server 2000
over the Internet.

I am using the ADOConnection.Connected property to see if the connection is
still active, but once connected, event if I loose internet connection, it
still shows my ADOConnection Active, but in reality my connection was lost
to the SQL Server.

Is there a better way to see if an ADOConnection is still tryly connected to
the MS SQL Server?

Thanks
Peace in Christ
Marco Napoli
http://www.ourlovingmother.org

Relevant Pages

  • Re: remoting vs. direct sql connection
    ... I'd say that you should never expose your SQL Server directly to the ... Internet -- the security risks are simply far too great. ... Using either a web service or remoting will also somewhat help in relieving ... Remoting logically uses a connection per ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: Help!! Client side database access
    ... private void StartWatch() ... Inside class checking internet connection ... > exposing your sql server on the internet and opening port 1433 on your ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: connecting to SQL Server 2000 from a VB.net app using ADO.net
    ... In terms of connectivity issues over the Internet, firewall ... TCP Ports Needed for Communication to SQL Server ... I can't create a remote connection in Enterprise Manager. ...
    (microsoft.public.sqlserver.connect)
  • Re: Performance of ODBC
    ... Usiing Access front-end to connection a back end through ... the Internet connection is definitely slow with currently affordable network ... Unless you can get a network connection that fast enough and ... that Access is the front end, and the SQL server is the back end. ...
    (microsoft.public.access.adp.sqlserver)
  • Connection problems when internet is down
    ... When the internet goes down, ... general connectivity to SQL Server works one ... I should note the connection problems are even at the ...
    (microsoft.public.sqlserver.odbc)