Re: Connect from SQL Server to Oracle 9i using Oracle provider for OLE DB

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Fri, 13 Jun 2003 08:53:03 -0700
Message-ID: <3EE9F35F.94ACC5CF@exxesolutions.com>

Andrey wrote:

> Hi all,
>
> I have installed Oracle 9i client and created linked server, but when
> I try to select data, select fails with error message "OLE DB provider
> 'OraOLEDB.Oracle' returned an invalid schema definition".
>
> I have tried the same with Oracle 8i and it worked fine, but now we
> have moved to Oracle 9i server.
>
> The reason for choosing Oracle provider is that I have to manipulate
> with BLOB data.
>
> Can anyone help me please?
>
> Thanks
> Andrey.

I can't say for sure but I'd suspect SQL Server is not ready for BLOBs.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Fri Jun 13 2003 - 10:53:03 CDT