• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • PowerServer2021 - ODBC connection in end-user PC

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

Resolved PowerServer2021 - ODBC connection in end-user PC

  1. How-to
0
Votes
Undo
  1. Chen Mey Lee
    Chen Mey Lee
  2. PowerServer
  3. Thursday, 13 May 2021 06:22 AM UTC

Hi,

I using PowerServer2021 beta 2.

Use below setting to connect Sybase 15.5  worked fine in development server :-

SQLCA.dbms = 'ODBC'

SQLCA.dbparm = "ConnectString='DSN=xxx;UID=xxx;PWD=xxx'", driver='ase'

But when connect from end-user PC below error return :-

R0222 - Applicatoin terminated. Error : Cannot connect to the server when creating the session.

Can we install ODBC ASE driver and setup ODBC connection in end-user PC during installation ? Like downloading the Laucher and start the application .

Below is my Connection-Cache.json :-

"Connections": [
    {
      "CacheName": "DEVK_KL_DEFDB",
      "ConnectionType": "Odbc",
      "Server": "",
      "Host": "",
      "Port": 0,
      "Database": "",
      "UserID": "",
      "Password": "",
      "MinPoolSize": 0,
      "MaxPoolSize": 100,
      "ConnectionTimeout": 15,
      "CommandTimeout": 30,
      "IsDynamicDbConnect": true,
      "OtherOptions": "",
      "EnablePooling": false,
      "ConnectionLifetime": 0,
      "OdbcName": "DEVK_KL_DEFDB",
      "DataSource": "",
      "OdbcDriver": "ASE"
    },

Powerserver needed to be restarted
Oracle SET ROLE issue
Responses (5)
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Thursday, 13 May 2021 16:21 PM UTC
  2. PowerServer
  3. # 1

Hi Chen,

PowerServer error R0222 has been discussed recently, please check this thread:

https://community.appeon.com/index.php/qna/q-a/starting-salesdemo-in-browser-at-different-pc-s-than-development-pc

Best,

.m

Comment
There are no comments made yet.
Logan Liu @Appeon
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Thursday, 13 May 2021 09:14 AM UTC
  2. PowerServer
  3. # 2

Hi Chen,

It seems that the Cloud App can't access the URL of PowerServer Web API.

1) Whether your PowerServer Web API project is running? Please make sure it's running.

2) Please check your PowerServer project - Web APIs tab - Web API URL, and check whether you can access this URL from this end-user PC.

Regards,

Logan

Comment
Chen Mey Lee
  1. Chen Mey Lee
  2. Monday, 17 May 2021 01:30 AM UTC
This is worked , thanks Logan.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 13 May 2021 09:13 AM UTC
  2. PowerServer
  3. # 3

See also the "tutorials" section:

 

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 13 May 2021 09:11 AM UTC
  2. PowerServer
  3. # 4

The best information you can get in the powerbuilder help. I think there's also some material on the appeon website.

regards

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 13 May 2021 08:47 AM UTC
  2. PowerServer
  3. # 5

I don't think you can use powerserver and connect using an odbc on the local user's pc. That's the whole idea of powerserver: all the database operations are handled by the server and there's no need for a db client installation on the local user's pc.

Did you configure the database cache and transaction object in the powerserver client object?

Your connection json is missing a lot of information.

regards.

Comment
Chen Mey Lee
  1. Chen Mey Lee
  2. Thursday, 13 May 2021 09:06 AM UTC
Last time database configure in PB2019_R2 AEM is worked in end-user PC (Using appeondconfigdatasource.of_adddatasource(eon_str_connection))

Now used PB2021 beta 2database configure PowerServer.Web APIs->database configuration.

I have changed the connection-cache.json follow AEM setting as below but not working :-

"CacheName": "DEVK_KL_DEFDB",

"ConnectionType": "ASE",

"Server": "DEVK",

"Host": "10.203.29.16",

"Port": 3001,

"Database": "KL_DEFDB",

"UserID": "xxxxx",

"Password": "YeeMoi01$",

"MinPoolSize": 10,

"MaxPoolSize": 100,

"ConnectionTimeout": 15,

"CommandTimeout": 30,

"IsDynamicDbConnect": true,

"OtherOptions": "",

"EnablePooling": true,

"ConnectionLifetime": 0,

"OdbcName": "",

"DataSource": "",

"OdbcDriver": ""

}

  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 13 May 2021 09:12 AM UTC
A lot of things have changed in ps 2021, please see my next answer.
  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.