Hi,

has anyone got the embedded server of FireBird working with an
PowerBuilder application?
I created an application using the SuperServer via ODBC. This works
perfectly.
Now another party wants to have a demo-version of this application.
So I tought it would be easier to do this with the embedded server,
so there is less to install for this person. When he wants to have
the full version of the app, I will go by and will do the
(SuperServer)installation for him.

I've put the dll's from the embedded package in the same directory
of the application. I renamed it to fbclient.dll. Then I created an
ODBC-profile in which I specify the database and the client-dll to
use. When I hit 'Test connection' it's succesful. But when I run my
app, it seems that the connection is going ok (because when I try to
hit the 'Test connection' in the ODBC-dialog it gives me the message
that the database is locked and ther is only one connection
possible).

But when I run a query from within my app, I get a system error and
the app is closed.

In PowerBuilder itself I can connect to the database, but when I
want to see the tables in the database I get the following 'message
arithmetic exception, numeric overflow, or string truncation....'

Can anybody help me on this? What am I doing wrong?