🚀 go-pugleaf

Hmm I did this in another way... I wrapped a TADOConnection object in
a TSmartConnection object which holds the normal ADO connection and
which executes all my commands and opens datasets... now when I execute
a command or open a dataset that object can try to reconnect for a specified
number of times on failures, which takes care of those unexplainable
connection
drops...

Before I did this I had to restart my app every time something caused the
connection to drop... (for example... someone pulled out a cable while the
program was trying something... it's unbelievable how many times people
do this :-))) )

This has a plus side that I don't have to duplicate the reconnection code on
every place where I execute commands or open datasets...

Just my two cents worth...
    Jurko

"Harold Howe (TeamB)" <hhowe@bcbdev.com> wrote in message
news:3B6DBF1D.82FB6F3@bcbdev.com...
> Henrik Franz�n wrote:
> >
> > I have a problem with an ADO connection. I connect to a database. I can
get
> > all tables, but after a this i get a error. It seems like the
> > connectionobject is dead (NIL)..
>
> I have an app that I want to keep connected to the database at all times.
Its a
> server type of app. After a while, SQLServer just seems to drop the
connection on me.
> To combat this, I use code like this. Maybe you can try something similar.
>
> ADOdataset->Parameters->ParamByName("foo")->Value = "bar";
> try
> {
>     ADOdataset->Open();
> }
> catch (EOleError &e)
> {
>     // if an OLE error occurs, then perhaps we have lost our ADO
connection,
>     // toggle the connection object and retry
>     try
>     {
>         ADOdataset->Connection->Connected = false;
>         ADOdataset->Connection->Connected = true;
>         ADOdataset->Open();
>     }
>     catch (Exception &e)
>     {
>         // nothing we can do really, just rethrow and maybe log an
>         // error message
>         throw;
>     }
> }
>
> You can bundle this all into a function to keep your code clean.
>
> Harold Howe [TeamB]
> http://www.bcbdev.com