Subject | Re: [IBO] IBODatabase & IBO4 1Min Query |
---|---|
Author | Helen Borrie (TeamIBO) |
Post date | 2002-04-24T14:14:47Z |
At 01:38 PM 24-04-02 +0200, you wrote:
then, until it is logically disconnected, it remains connected.
normal, you'll need to call Disconnect and then call Connect again.
If this network is liable to these types of errors, then you'd do well to
have some kind of fallback function that gets called each time you open
anything. It would help if you could find out if any error is getting
thrown...for example, what happens when you try to Open on a dead connection?
do you see in the monitor?
regards,
Helen Borrie (TeamIBO Support)
** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com
>Question1: IBODatabase.Connected problemNo, it cannot tell when a connection is lost. All it can do is connect and
>
>I am using IBO 3.4 and I had a problem where the database connection gets
>lost.
then, until it is logically disconnected, it remains connected.
>Then in Code I do the following (this is not all the code, just aYup, that's the problem. In order for the connection status to get back to
>logical idea)
>
>// in the beginning
>IBODatabase.Connected := True or
>IBODatabasse.Connect;
normal, you'll need to call Disconnect and then call Connect again.
If this network is liable to these types of errors, then you'd do well to
have some kind of fallback function that gets called each time you open
anything. It would help if you could find out if any error is getting
thrown...for example, what happens when you try to Open on a dead connection?
>Question 2: I Min Query on IBO4At a guess, your Schemacache is updating itself upon connecting. What
>
>I have tested IBO4.02 and Had a severe problem with every first query ran
>again a Database connection, Does not matter what type of query you run it
>takes almost exactly 1 min. Just for the first query and then it flies, No
>one else seems to have this problem, what could it be?
do you see in the monitor?
regards,
Helen Borrie (TeamIBO Support)
** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com