Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Link to Oracle only returns one row
126 views
Skip to first unread message
systemtek
Jul 15, 2010, 10:06:56 AM7/15/10
to
Hi,
We have a SQL server 2008 link to oracle 11g via ODBC and linked
server setting in SQL.
When we query the oracle db we only get one row returned when we
should get many more.
This works on another server with SQL2005 and a older version of
Oracle client.
Any Ideas ?
Thanks
dubravk...@gmail.com
May 10, 2013, 4:54:32 AM5/10/13
to
Set Numeric Settings parameter to US numeric in Oracle ODBC driver settings. From ODBC help:
Numeric Settings - ......
Microsoft default regional settings (to provide a way to mirror the Oracle OLE DB driver’s behavior for greater interoperability), or US numeric settings (which are necessary when using MS Access or DAO (Database Access Objects) in non-US environments).
Numeric Settings - ......
Microsoft default regional settings (to provide a way to mirror the Oracle OLE DB driver’s behavior for greater interoperability), or US numeric settings (which are necessary when using MS Access or DAO (Database Access Objects) in non-US environments).
0 new messages