1. jagamohan dash
  2. PowerServer
  3. Monday, 12 August 2024 14:06 PM UTC

Our ERP Clients using two Database in one system with data sharing from two different folder bcoz they are having database wise image print and qr code from physical folder,we want to migrate them to power client ,but as power cleint can be installed in one time in one user not allwoing multiple instance we are not able to implement,so please advice on this process .

Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 12 August 2024 19:00 PM UTC
  2. PowerServer
  3. # 1

Are you doing a PowerClient or PowerServer project?  What Chris said is for PowerServer.  But in your title and description you say PowerClient.  PowerClient you would switch the DB same way you do in a traditional client/server application.  PowerClient is just an installer/updater utility for your client/server app.  PowerServer re-architects your app to be n-tier and DB connection happens on the server side (not client side) so then what Chris said is correct for that scenario.

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 12 August 2024 17:41 PM UTC
  2. PowerServer
  3. # 2

Hi Jagamohan;

  1. Create one DB "cache" in PS per DB instance you need your App(s) to access for each customer
  2. In the PB App, set the SQLCA.DBParm "cachename=xxxx" at runtime to direct the PS connection to the DB instance you need that customer to use.

Check out the use of the "cachename" parameter in both the PB & PS help.

HTH 

Regards ... Chris 

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