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

Resolved where I can download "PostgreSQL Native Drive" (for PostgreSQL version 10.5)

  1. How-to
0
Votes
Undo
  1. Antony Xavier
    Antony Xavier
  2. PowerBuilder
  3. Thursday, 8 November 2018 05:04 AM UTC

Greetings.,

From where I can download "PostgreSQL Native Drive" (for PostgreSQL version 10.5) . 

Installed Appeon Powerbuilder 2017, but not showing in the connection cache.

 

ref. https://www.appeon.com/support/documents/appeon_online_help/2016/server_configuration_guide_for_net/ch03s04s10.html

 

 

Warm regards

Antony

.Net assembly web service security
Application Slowness when printers are working slo...
Accepted Answer
Antony Xavier
Antony Xavier Accepted Answer Pending Moderation
  1. Tuesday, 13 November 2018 07:43 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Chris,

Resolved

https://www.appeon.com/standardsupport/track/view?id=1865

 

PowerServer doesn't support using ODBC Driver to connect the PostgreSQL,
please use the PostgreSQL native driver to resolve this kind of issue.
https://www.appeon.com/support/documents/appeon_online_help/2017/
server_configuration_guide_for_net/supported_database_drivers.html

Our .Net server is using the Npgsql which is the .NET data provider for
PostgreSQL. you are not need to install extra driver.

Please go to AEM > Server > Resources > Data Source > %your data source% to
change the data source type from 'ODBC Driver' to 'PostgreSQL native driver'.

 

Regards

Antony

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 13 November 2018 14:28 PM UTC
I use the native driver all the time (as you can see from my previous screen shots) but, the ODBC driver works as well for me (FWIW).
  1. Helpful
There are no comments made yet.
Responses (4)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 13 November 2018 14:26 PM UTC
  2. PowerBuilder
  3. # 1

Hi Anthony;

   PowerServer does support ODBC. I have PS2017 connected to PG10 & 11 via 64bit ODBC client driver. The key is to remember though is to install the 64bit driver during the PG installation when in the "Stack Builder" phase of the install.

FYI ...

Regards ... Chris

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 12 November 2018 20:55 PM UTC
  2. PowerBuilder
  3. # 2

Hi Anthony;

  FYI: No problems connecting to PG version 10, 10.5 or the latest 11.1 when the 64bit driver is installed via PowerServer 2017 ...

HTH

Regards ... Chris

Comment
Antony Xavier
  1. Antony Xavier
  2. Tuesday, 13 November 2018 05:21 AM UTC
Hi Chris,



Test data source also succeeded, but when connect Application from the browser, I am getting the error.



"[Application name=mdm,conn cache=mdm_test]key=value argument incorrect in ConnectionString Parameter name: dsn".



Regards

Antony
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 12 November 2018 15:08 PM UTC
  2. PowerBuilder
  3. # 3

Hi Anthony;

   Make sure that you install both the 32bit driver (for PB) and the 64bit PostGreSQL driver (for PowerServer). Note that the 32bit driver is only installed by default. You must manually select the 64bit driver as well when running the DBMS installer. Make sure that you also elect to install the "Stack Builder" utility as well. That is where the driver selection is ....

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