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

Resolved Work with PostgreSQL

  1. How-to
0
Votes
Undo
  1. ATK Gimmy Susan
    ATK Gimmy Susan
  2. PowerBuilder
  3. Tuesday, 23 June 2020 08:49 AM UTC

good morning

I'm starting to work with PostgreSQL, but I'm having some difficulties.

It looks like an IDE problem.


Can anyone help me ?

I attach Print Screen

 

1) i see the tables

 

2) if i selecct a table i can't see the columns

 

3) if i use datawindow painter for build a datawindow i have no column.

 

4) If i use dbpainter for execure a sql, it works well.

 

 

Ecosystem:

- Windos 10 64bit

- PostgreSQL version 12.2 installed on server linux

- odbc 32bit 

- Powerbuilder 2019r2

 

Thanks in advance

Regreats

Gimmy

 

compilation errors does not display
Windows 10 TImer
Accepted Answer
ATK Gimmy Susan
ATK Gimmy Susan Accepted Answer Pending Moderation
  1. Monday, 29 June 2020 16:14 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Chris

The problem is not with permissions, but with the version of the ODBC drivers.

It is not clear to me how the drivers are compatible with the server (odbc_version VS server_version); especially if there is a retro compatibility, but changing the version of the odbc drivers everything worked.

 

 

 

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Monday, 29 June 2020 18:31 PM UTC
Thanks for sharing the solution!
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 29 June 2020 18:53 PM UTC
Hi Gimmy;

Yes, I had the same issue with PostGreSQL when I started with it. Seems like the default ODBC client install with the base DBMS install was OK for the PG "Console" app to work but not PB. I then had to separately download the ODBC driver pack for the PG version I just installed and then after that installation, the PB IDE and Apps were OK. Seems like a PG "packaging" / install issue to me.

Regards ... Chris
  1. Helpful
There are no comments made yet.
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 23 June 2020 14:53 PM UTC
  2. PowerBuilder
  3. # 1

Hi Gimmy;

  The most likely reason would be that the User ID that you are logging into the PostGreSQL database with does not have the proper Table / Column permissions. I get the same issue on my test systems until I either a) login in with a User ID that has DBO ( DB Owner) table access or b) grant the table / column permissions to my PB Developer user DB Login account.

HTH

Regards ... Chris

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.