Subject Re: [IBO] Datapump prepare error
Author Jason Wharton
I wonder if you are explicitly calling Connect before you try to Prepare the

Here's where there is a catch, when you go to prepare a statement some
parsing is performed. Often times this parsing is dependant upon what the
SQL Dialect is. By default the connection thinks it is 1 but as soon as a
connection is made it actually asks the database what dialect it is. Then it
automatically adjusts if necessary. So, if you are D3 then there could be a
small window of time that parsing goes from D1, then a connection is made
and it continues with D3.

You can tell your connection to use D3 all of the time and this will resolve
this potential problem.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: <lester@...>
To: "IBO" <>
Sent: Friday, February 09, 2001 6:15 AM
Subject: [IBO] Datapump prepare error

> Any ideas.
> Switched to latest version 3.6Cf to rule out any other problems.
> Builder 5 - IB6 not patched (Firebird on test elsewhere)
> I have a pair of simple data pump setups, which work fine except for an
> anoying problem on first connection.
> I need to prepare to set up the record number I want to copy. But it is
> reporting a 'Statement failed to prepare'. The anoying bit is that I can
> quite happily then load the parameter, run the pump and set up the
> second half. So I have been just ignoring the error. It stays away until
> I close and reopen the server connection, when it again pops up. It does
> not matter what I try and prepare first, in the datapump module, that
> first prepare has a problem, and then all the rest are fine.
> I need to clear the problem as it is obviously causing a futher problem
> where the network connection is too slow, so I loose a remote
> ocasionally, stuck at this point.
> I am now starting to trace through to see what is missing, but any
> thoughts would help.
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services