Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Connect from SQL Server to Oracle 9i using Oracle provider for OLE DB

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

From: Andrey <rdlis_at_one.lv>
Date: 13 Jun 2003 04:17:53 -0700
Message-ID: <1cdb5aae.0306130317.20dce8e@posting.google.com> 





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.
Received on Fri Jun 13 2003 - 06:17:53 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US