Subject Re: [IBO] IBODatabase & IBO4 1Min Query
Author Helen Borrie (TeamIBO)
At 01:38 PM 24-04-02 +0200, you wrote:
>Question1: IBODatabase.Connected problem
>
>I am using IBO 3.4 and I had a problem where the database connection gets
>lost.

No, it cannot tell when a connection is lost. All it can do is connect and
then, until it is logically disconnected, it remains connected.

>Then in Code I do the following (this is not all the code, just a
>logical idea)
>
>// in the beginning
>IBODatabase.Connected := True or
>IBODatabasse.Connect;

Yup, that's the problem. In order for the connection status to get back to
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 IBO4
>
>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?

At a guess, your Schemacache is updating itself upon connecting. What
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