MOney conversion not working

More
2 years 9 months ago #12676 by davies
Driver - Ver 1.4.0.3264 , SQL server - 2014 (11.0.2100 ) , Postgresql - 9.2.7

We seem to have an issue accessing money data types across a linked server.

To reproduce on Postgres

create table neil1 (yy money )
insert into neil1 values (12.99)
select * from neil1

On sqlserver

select * from dcsrpt01ny.intelligence_100$1.[public].neil1
It returns one row with the value 0.0

Connection String options are @provstr=N'SQLSERVER=2010;PORT=5432;CNV_SPECIAL_FLTVAL=ON;'

Please Log in or Create an account to join the conversation.

More
2 years 9 months ago #12709 by Moderator
The fix is available in build 1.4.0.3308. Please contact Support in order to obtain fixed module before the official release.

Please Log in or Create an account to join the conversation.

Time to create page: 0.124 seconds
Powered by Kunena Forum