Hello
I'm migrating a PB2017 application to support datatype from CHAR to NCHAR and I have problems using SNC connection migrating from  PB 6.5 and Native MS SQL driver.

This is the connection string:

SQLCA.DBMS = "SNC SQL Native Client(OLE DB)"
SQLCA.LogPass = "XXXXXXXX"
SQLCA.ServerName = "TECNINFO2\TECNINFO2"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='SEG001AUGNCHAR',Provider='SQLNCLI10',OJSyntax='PB',DisableBind=0,NcharBind=1,TrimSpaces=1"

Datawindows with multiple row update does not work and bring me back tis error for DELETE:

Microsoft SQL Server Native Client 10.0
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

No changes made to database.

DELETE FROM pianistudiostudente WHERE matricol = ? AND universi = ? AND facolta = ? AND corsolau = ? AND annocors = ? AND corsi = ?

For INSERT I have the same error:

Microsoft SQL Server Native Client 10.0
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

No changes made to database.

INSERT INTO pianistudiostudente ( matricol, universi, facolta, corsolau, annocors, corsi, grupinsi, crediti, dispensato, semestre ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

The other strange thing is that for insert if I add 3 rows 1 of them is inserted and the other 2 no. Than I get the error.

For DELETE is the same thing.

If I add or delete on row at time eveything works. With PB 6.5 and Native MS SQL driver I have no problem.

Thanks in advance.