Access Oracle 10g using Oracle OLE DB provider

[LittleBee]

Hi,

I have the following installed in my MS Server.
a) Oracle10g Provider for OLE DB Version 10.1.0.4.0
b) SQL Server 2000 SP 4
c) Oracle Client 10.1.0.2

I am able to create the linked server using Oracle OLE DB Provider and
display the tables. However, when execute query, this error is encountered :
Server: Msg 7320, Level 16, State 2, Line 1
Could not execute query against OLE DB provider 'OraOLEDB.Oracle'.
OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle' ICommandText::Execute
returned 0x80040155].

Read from
http://www.windowsitpro.com/Articles/Index.cfm?ArticleID=22264&pg=2 that we
need to add key to the SQL Server's registry. As we can only find
mtxoci81x_win2k.reg in C:\Program Files\Common Files\System Files\OLE DB, we
modified it for Oracle 10g and register it.

But still the same error.

Is there anything I missed out ? or my key register is wrong ? can someone
provide the correct mtxoci.....reg file ? how should I proceed from here ?

Thanks in advance.

[Anton Klimov [MS]]

mtxoci reg files are the files for the Microsoft provider MSDAORA. Since you
use Oracle's provider ORAOLEDB you should look at what is wrong with its
configuration.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

[Anton Klimov [MS]]

Additional info, it originally mentions 2005, but I think it is true for SQL
server 2000 also:

Oracle 10g R1 has a bug which doesn’t let the SQL Server 2005 Linked server
work with Oracle DB using OLEDB by default, i.e. out of proc. However, in
proc works fine – for in-proc add a registry under providers in SQL server
registry hive and make in proc bit to 1 (bounce SQL server service). BTW –
this bug is fixed in 10g R2 (as per Oracle support site) and may be back
ported in 10g R1.

--
This posting is provided "AS IS" with no warranties, and confers no rights.