Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Linked server using msdaora. from SQL server to Oracle.
Thanks fot replying.
I have MDAC 2.7.1 on the box, the Oracle provider will end up with errors as well.
Any further thing I can do?
Thanks Dotan.
willjamu_at_mindspring.com (James Williams) wrote in message news:<3f5b5073.60006502_at_news.east.earthlink.net>...
> 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 Mon Sep 08 2003 - 06:50:32 CDT