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

Resolved MS SQL Server Azure Connection

  1. How-to
0
Votes
Undo
  1. Jhonns Salas
    Jhonns Salas
  2. PowerBuilder
  3. Tuesday, 4 June 2024 18:56 PM UTC

Hello,

 Where is it possible to find the database driver for Microsoft Azure after PowerBuilder 2017,

and what drivers were deprecated.

I understand that after PB 2017, new drivers to connect MS SQL Server and Azure were provided.

 

Thanks and regards.

Passing a datawindow in a structure from one user ...
Enable DEP/SafeSEH/ASLR and Anti Tamper protectio...
Responses (2)
mike S
mike S Accepted Answer Pending Moderation
  1. Tuesday, 4 June 2024 19:08 PM UTC
  2. PowerBuilder
  3. # 1

azure sql is the location of the sql server.  so use sql server drivers.  

Comment
Jhonns Salas
  1. Jhonns Salas
  2. Tuesday, 4 June 2024 19:23 PM UTC
Do you know where in Appeon I can find documentation about that?



Thanks,
  1. Helpful
John Fauss
  1. John Fauss
  2. Wednesday, 5 June 2024 01:29 AM UTC
To obtain the SQL Server client software, you can download it (still) for free from Microsoft. Do a web search. Be aware there are both 32-bit and 64-bit versions (I think they are both packaged in one .msi).

Ensure it is installed and configured correctly by testing it with SQL Server Management Studio (there may be an Azure equivalent, I don't know).

Once that is working, then use the "SNC" database client in PowerBuilder (SQLCA.DBMS = "SNC") and configure the connection parameters to connect to your database. There is NO Azure-specific PB documentation that I'm aware of, as Azure is simply the platform that is used to provide an instance of a SQL Server database. My knowledge of Azure is extremely limited, so I encourage others in the Community to correct me and offer additional guidance.
  1. Helpful 2
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 5 June 2024 17:30 PM UTC
  2. PowerBuilder
  3. # 2

HI Jhonns;

  FYI: Microsoft has deprecated the SNC DB Client driver since SS 2016 & higher. Microsoft now states that for SS 2017/2019 & higher that you should be using the new "MSOLEDBSQL" DB Client. That also applies for SS on Azure.   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.