Hello

My powerbuilder version is 2022 b1900
Database MSSQL server 15.0.2000

I use French date format dd/mm/yyyy on my db
Using MSOLEDBSQL19 generate an error the date transmitted to the DB is yyyy-mm-dd mm:ss:ms.000
An error occurs as the DB can't convert the varchar into date the format should be normally dd-mm-yyyy mm:ss:ms.000.

No error is send back by PB , i viewed this in by testing SQLstatement capture in the MSSQL Profiler.

I use this as DBPARM

this.DefaultDBParm = "PROVIDER='"+DEFAULT_DBPROVIDER+"',PBTrimCharColumns='Yes',DelimitIdentifier='No',disablebind = 1,staticbind = 0,AutoTranslate='yes',DateFormat=''\''dd-mm-yyyy\'''',DateTimeFormat=''\''dd-mm-yyyy hh:mm:ss.fff\'''',TimeFormat=''\'hh:mm:ss.fff\'''',DATASOURCE='"+this.ServerName+"',PROVIDERSTRING='Database="+this.database+"',AppName='NLS v"+sVersion+"',Host='NLS'"

When i use SQLNCLI11 all works correctly.

SQLstatement without date in parameter works fine with MSOLEDBSQL19

I tried also to add this in the parameter

ProviderString='Language=French'

but changed nothing

Is it a bug or wrong configuration ?

Best Regards

Yann