PB and SQL Server Native Connect (SNC)

Hi,

as far as i heard PB2017 will support newer versions from Microsoft SQL Server.

So what is the future way to connect to current versions from SQL Server?  (2014/2016)

Today we are using SNC, but we still need to install the old SQL Native Client from SQL Server 2012 for this.

What are the plans from Appeon to FULL support SQL Server 2014 and 2016 ?

 

Also: Will we have to switch to ODBC to get newer features e.g. a working solution for bit datatype?

 

In addition to my post => This is a note from a Microsoft Page:

"Note that Microsoft will not be releasing a SQL Server 2014 or later version of the SQL Server Native Client. The SQL Server 2012 Native Client (v11, e.g. sqlncli11.dll), can continue to be utilized by SQL Server 2014 and later versions. "

https://www.microsoft.com/en-us/download/details.aspx?id=50402

 

also see => When to Use SQL Server Native Client

https://msdn.microsoft.com/en-us/library/ms130828.aspx

 

and see => Data Access Technologies Road Map

https://msdn.microsoft.com/library/ms810810.aspx

 

 

like0

Answers

Matt Balent replied

I recently loaded SQL Server 2016 and this is the connection information I use.

DBParm = "ConnectString='Driver="{ODBC Driver 13 for SQL Server}";QuotedId=No;TrustServerCertificate=Yes;Encrypt=Yes;Trusted_Connection=Yes;SERVER=" + ServerName + ";Database=" + Database + "'" 

DBMS = "ODBC"

This connection uses Windows security.

The SQL Native Driver won't be shipped with MS SQL Server after version 2012.  See this:

 

Chris Pollach replied

Hi Heino;

  I have been using SQL Server 2016 on two of my PB application systems for the past year. They both use SNC with is still included with SS2016 client installation & set-up.

  FYI ...

// Profile SS2016
SQLCA.DBMS = "SNC"
SQLCA.LogPass = <******>
SQLCA.ServerName = "STD-CHRIS"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='master',Provider='SQLNCLI11'"

Also ...

SS2016 Native

Regards ... Chris

 

Roland Smith replied

SS2016 comes with an install of Microsoft SQL Server Native Client 11.0 which is the version originally shipped with SS2012. The NC and OLEDB interfaces are no longer being developed by Microsoft and ODBC is their long term direction.

Appeon is planning on enhancing the SQL Server connection but exactly when hasn't been announced.

Tags