Odbc error microsoft odbc sql server driver fractional truncation

However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information. Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose.

The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.

All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic. Data Management. Tags: Informatica. Peter Dickinson February 6, 0 Comments. Harish Malik Posted February 6, 0 Comments. I also downloaded a backup to my development machine, and it was fine there too.

And since I had just changed the datemodified field from smalldatetime to datetime over the weekend, it seemed like too much of a coincidence that this error had nothing to do with that, especially since I've never seen this error before in all the years that we've had this configuration about 7 years. So there definitely seemed to be a correlation. Thanks for your assistance!

This discussion thread is closed Start new discussion. TextStream Line Truncation. DB2 Database. Child form screen truncation. Need to remove the integer part and keep the fractional part of a double or decimal. Visual Basic. Drop fractional part of a number? DB2 Net Search Extender truncation.

Microsoft SQL Server. We're investgating further so I don't want to commit to how we will resolve this problem until we have a complete understanding, but it looks like a good candidate for SP2.

Other values in the range At first glance this seems like it is related to the other post. Changing to ODBC v3 may have other impacts on your app of course SQLStates are different, for example , so you need to do a lot of testing before deploying an app that you're just flipped from v2 the default to v3.

For this you'd change 16,0 to 19,0 or 23,3. If neither of these work please send me your source code and I'll dig deeper.