I have been round in circles a bit on other things, so not quite sure
where this problem came in, and it is probably just some setting.

A program that has been working, is now giving an error when I first try
and prepare some bits.

The first problem was an IB_Cursor that just returns a single two field
record. The first time it tried to prepare, it gave an error - Unable to
prepare - but it was then fine on every later use, only giving the error
when the connection was closed and reopened. I deleted it and re-created
it and it is now fine, but the problem has move to an IB_DataPump.
Deleteing and re-creating made no difference. The Source and Destination
SQL both prepare fine, and ignoring the error, all the records are
pummped, but the error returns on first use after connection is dropped
and reopened.

The second pump in the package is unaffected, but is always used after
the first.

What am I missing?

Originally using IBO36A and problem has not changed moving to
IBO36CeTest.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services