Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Azure sql server database as powerserver datasource

  1. How-to
0
Votes
Undo
  1. Bindu S
    Bindu S
  2. PowerServer 2020 or older (Obsolete)
  3. Saturday, 4 May 2019 10:37 AM UTC

Hi ,

 

What would be the Database Source to create a data source using Azure MS SQL Server in Appeon Power Server?

 

My sql database is in Azure, 

 

Thanks & Regards

BS

Password encryption/decryption in PowerServer Web
Application run using iwarunner, the 'x' coordinat...
Responses (2)
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Monday, 6 May 2019 09:01 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hello Bindu,
PowerServer supports ODBC driver for SAP SQL Anywhere (8/9/10 only), ASE and HANA DBs.
For MS SQL Server, either on Azure Cloud or dedicated server, you must use "SQL Server Native" datasource type.
You may have the "test connection" button working if you select ODBC, but that is only a DB ping for testing hostname and port.
Best,
.m

 

Comment
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Saturday, 4 May 2019 13:52 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

 microsoft sql server  - use native, but ODBC should work too

   

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.