1. David Peace (Powersoft)
  2. PowerServer
  3. Thursday, 15 August 2024 11:42 AM UTC

Hi Guys

We have an application that we want to deploy using PowerServer. The core database will be cloud hosted that all works fine. However, the app needs to connect to a 3rd party database that will be on the Clients local network. How do I configure the Transaction object so that it is not converted to a Powerserver web accessed DB, but is accessed in the normal PB way?

Cheers

David

**Edited** to tag this as an enhancement request.

Accepted Answer
mike S Accepted Answer Pending Moderation
  1. Thursday, 15 August 2024 13:12 PM UTC
  2. PowerServer
  3. # Permalink

with powerserver, you cannot use a transaction object to use database drivers - it must be via web api calls.

 

you can use oledb ADODB and do everything yourself outside of the transaction objects

Comment
  1. David Peace (Powersoft)
  2. Thursday, 15 August 2024 13:28 PM UTC
That's not a very elegant solution, but thanks.

It's a shame, it would not take much to have a property on the transaction object to not "powerserver"ise the SQL related to it.
  1. Helpful
  1. Chris Pollach @Appeon
  2. Thursday, 15 August 2024 14:04 PM UTC
Hi David;

I have a few Apps like this. I used a 2nd App exe that the PS App calls in order to access a local DB. HTH

Regards ... Chris
  1. Helpful
There are no comments made yet.


There are replies in this question but you are not allowed to view the replies from this question.