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.