1. John Raghanti
  2. PowerServer
  3. Friday, 9 August 2024 18:10 PM UTC

Hi!

I'm trying to follow the Elevate Session from 2022 to set up a dynamic SQL Server database for housing the PowerServer caches. I am using PowerBuilder 2022 R3, which looks different than the presentation I watched.

https://www.youtube.com/live/a5U4XblFJbA

In my AppConfig.json file I modified the connection string based on what I could see in the video. I think there may be something wrong with it that I hope someone can point out to me.

"ConnectionStrings": {
"AppConfig": "Data Source=HSMSOHDB\\v200,64892;Initial Catalog=MicroMD;Integrated Security=False;User ID=XXXX;Password=XXXXXXXX;Pooling=True;Min Pool Size=0;Max Pool Size=100;TrustServerCertificate=True;"
}

Then I changed AppConfigExtensions.cs to only have the SQL Server configuration.

When I run the ServerAPIs, the command shell opens and doesn't report any errors, but I'm not seeing any tables created. Any idea how to troubleshoot this one?


Thanks!

John

 

Accepted Answer
John Raghanti Accepted Answer Pending Moderation
  1. Thursday, 15 August 2024 12:56 PM UTC
  2. PowerServer
  3. # Permalink

This one was my fault - I was connecting to the wrong database instance. I trusted the port number given to me by someone else without verifying it. Once I got the correct port, everything was fine.

Comment
There are no comments made yet.
David Xiong @Appeon Accepted Answer Pending Moderation
  1. Monday, 12 August 2024 08:00 AM UTC
  2. PowerServer
  3. # 1

Hi John,

 

Please refer to the document link below to check if your configuration is correct.

https://docs.appeon.com/ps2022r3/Storing_the_database_connection_in_the_database.html

 

Additionally, please note that if you are already connected to the database that saves the configuration (such as MicroMD) before running, you need to Refresh in order to display tables like powerserver_applicationconfig.

 

Regards,

David

Comment
  1. John Raghanti
  2. Monday, 12 August 2024 11:18 AM UTC
Hi David, I did follow that document. I'm afraid that I have something wrong with my connection string for SQL Server. There aren't any examples of that to be able to check.
  1. Helpful
  1. David Xiong @Appeon
  2. Tuesday, 13 August 2024 01:56 AM UTC
Hi John, you can open SnapDevelop, and then refer to the link below, "Create a database connection," to check whether your connection string can connect to the database successfully.

https://docs.appeon.com/snapdevelop2022r3/SnapDevelop_Users_Guide/Chapter8Working_with_Database_Connections.html

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