Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Native PostGres driver for PB 2019?

  1. How-to
0
Votes
Undo
  1. Rachid Sbaibi
    Rachid Sbaibi
  2. PowerBuilder
  3. Thursday, 8 July 2021 07:22 AM UTC

Hi,
I want to connect my powerbuilder application to PostGres, Is there any native PostGres driver or should I connect via ODBC/JDBC driver?
Right now, I could connect the database painter using ODBC driver.

Regards.

  1. PostgreSQL
Crosstab datawindow blinking and after that close ...
Select Protected Datawindow Rows
Responses (3)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 14 July 2021 14:33 PM UTC
  2. PowerBuilder
  3. # 1

Is there any documentation, preferably with examples,on how to do this?

Thanks,
Olan

 

Comment
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 8 July 2021 17:08 PM UTC
  2. PowerBuilder
  3. # 2

For PowerBuilder client/server projects you must use ODBC to connect to Postgres.  For PowerBuilder cloud projects (i.e. PowerServer or .NET DataStore) you would use the native .NET provider, which is packaged in the PowerServer/.NET DataStore library.  

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 14 July 2021 14:48 PM UTC
Now, that being said... maybe for Postgresql it won't work and the only way to go is ODBC. That's another thing.
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Wednesday, 14 July 2021 16:10 PM UTC
OK, I will revise my answer. But for sure when doing client/server development against Postgres we only put the effort to test and support ODBC. https://docs.appeon.com/pb2017r2/whats_new/ch01s03.html
  1. Helpful
Olan Knight
  1. Olan Knight
  2. Wednesday, 14 July 2021 16:53 PM UTC
Thanks, guys, for the feedback and information. This "simple" project brought on my (who else) management has been difficult from the start. *Sigh*

  1. Helpful
There are no comments made yet.
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Thursday, 8 July 2021 08:10 AM UTC
  2. PowerBuilder
  3. # 3

AFAIK, currently ODBC is the only way available to connect PostgreSQL.

 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 8 July 2021 14:12 PM UTC
Correct
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.