Hi Team,
We are using SQL Server 2012 database to connect one of the Power builder 8.0 application.
I have used below connection settings to connect for SQL server 2012.
SQLCA.DBMS = "SNC"
SQLCA.LogId = "sqluser1"
SQLCA.LogPass = "password123"
SQLCA.ServerName = "ACQServer"
SQLCA.AutoCommit = False
SQLCA.dbparam=”Database=’ACQ’, provider=’SQLNCLI11’
I am getting below error while connecting.
"dbms SNC is not supported in your current installation"
Can anyone tell me with connection settings and also help me like whether SNC is supported for Power builder 8 with SQL server 2012.
Please help me on this .
The ODBC driver is really a call to "middleware" that interacts with SS on behalf of your PB Apps(s). The ODBC layer is a different DB access than the direct route of MSS (and now SNC). If you want to use that route of DB Connection, then be prepared to add more settings in your SQLCA.DBParm field (ie StripParmNames) in order to also have your SP's accessible.
The main thing to remember is that on any DB error, always log the DB Error Number and Error Text for further problem resolution. Also, don't forget the handy SQL Trace feature of the PB run-time (SQLCA.DBMS = "TRACE ODBC" or SQLCA.DBMS = "TRACE SNC").
It sounds like you will need to migrate your app to a newer version of PB in order to be able to connect to SQL Server 2012 and newer versions, since mainstream support for SS2012 has already expired and extended support ends in 2022), since ODBC that is compatible with PB 8 is unable to meet your needs.