Heterogeneous Services: Problem with SELECTing numeric values from MS SQL Server

Home -> Community -> Usenet -> c.d.o.server -> Heterogeneous Services: Problem with SELECTing numeric values from MS SQL Server

From: Jaroslaw Maksimowicz [2i] <jarmak_at_2i.pl>
Date: Tue, 19 Mar 2002 11:30:05 +0100
Message-ID: <a773un$oln$1@news.tpi.pl>

Hello,

I have a problem with SELECT numeric type data from SQL Server 2000 using Heterogeneous Services.

In SQL Server, in table I have a numeric value i.e. 100.23, and oracle return 100 :-( instead 100.24.

The request via ODBC returns correct value with comma as separator. I read, that HS uses ODBC to connect non-Oracle DB, so I think taht there is something wrong with type conversion between Gateway and ODBC.

On page
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/ a76960/datatype.htm#5707
I found that SQL_NUMERIC(p,s) (ODBC) is mapped to NUMBER(p,s) (Oracle)... but it doesn't work :(.

Maybe problem is that, Oracle Transparent Gateway 8.1.7 isn't certified with MS SQL Server 2000.

Jarek
jarmak_at_2i.pl Received on Tue Mar 19 2002 - 04:30:05 CST