All you have to do is to change the ntwdblib.dll compatible to the operating system that you are running. If it is 64 bit, change or add ntwdblib.dll in syswow64

Thanks guys i will give these a shot!!

Really appreciate the help

I had the same problem. I have it working now. I am connecting with "OLE Microsoft OLE DB" My connection string in the code is: pt_sqlca.dbparm = "PROVIDER='SQLOLEDB',DATASOURCE='" + pt_sqlca.Servername + "',PROVIDERSTRING='DATABASE="+pt_sqlca.Database+ "',PBTrimCharColumns='Yes'" connect using pt_sqlca;

Hi David;

  That would be expected as the old PB "MSS" interface from the Sybase days is no longer supported or supplied with newer versions of PowerBuilder 10.5 and higher. Instead, you will have to change your Transaction Object, as follows:

// Old - remove

• SQLCA.DBMS = "MSS" 

// Use instead ...

• SQLCA.DBMS = "SNC"              // - OR -
• SQLCA.DBMS = "ODBC"           // - OR -
• SQLCA.DBMS = "OLE-DB"        // - OR -
• SQLCA.DBMS = "ADO.NET"      // - OR -
• SQLCA.DBMS = "JDBC" 

As Marco commented earlier - the equivalent of MSS is now SNC. Here is an example of my SS2017 connection code ...

// Profile SS 2017
SQLCA.DBMS = "SNC"
SQLCA.LogPass = <**********>
SQLCA.ServerName = "SS2017"
SQLCA.LogId = "Chris"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='Chris',Provider='SQLNCLI11',AppName='PB2017',Host='STD-CHRIS',TimeOut=5,TrustedConnection=1,TrimSpaces=1"

 

HTH

Regards ... Chris

 

Hi David,

PB 2017 uses the SQL Native Client (SNC).

Cheers,

Marco