1. yann dulondel
  2. PowerBuilder
  3. Wednesday, 21 June 2023 12:50 PM UTC

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

 

 

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 21 June 2023 14:53 PM UTC
  2. PowerBuilder
  3. # 1

Hi Yann;

  Please open a support ticket for this issue ... https://www.appeon.com/standardsupport/search

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.