Have you tried setting a DatabaseName property on the connection, then
setting all the queries to have the same DatabaseName property ? I've never
lost a connection using this method.

I have a very similar problem using some Oracle (aplogies for foul language
!) components which I'm using on an asset management system I'm writing here
at work. Everytime I open the project, 10 of my queries (out of about 25)
have lost their connection to the database. In the end, I simply put some
code in the constructors for my two datamodules to conect them back to the
database. Seems to have worked so far !


Cheers,
Norman.


-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar@...
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------


-----Original Message-----
From: tickerboo2002 <support@...>
[mailto:support@...]
Sent: Wednesday, February 19, 2003 10:25 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Losing TIB_Connection whilst designing


Hello

Using BCBv5p2, Win2kp2, IBO4.2H, with a local database

For a few months now, I have had a TIB_Connection in a datamodule
with Connected=true. Other forms/datamodules used this connection to
set their query/cursor,transaction IB_Connection property.

However, during the past week the TIB_Connection periodically sets
it's Connected property to false, resulting in all my
transactions\querys\cursors losing their IB_Connection property.

When running my application, the TIB_Connection will connect, but my
transactions\querys\cursors will have a blank (not <default>)
IB_Connection property which results in failure.

Could I have changed a parameter somewhere to cause this? It's
getting a bit tiring setting all my IB_Connection properties a dozen
times every day.

Thanks

David



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

This email is intended only for the use of the addressees named above and
may be confidential or legally privileged. If you are not an addressee you
must not read it and must not use any information contained in it, nor copy
it, nor inform any person other than Lynx Financial Systems or the
addressees of its existence or contents. If you have received this email
and are not a named addressee, please delete it and notify the Lynx
Financial Systems IT Department on 0113 2892990.