Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 viaODBC or JDBC - Mailing list pgsql-general

From Igor Korot
Subject Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 viaODBC or JDBC
Date
Msg-id CA+FnnTw+Pq0gS29jzpzL_dquk8kN9th5ySWBqs+2XPZ6Gxu+gg@mail.gmail.com
Whole thread Raw
In response to Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBCor JDBC  (Matthias Apitz <guru@unixarea.de>)
Responses Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBC or JDBC
List pgsql-general
Hi,



On Fri, Jun 26, 2020, 8:31 AM Matthias Apitz <guru@unixarea.de> wrote:

Hello,

After the very successful migration of our Library Management System
(which uses ESQL/C, DBI, JDBC) together with PostgreSQL 11.4, we want to do the
same with another LMS written in Powerbuild, running in an EAServer and
currently using Sybase ASE as DBS.

There is an error situation already on the connection phase, the ODBC
debug logs show that the connection establishment and authentication to
the PostgreSQL server is fine (also the disconnect), but the EAServer
makes an error out of this and returns to the Powerbuilder software that
the connection is invalid,
raising some error 999 without saying much in the log files what this
could mean or is caused from.

So what operation is eroding out?
Can you try to isolate it?

Thank you.


I know this is difficult to analyze with all this proprietary software
stack, but my first question here is: anybody out here who could manage
such an architecture successful working?

And please do not send hints of the type, rewrite everything in Java or
Visual Basic, as this is not an option :-)

Thanks

        matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub


pgsql-general by date:

Previous
From: Matthias Apitz
Date:
Subject: Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBCor JDBC
Next
From: Adrian Klaver
Date:
Subject: Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 viaODBC or JDBC