Hi Chris,

Thanks but my current application is connecting to two data source in one profile. When i connect to db server 1, inside my application will connect to two data source to get data. In our environment, we will have one server for production, another server for backup when disaster happened.



So, in power server project there, in the database section, i created two db profile, one called Default, another called m_ST2(see attachment).



In database connection profile named "Default", has two cache, one i named as "Default" connecting to M_VN database, with d_xxx data source, second cache is Default1 connecting to same M_VN db, with different data source, that is d_xxx_g (See attachment )



I have second database connection profile named "M_ST2", also has two cache, one i named as "M_ST2" connecting to "M_ST2" database, with d_xxx data source, second cache is "M_ST2_2" connecting to same M_ST2 db, with different data source, that is d_xxx_g (See attachment)



So, now when user click connect to server 1/production server , i want it to use profile Default. And if user click connect to server 2/backup server, i want it to use profile M_ST2. Can you guide me how to do that? i think the one you mentioned above is referring to different data source.

You just code PowerScript to dynamically change the value of the CacheName property if you have one single transaction object (e.g. SQLCA) and need to connect to two different databases. Or for example if you have two different transaction objects (e.g. SQLCA and SQLCA2) then you assign the one CacheName to SQLCA and other to SQLCA2.

Hi Armeen,



THanks. Currently, in my application, i have two transaction objects, sqlca for datasource 1, n_trlogged for another datasource 2. This two datasource are reside in one database server.

In business requirement, the application will be connecting to different database server(lets call it, database server A or database server B) bi-weekly. Both database server having the same two datasouce(we replicated daily). My question is how to build one URL, connecting to database server A on week 1 and the following week ,connect to database server B without need to build and redeploy the URL again with new database profile.

Hope i dnt confused you. Please see attachment earlier for sample.

Hi Sim;

FYI: the ZIP you attached is empty.

Regards ... Chris

ok. i reattached. please check. tq

Hi Chris,







I dnt understand what you mean exactly. But, what i mean build n deploy one copy of project and upload the application files and webapi files to IIS server. Only have one link https://test.com/test_app/ . What i want to ask is, what should i do, to make this one general URL link to connect to db server A or db server B dynamically? Currently my powerscript has sqlca, n_trlo, n_tr_sec, set as transaction. Do I need to make two set of transaction for different of db server A or B?

Hi Sim;

That can all be handled by using the "CacheName" DBParm setting in all of your set of Transaction objects.

Regards ... Chris

Hi

I had just replied. Please see below new message with attachment. TQ

Hi Sim;

Yes, as long as the CacheName's are mapped correctly in your PowerServer Project - then that approach should work for each of your Transaction objects.

Regards ... Chris