1. Roland Smith
  2. PowerBuilder
  3. Tuesday, 17 October 2017

Microsoft says it no longer supports SQL Server Native Client and they didn't provide a new version with SQL Server 2016.

I am wondering what the future is for connecting to SQL Server.

I have PB 12.5.2 and SQL Server 2016. I am using an ODBC connection using the ODBC driver "SQL Server Native Client 11.0".

This setup doesn't recognize valid stored procedure declare statements. I have to switch to a SNC connection to get it to work.

I also have a driver installed called "ODBC Driver 13 for SQL Server" which is the preferred connection method for SQL Server 2016. I have the same problem as the other ODBC driver:

Database C0038: An error occurred, but no message was returned by the database driver.

I hope that PB 2017 and beyond won't have this issue using ODBC. This is an IDE only error compiling the declare statement. The application runs fine using ODBC.

 

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
0
Votes
Undo

Hi Roland;

    Please open a support ticket for the ODBC issue(s) with SS2016. Going forward, the two preferred SS connectivity mechanisms are ODBC and ADO.Net - so PB should definitely support these client DB interfaces 100% for the MS SS DBMS.

Regards ... Chris

Comment
There are no comments made yet.
  1. Wednesday, 18 October 2017
  2. PowerBuilder
  3. # 1
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.