You’re offline. This is a read only version of the page.
102
I have a Power App program that has been connected with a Power App Gateway to an On-Premise SQL Server instance. I just learned today that the SQL Server instance and databases are going to be hosted in another company's Server environment. And that company will not allow the Gateway to be installed there.
Is there a way I can connect my application to that remote environment?
They have offered to give me enough information to create an ODBC connection to that new remote SQL Server, but I'm not sure if that will help me.
Any help?
Thanks,
Larry
I got this issue sorted.
I used the ODBC connection information with SQL SERVER v.17 driver to create System DSN. I used this DSN reference and connection string to create Linked server in MSSMS and rewrote my queries using remote SQL Server tables to reference local linked servers instead.
Yea!
Share
Report
All responses (
Answers (
