-
Jim Nesbitt
- PowerServer
- Wednesday, 24 May 2023 07:11 PM UTC
I'm converting a Powerbuilder application to PowerServer so it can operate using the SaaS model.
I've been following the guidelines in this video.
Creating a SAAS Application with PowerServer 2022
https://www.youtube.com/watch?v=a5U4XblFJbA&ab_channel=Appeon
We need to hold database configuration in the database also so we can set up new databases for different clients. While preparing for this, I checked the docs in
https://docs.appeon.com/ps2022/Introduction_to_the_PowerServerApp_solution.html
We set a number of values in the DBPARM for SQLCA when connecting with PowerBuilder, but I couldn't see how our required values can be set from this documentation. I thought OtherOptions might be where to place them, but there's no info on adding the DBPARM values we need. It also mentions OtherOptions can be set up in the project painter, but it hasn't got the options I need.
Ideally, I want to be able to use the same details in PowerServer as we are providing in our PowerBuilder connectionstring DBPARM, but couldn't find out how to do this.
My question is - will the DBPARM values be applied to the cachename connection by PowerServer (hopefully) - If not, how do I configure them
Samples of our DBParms and SnapDevelop configuration.
-- DBPARM Settings
TrimSpaces=1;
StaticBind=0;
RecheckRows=1;
Identity='SCOPE_IDENTITY()' ;
AppName='LoadmaX';
OJSyntax='ANSI';
TrustedConnection=1;
ProviderString = 'MARS Connection=False' ;
PBMaxBlobSize=21000000;
Database='loadmax_ps2022';
LongConnection=1
-- SNAPDEVELOP
"Connections": {
"Default": {
"loadmax_cache": {
"ConnectionType": "SqlServer",
"Database": "loadmax_ps2022",
"Host": "PBS41",
"Port": 1433,
"UserID": "sa",
"Password": "*********",
"EnablePooling": true,
"MinPoolSize": 0,
"MaxPoolSize": 100,
"ConnectionLifetime": 0,
"ConnectionTimeout": 15,
"CommandTimeout": 30,
"SecurityOptions": "encrypt=False",
"OtherOptions": null,
"DynamicConnection": false
},
Cheers
Jim
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.