TADOConnection and Oracle

Hi,
I'm finding an interesting problem when using a TADOConnection connected to
an Oracle database with both the Microsoft Oracle Driver or Oracle's Oracle
driver. (I'm using MDAC 2.8). I'm writing some software that's dependent
on handling if the database goes down. On shutting down the database for
testing purposes I'm finding that I can trap an error occuring when I try
and run a TADOQuery that's using the TADOConnection to connect, however
the TADOConnection object, always tells me it's connected - even if I close
it's connection and open it again!! The problem with this is a) the
database is down, b) if I bring the database up again, try connecting again
(yes - successful again), try closing and running the TADOQuery based off
this connection - the query fails. For some reason the TADOConnection
object isn't giving an error when it's being closed then opened again on the
shutdown database.

Now: I can do the above against SQL Server database and it works correctly.
i.e. If I disconnect and reconnect the TADOConnection object when the SQL
Server database is down it tells me accordingly. When it comes up again, I
can run code to connect the TADOConnection properly and the TADOQuery that
uses this then works again (after its opened again).

Any thoughts on how I can get this to work for Oracle. This is driving me
crazy!


.

Relevant Pages

  • RE: ADO.Net Connection Pooling Problem with Oracle
    ... the CLR is releasing the connection to your database. ... the number of database sessions in Oracle seem to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connecting to an Oracle Database
    ... You can also use FrontPage, ... Click Add to Catalog under "Database Connections" ... Put in your Oracle connection string in the custom connections dialog ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Query Oracle, show results (need help!!)
    ... After the DB connection, put this... ... I am trying to log into an Oracle database, ... Prepare the SQL statement for running and it'll be stored in Oracle buffer ...
    (perl.beginners)
  • Re: How to use tnsping programmatically
    ... database is there. ... the need is to avoid attempting the connection if the Oracle instance ... Simply because you can tnsping the listener doesn't mean the database ... of connectivity/bandwidth on this connection. ...
    (comp.databases.oracle.misc)
  • ADO connection to Oracle
    ... the runtime version, however, the program terminates with no error ... The program always stops at the connection to the database. ... connection is made using generic OLE DB, not the Oracle data provider. ...
    (microsoft.public.vb.database.ado)