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

From Adrian Klaver
Subject Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 viaODBC or JDBC
Date
Msg-id 7b2cdded-904d-4ec5-7c8c-9d41aae7880a@aklaver.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  (Rene de Gek <renedegek@gmail.com>)
List pgsql-general
On 6/26/20 6:31 AM, Matthias Apitz 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.

A quick search found that this code be returned if the correct server 
type is not specified in EAServer.

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


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 viaODBC or JDBC
Next
From: Tom Lane
Date:
Subject: Re: timestamp - timestamp result