Subject Re: Firebird embedded server with PowerBuilder
Author ione1608
???
What do you mean? That PowerBuilder is not a good dev-app?

--- In firebird-support@yahoogroups.com, Jason Dodson <jasond@...>
wrote:
>
> Think of PowerBuilder as "Visual Cobol". I still have nightmares
from my Y2K contacts....
>
> Adam 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
> >
> >
> >
> >
> >
> >
> >
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://firebird.sourceforge.net and click the Resources
item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> >
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
> --
> The information transmitted herewith is sensitive information
intended only for use to the individual or entity to which it is
addressed. If the reader of this message is not the intended
recipient, you are hereby notified that any review, retransmission,
dissemination, distribution, copying or other use of, or taking of
any action in reliance upon, this information is strictly
prohibited. If you have received this communication in error,
please contact the sender and delete the material from your computer.
>