• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • How to connect my 32 bit app to a PostGreSQL database?

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

Resolved How to connect my 32 bit app to a PostGreSQL database?

  1. How-to
0
Votes
Undo
  1. Olan Knight
    Olan Knight
  2. PowerBuilder
  3. Friday, 25 January 2019 18:41 PM UTC

PowerBuilder v12.1
Windows 7, 32 bit platform


Due to the insanely high cost of Oracle, our company has decided to migrate our databases to PostGreSQL.

We currently connect to the Oracle databases using the native Oracle driver for Oracle 10: PBO10120.DLL.

Is there a native driver for PG databases?
In a previous thread, Chris mentions that he uses ODBC to connect to PG, but  I was unsure if he was referring to a 64 bit environment only.

Does PG come in 32 bit AND 64 bit flavors?

How would I connect my 32 bit app to a 32 bit PostGreSQL database?
How would I connect my 32 bit app to a 64 bit PostGreSQL database?


Thanks,

Olan

Change EditMask on Mobile
Powerfilter display value
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 25 January 2019 19:38 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Olan;

   FYI: PostgreSQL support was first added into PB in the Appeon PB2017R2 - released in January, 2018.

From the PB help ...

PowerBuilder supports the PostgreSQL ODBC driver, so PowerBuilder apps can connect with the PostgreSQL 10 (32-bit and 64-bit) (ANSI and Unicode) database through the PostgreSQL ODBC driver.

HTH

Regards ... Chris

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 25 January 2019 20:07 PM UTC
Both PG client DLL's are accessed through PB2017R2's updated ODBC driver. One which of course one sits in the 32 folder and one in the 64 bit folder. So the ODBC DLL's of course are called "PBODB170.dll".



I am using both PG 32 & 64 bit connections with my PB2017R3 & related Apps just fine. I am using PG DBMS versions 10.0.1 and 11.1.1 currently with PG Admin 4.1.



FYI: Some "Kool" PG stuff: https://medium.com/@thrinz/create-on-the-fly-rest-api-using-postgres-database-functions-6d9061e66f3d

  1. Helpful
There are no comments made yet.
Responses (3)
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Friday, 25 January 2019 20:26 PM UTC
  2. PowerBuilder
  3. # 1

Thanks again, Chris.

Once we get the PG databases set up I'll test the 32 bit version of PBODB17.DLL in my 32 bit native PB application.

I found the 32 bit DLL and its associated INI here:
    C:\Program Files (x86)\Appeon\Shared\PowerBuilder

While researching this, I saw a section that seemed to indicate that I need to modify the INI file:

https://www.appeon.com/support/documents/appeon_online_help/pb2017r3/whats_new/ch03s03.html
PowerBuilder supports the PostgreSQL ODBC driver, so PowerBuilder apps can connect with the PostgreSQL 10 (32-bit and 64-bit) (ANSI and Unicode) database through the PostgreSQL ODBC driver. For how to configure the PBODB170.INI file, see the section called “APPENDIX Adding Functions to the PBODB170 Initialization File” in Connecting to Your Database.

When I read through that appendix, there did not seem to be any PG-specific information.

1)  Do I need to modify the PBODB17.INI file I picked up?
2) If so, WHAT needs to be modified?


As always, Thank you!

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 25 January 2019 21:13 PM UTC
The PBODB170.INI has a new [PostgreSQL] section. however, I doubt that this will work (work well) with PB 12.x or its ODBC driver (PBODB120.dll). You can always try but, an upgrade to PB2017R3 would be the best IMHO to get the full support for PG.

  1. Helpful
Olan Knight
  1. Olan Knight
  2. Friday, 25 January 2019 22:35 PM UTC
I agree. Now get my company to agree and we'll have a quorum! :)



Olan
  1. Helpful
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Friday, 25 January 2019 19:48 PM UTC
  2. PowerBuilder
  3. # 2

Wonderful, and thank you, Chris!

What's the name of those two driver DLLs?
Where are they located?
And will they work with PBv12.1?

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