Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBC or JDBC

2020-07-01 Thread Virendra Kumar
System level call trace might help little bit using strace/truss utility. Regards, Virendra Kumar On Wednesday, July 1, 2020, 9:26:09 PM PDT, Rene de Gek wrote: Hi Adrian, Thank you for your reply. This was one of the things that Matthias has also  suggested to us, referring to https:/

Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBC or JDBC

2020-07-01 Thread Rene de Gek
Hi Adrian, Thank you for your reply. This was one of the things that Matthias has also suggested to us, referring to https://sybase.public.easerver.powerbuilder.narkive.com/MsoAXSQJ/problem-connecting-to-database-from-easerver-component . We do set the server type to ODBC. The error 999 shows up

Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBC or JDBC

2020-07-01 Thread Rene de Gek
Item 3 from my previous message is resolved. For some reason there was a line in the odbc.ini "ConnSettings = prepareThreshold=0" I think this is one of the things we have tried and forgot to remove. After removing it, the application still reports "code: 999, sqlerrortext: An invalid handle was

Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBC or JDBC

2020-06-30 Thread Rene de Gek
> > So what operation is eroding out? > Can you try to isolate it? > > Thank you. Hi, Thank you for posting the question Matthias! And for your replies. We've now managed to collect the log files now from the application, driver manager and driver. And there are actually some things that might b

Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBC or JDBC

2020-06-26 Thread Adrian Klaver
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 AS

Re: Connecting Powerbuilder / EAserver to PostgreSQL server 11 via ODBC or JDBC

2020-06-26 Thread Igor Korot
Hi, On Fri, Jun 26, 2020, 8: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