Re: MDAC and Oracle9
From: Sid Eaton (sid.eaton_at_cusys.edu)
Date: 04/09/04
- Next message: Connie: "Operators"
- Previous message: Geoff N. Hiten: "Re: SQL Server Assertion"
- Next in thread: Niall Litchfield: "Re: MDAC and Oracle9"
- Maybe reply: Niall Litchfield: "Re: MDAC and Oracle9"
- Messages sorted by: [ date ] [ thread ]
Date: 9 Apr 2004 12:45:37 -0700
We are having, apparently, the same problem here. Also with Oracle
9.2.0.4.0.
We have tried Oracle's native driver, the MS OLE DB driver for Oracle
and the MS OLE DB Driver for ODBC Drivers using either the Microsoft
or Oracle ODBC drivers. We have had some success retriving data with
a linked server connection using Microsoft OLE DB Provider for ODBC
Drivers using Microsoft ODBC for Oracle {version 2.573.9030.00}. [Not
sure what MDAC provided this]
All other methods fail with error messages like:
Server: Msg 7356, Level 16, State 1, Line 2
OLE DB provider 'OraOLEDB.Oracle' supplied inconsistent metadata for a
column. Metadata information was changed at execution time.
OLE DB error trace [Non-interface error: Column 'MIN_EXTENTS'
(compile-time ordinal 12) of object '"SYS"."ALL_TABLES"' was reported
to have a DBTYPE of 130 at compile time and 5 at run time].
or
Server: Msg 7318, Level 16, State 1, Line 2
OLE DB provider 'MSDASQL' returned an invalid column definition.
OLE DB error trace [Non-interface error: OLE/DB provider returned an
invalid column definition.].
We are getting error messages like this from W2K Server SQL Server
2000 machines whether the Oracle 8i or 9i drivers are installed if the
linked target is Oracle 9.2.0.4.0.
We suspect that SQL Server 2000 is using old methods to communicate
with Oracle that are not appropriate for Oracle 9.2.0.4.0 and perhaps
other releases around that version. Since Oracle is working fine and
connections to it to retrieve data using a Windows script file are
successful [using ODBC and UDL files], my current suspicion is that a
patch will be required for MS SQL Server 2000 to work with more recent
versions of Oracle.
Anyone else having this experience or perhaps information on a fix for
this problem?
- Next message: Connie: "Operators"
- Previous message: Geoff N. Hiten: "Re: SQL Server Assertion"
- Next in thread: Niall Litchfield: "Re: MDAC and Oracle9"
- Maybe reply: Niall Litchfield: "Re: MDAC and Oracle9"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
