Connection between PostgreSQL and SAP HANA database

2024-10-13 Thread Thürmann , Andreas
.postgresql.org' Betreff: Re: Connection between PostgreSQL and SAP HANA database On 10/10/24 02:54, Thürmann, Andreas wrote: > Please excuse the late reply. I didn't have time to continue working > on this project. > > I still don't get a response to the query. The query contin

Re: Connection between PostgreSQL and SAP HANA database

2024-10-11 Thread Adrian Klaver
On 10/11/24 09:16, Adrian Klaver wrote: On 10/11/24 01:23, Thürmann, Andreas wrote: Please do not post. The convention on this list is to inline or bottom That should have been do not top post. post. That makes it easier to follow the conversation flow. See: -- Adrian Klaver adrian.kla..

Re: Connection between PostgreSQL and SAP HANA database

2024-10-11 Thread Adrian Klaver
On 10/11/24 01:23, Thürmann, Andreas wrote: Please do not post. The convention on this list is to inline or bottom post. That makes it easier to follow the conversation flow. See: https://en.wikipedia.org/wiki/Posting_style Yes I run it under Windows, I also have a Linux server for testing.

Re: Connection between PostgreSQL and SAP HANA database

2024-10-10 Thread Adrian Klaver
On 10/10/24 02:54, Thürmann, Andreas wrote: Please excuse the late reply. I didn't have time to continue working on this project. I still don't get a response to the query. The query continues indefinitely and the data output window shows only „Waiting for the query to complete...“ In the S

Re: Connection between PostgreSQL and SAP HANA database

2024-09-12 Thread Adrian Klaver
On 9/9/24 08:35, Thürmann, Andreas wrote: Adrian Klaver (adrian.kla...@aklaver.com ) asked: Postgres version? PostgreSQL 16 with pgAdmin 16 4.2.2 Have you tried tried this using psql? Have you looked at Postgres log for errors?     No erro

Connection between PostgreSQL and SAP HANA database

2024-09-11 Thread Thürmann , Andreas
Ron Johnson (ronljohnso...@gmail.com) asked me the following. Answers below: 1. What error did you get? No error, the query runns into infinity (>30 min.) without a result. 2. Which command caused the error? Test-query like SELECT * FROM hana_table LIMIT 10; 3. Wha

Re: Connection between PostgreSQL and SAP HANA database

2024-09-09 Thread Adrian Klaver
On 9/9/24 00:53, Thürmann, Andreas wrote: Hello everyone, I'm currently trying to establish a connection between PostgreSQL and a SAP HANA database. Unfortunately, so far without success. SAP's own ODBC driver works correctly and I can query the HANA database using an ISQL command. However,

Connection between PostgreSQL and SAP HANA database

2024-09-09 Thread Thürmann , Andreas
Hello everyone, I'm currently trying to establish a connection between PostgreSQL and a SAP HANA database. Unfortunately, so far without success. SAP's own ODBC driver works correctly and I can query the HANA database using an ISQL command. However, I can't establish a connection from PostgreSQL