SQL server used is MS SQL 2012 and I can connect it with Native Client (OLE DB) without problems from PB 2017R2 Database profiles. When I copy connection setting I get :
// Profile Mara_test_Native
SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"
SQLCA.LogPass = <********>
SQLCA.ServerName = "SUNI1703\sqlexpress"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='SHR',Provider='SQLNCLI11'"
I paste and edit it to application ini-file to :
DBMS = "SNC SQL Native Client(OLE DB)"
LogPass = something
ServerName = SUNI1703\sqlexpress
LogId = sa
AutoCommit = False
DBParm = "Database='SHR',Provider='SQLNCLI11'"
When application is run connection fails. Connection is successful when using ODBC driver, but then I can't access a blod-data (Word documents) stored in database. Native client has been used several years with previous versions of PB and SQL without problems.