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

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 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
  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
  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
  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 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
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.