Re: Linked server using msdaora. from SQL server to Oracle.

On 6 Sep 2003 10:33:00 -0700, dotan.shdema_at_intel.com (Dotan S.) wrote:

I would see if MS has an updated provider or try the Oracle supplied OLEDB provider.

Then use the MS/SQL sp_addlinkedserver (what a name) to create the linked server and test.

>Hi,
>Need some help on a weird problem.
>I have a linked server from SQL server
>to oracle DB (8i) using MSDAORA.
>the server is SQL 2K SP3 (I've seen the same issue with SP2 as well).
>When trying to run a simple query like
>select MAX(WW) from table_name (WW defined as NUMBER in oracle.)
>
>I get error
>Could not fetch a row from OLE DB provider 'MSDAORA'.
>[OLE/DB provider returned message: ORA-01426: numeric overflow
>]
>OLE DB error trace [OLE/DB Provider 'MSDAORA' IRowset::GetNextRows
>returned 0x80040e57].
>
>If I will run the same query without the MAX clause I will get the data from Oracle.
>any idea?
>
>Thanks Dotan.
Received on Sun Sep 07 2003 - 10:38:44 CDT