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

Resolved Oracle 2 PostgreSQL

  1. Issue
0
Votes
Undo
  1. Gimmy Susan
    Gimmy Susan
  2. PowerBuilder
  3. Thursday, 7 June 2018 08:30 AM UTC 
Good morning
We are experimenting on porting some of our applications from Oracle to PostgreSQL.

A strange situation happens to me:
If I do a select on a table or view that does not exist, the connection drops. It also turns to you?

Also I wanted to know if i can connect to PostgreSQL with native drivers and not via odbc

thanks in advance
Gimmy
  1. PostgreSQL
column index in a crosstab DW
Deploy .Net Web Service target
Responses (2)
Gimmy Susan
Gimmy Susan Accepted Answer Pending Moderation
  1. Thursday, 7 June 2018 15:20 PM UTC
  2. PowerBuilder
  3. # 1

ok, let's take a step back.
Which drivers do you recommend appeon for PostgreSQL to avoid problems?
(liked the link)
Thank you

Comment
David Peace (Powersoft)
  1. David Peace (Powersoft)
  2. Friday, 8 June 2018 08:02 AM UTC
I'm talking about the PostgeSQL transport drivers. You must have installed these to connect to the DB. I'm suggesting that you test them with another client other than PB to see if the problem is at that layer or in the PB ODBC potentially.



 

  1. Helpful
There are no comments made yet.
David Peace (Powersoft)
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Thursday, 7 June 2018 14:29 PM UTC
  2. PowerBuilder
  3. # 2

Hi Gimmy

Firstly I do not think there is native support for PostgresSQL.

Secondly the disconnection error you are getting is rather odd but could be a problem in your ODBC driver. What happens if you use another product to connect (like excel) does the select cause a disconnection?

Cheers

David

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 7 June 2018 18:13 PM UTC
Hi David;



  FWIW: You are correct ... PB2017R2 only supports an ODBC connection interface to the PostgreSQL DBMS currently.



Regards ... Chris

  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.