1. Christian Desloges
  2. PowerBuilder
  3. Thursday, 14 November 2019 16:56 PM

We are having several issues accessing a MSSQL Server 2016 database using "ODBC Driver 13 for SQL Server".  My question is simple:  Is "ODBC Driver 13 for SQL Server" supported for applications built using PowerBuilder 2017?

Christian Desloges Accepted Answer Pending Moderation
  1. Thursday, 14 November 2019 19:16 PM
  2. PowerBuilder
  3. # 1
0
Votes
Undo

Thank you Chris and Roland for the feedback.  It was very helpful.  I think the solution for us will be to use the SQL Native Client.

Comment
SQL Native Client is a solid choice. When PB 2019 R3 is released, you may want to consider switching to SQLOLEDB or ADO.NET.
  1. Armeen Mazda @Appeon
  2. Thursday, 14 November 2019 21:58 PM
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 14 November 2019 18:54 PM
  2. PowerBuilder
  3. # 2
0
Votes
Undo

My understanding is that they are working on support for it in the next PB 2019 update.

Comment
Hi Roland .. Yes, that would be for Azure SS support AFAIK.
  1. Chris Pollach @Appeon
  2. Thursday, 14 November 2019 19:20 PM
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 14 November 2019 18:22 PM
  2. PowerBuilder
  3. # 3
0
Votes
Undo

Hi Christian;

  For SS2016, the DBMS supplied ODBC client is the "SQL Server Native Client 11" driver. When you install the SS2016 (or 2017/2019 for that matter) DBMS, it will also install the above mentioned client.

ODBC Admin ...

IDE ...

Note: Make sure that your DSN is a "System" defined DSN.

HTH

Regards ... Chris

Comment
The OP is talking about the new SQL Server ODBC driver which I am pretty sure the dev team is working on supporting. It was mentioned at the conference.
  1. Roland Smith
  2. Thursday, 14 November 2019 18:51 PM
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.