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

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 UTC
  2. PowerBuilder
  3. # 1

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
  1. Armeen Mazda @Appeon
  2. Thursday, 14 November 2019 21:58 PM UTC
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. Helpful
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 14 November 2019 18:54 PM UTC
  2. PowerBuilder
  3. # 2

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

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

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
  1. Roland Smith
  2. Thursday, 14 November 2019 18:51 PM UTC
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. Helpful
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.