--- In firebird-support@yahoogroups.com, "Adam" <s3057043@...> wrote:

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

Hi,

It didn't had anything to do with the number of connections. I
solved it. I forgot to put the directories UDF and INT to the
installation.