--- In firebird-support@yahoogroups.com, "ione1608" <aiwa1608@...> wrote:

>
> 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?

I assume PowerBuilder is an IDE. If so, connections made by
PowerBuilder at design-time count as connections. Only one application
can connect to the embedded server at a time. It is
first-in-best-dressed, PowerBuilder got in first. You will need to
have the connected property set to false at designtime, and manually
connect at runtime.

Adam