BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

MS SQLServer Error with datetime


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
CLS69
Principal Member
Principal Member



Joined: 11 Jun 2009

Posts: 215
Location: Italy


flag
PostPosted: Wed Jul 10, 2019 12:22 pm 
Post subject: MS SQLServer Error with datetime

Environment: DS 4.2 SP12; MS SQL Server 2016 (both on Windows server 2016)

I'm trying to write a datetime field into a MS SQL Server 2016 table, whose column is declared as DATETIME2.
Whenever I have a date Beyond June 6th 2079 it bounces me the following error:

<SQLExecute>: <[Microsoft][ODBC SQL Server Driver]Fractional truncation Datetime field overflow>.

Indeed this is quite strange! As June 6th 2079 is the upper limit for SMALLDATETIME type (DATETIME2 goeas as far as December 31st 9999).

I spent all the day trying to work out where and how to understand how to get rid of this, but all I found is that there is a default parameter that is taken at SQLExecute time ("0" instead of the expected "7"), but I did not find a way to put it in place.
Did any of you run into this before, and found how to go through?

Thank you in advance
Claudio

_________________
When you are right, there is no need to yell. When you are not right, there is no reason to yell.
Back to top
CLS69
Principal Member
Principal Member



Joined: 11 Jun 2009

Posts: 215
Location: Italy


flag
PostPosted: Tue Jul 16, 2019 2:10 am 
Post subject: Re: MS SQLServer Error with datetime

Solved

It occurs if you only have default ODBC driver installed.
Install SQL Server Native Client 11.0 (or version you comply with) and everything start working like a charm.

_________________
When you are right, there is no need to yell. When you are not right, there is no reason to yell.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0274 seconds using 18 queries. (SQL 0.0028 Parse 0.0008 Other 0.0238)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo