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)
Pulickal Antony
Pulickal Antony Accepted Answer Pending Moderation
  1. Tuesday, 13 November 2018 05:05 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

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

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.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.