• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • PB 2019 R3 Datawindow Insert getting SQLSTATE 22007 error

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved PB 2019 R3 Datawindow Insert getting SQLSTATE 22007 error

  1. Issue
0
Votes
Undo
  1. Paul Aspland
    Paul Aspland
  2. PowerBuilder
  3. Monday, 19 April 2021 09:13 AM UTC

Upgraded to 2019 R3 and made the recommended change to MSOLEDBSQL setting, downloaded the latest driver from Microsoft and now getting:

SQLSTATE = 22007
Microsoft OLE DB Driver for SQL Server
The fractional part of the provided time value overflows the scale of the corresponding SQL Server parameter or column. Increase bScale in DBPARAMBINDINFO or column scale to correct this error.

When I use a stored procedure insert from a datawindow.

Is there a solution for this ?.

 

 

program does not work after a long break
请问下，我访问json接口，用下面例子程序，怎么没数据？
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 19 April 2021 15:26 PM UTC
  2. PowerBuilder
  3. # 1

Hi Paul;

  Seems like a Date/Time issue. What regional settings are you using and also, are you always sending the dates in "CCYY-MM-DD" format over to SS?

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.