RE: Access Oracle 10g using Oracle OLE DB provider
- From: "Anton Klimov [MS]" <aklimov@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 21 Jun 2005 13:49:03 -0700
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.
"LittleBee" wrote:
> 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.
.
- References:
- Access Oracle 10g using Oracle OLE DB provider
- From: LittleBee
- Access Oracle 10g using Oracle OLE DB provider
- Prev by Date: RE: Required extended properties for ODBC Sources.
- Next by Date: RE: CDynamicAccessor::GetColumnInfo error
- Previous by thread: Access Oracle 10g using Oracle OLE DB provider
- Next by thread: RE: Access Oracle 10g using Oracle OLE DB provider
- Index(es):
Relevant Pages
|
