Re: How to deal with broken server connection?



Where you catch it depends mostly on the type of program you are writing.
BUT .. the ADO connection object will often return "true" , thinking that it
is connected when in fact, it aint. Most of us get around that by not
testing to see if it is connected but by trying to run a querry that "does
nothing" .."select id from custmast where 1=2", or to call some cached
stored procedure that just tries to get one column from one row in a known
table. If it fails, you have no connection despite what the connection
object may say.


.



Relevant Pages

  • Re: ODBC/OLE DB Connection Pool
    ... > And if there is no global ADODB.Connection, there will be no pooling. ... The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.ado)
  • Re: ODBC/OLE DB Connection Pool
    ... > And if there is no global ADODB.Connection, there will be no pooling. ... The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.inetserver.asp.db)
  • Re: ODBC/OLE DB Connection Pool
    ... > And if there is no global ADODB.Connection, there will be no pooling. ... The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.oledb)
  • Re: Bob & Rob
    ... This simply creates an ADO connection object. ... Don't expect us to be able to teach you SQL ... >>get information relating to querying external DataBase, ...
    (microsoft.public.excel.programming)
  • Re: Gracenote vs FreeDB
    ... > Connection to Delphi: ... > I'm writing an application to organize my CD's (I know, ... Prev by Date: ...
    (borland.public.delphi.non-technical)