Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBCor JDBC - Mailing list pgsql-general

From Matthias Apitz
Subject Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBCor JDBC
Date
Msg-id 20200626133135.GA9806@sh4-5.1blu.de
Whole thread Raw
Responses Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 viaODBC or JDBC
Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 viaODBC or JDBC
List pgsql-general
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.

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: "Jim Hurne"
Date:
Subject: RE: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked
Next
From: Igor Korot
Date:
Subject: Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 viaODBC or JDBC