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

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 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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.