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

Resolved Not connecting "postgre" database from "Powerserver web"

  1. Issue
0
Votes
Undo
  1. Pulickal Antony
    Pulickal Antony
  2. PowerServer 2020 or older (Obsolete)
  3. Sunday, 11 November 2018 04:50 AM UTC

Dears.,

I am trying to connect "postgre" database from "Powerserver web" thru ODBC but can't. From PowerBuilder it is working fine. I checked in "Error Logs" in the powerserver showing "[Application name=PFA System,conn cache=PFA]key=value argument incorrect in ConnectionString Parameter name: dsn".

Any Idea, 

Regards

Ansal

 

timeframe for adding encryption to powerserver
Max Number of Nested in composite
Accepted Answer
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 13 November 2018 06:59 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # Permalink 
Hi Antony,

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,
ZhaoKai
Comment
There are no comments made yet.
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Sunday, 11 November 2018 16:06 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Ansal;

   Since PS is 64bit, make sure that your using a 64bit connection. PB is 32 bit.

Regards ... Chris

Comment
There are no comments made yet.
Pulickal Antony
Pulickal Antony Accepted Answer Pending Moderation
  1. Tuesday, 13 November 2018 05:05 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

Hi Chris,

Installed 64 bit & 32 bit, other wise I cannot connect from connection cache is it, Tried with different version of Postgress   ODBC drivers of postgress 9.6 & 10.5 drivers. But still I am getting the same error as mentioned "[Application name=PFA System,conn cache=PFA]key=value argument incorrect in ConnectionString Parameter name: dsn".

 

Regards

Ansal

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.