Sample Header Ad - 728x90

Linked Server Between SQL Server and iSeries is rounding decimals

1 vote
2 answers
6057 views
We just set up a new SQL Server 2008 database, and I got the link set up between our server and an iSeries As400 server that we get some of our data from. The problem I'm having is that it is rounding down any floating numbers, which is a pain because we're working with dollar amounts a lot of the time. select * FROM openquery(NADS, 'select CMD, 1.23 Type from CREDD') On our older server this returns the CMD column, and a column called Type with 1.23 all the way down. On the new server type is just 1.00 So far as I can tell, the link part is set up the same. The IBM i Access for Windows ODBC Setup is mostly the same, but there are some differences between versions that I'm not sure about. Edit: In case it matters, For the provider I'm using Microsoft OLE DB Provider for ODBC Drivers Edit2: provider options are the same provider options are the same Linked Server properties: enter image description here iSeries Access for windows ODBC setup appears to be the same enter image description here enter image description here enter image description here enter image description here enter image description here enter image description here enter image description here enter image description here
Asked by AndyD273 (215 rep)
Nov 13, 2013, 08:44 PM
Last activity: Jan 12, 2022, 04:17 AM