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

Resolved Database Connection - Powerserver Error

  1. Advice
0
Votes
Undo
  1. Clifford Gregory
    Clifford Gregory
  2. PowerServer
  3. Tuesday, 3 January 2023 14:31 PM UTC

New to Powerserver. When running the program, an error message pops up stating that the program cannot connect to the database. Within the program the connection string is as follows:

SQLCA.DBMS = "ODBC"
SQLCA.DBParm = "ConnectString='DSN=EpicEsso;UID=sa;PWD=*******',CallEscape='No',DisableBind=1,DisableUnicode=1,Maxconnect=250"
sqlca.logpass = 'sa'
sqlca.logid = '*******'
sqlca.autocommit = TRUE

The error message is:

below is the cache configuration:

What am I missing?

thank you.

Powerserver dw_1.Retrieve(), time wait before DBer...
IDE updates Datawindow and PowerServer does not
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 3 January 2023 15:41 PM UTC
  2. PowerServer
  3. # 1

Hi Clifford;

  I see that you have the "Dynamic Connection" setting checked. So that means that the only thing being used from your Apps SQLCA transaction object is the "LogPass" and "LogID" values. All other settings are ignored. So make sure that the values being passed in those two transaction object settings are valid for the PowerServer to DBMS connection that you are using at execution time.

  Note: PowerServer uses a native connection to SS and not ODBC.

HTH

Regards ... Chris

Comment
There are no comments made yet.
Clifford Gregory
Clifford Gregory Accepted Answer Pending Moderation
  1. Tuesday, 3 January 2023 17:08 PM UTC
  2. PowerServer
  3. # 2

Thank you for the hint Chris, the program connects to the database. I appreciate the help. 

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 3 January 2023 17:20 PM UTC
That's great news Clifford.

Happy New Year!
  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.