RE: oracle linked serve error "OLE/DB provider returned an invalid schema definition" - issue status inquiry

Hi Malcolm,
From your description, I understand that:
You encountered the "OLE DB provider 'MSDASQL' returned an invalid schema
definition" error when you used Microsoft ODBC Driver for Oracle to connect
linked Oracle tables in your SQL Server queries.
You wanted to know if there was a patch released so that it could help you
resolve this open issue with MDAC / Microsoft ODBC Driver for Oracle.
If I have misunderstood, please let me know.

Unfortunately I also cannot find any internal document regarding the patch.
I am afraid that the hotfix is still unavailable now. However you can use
Oracle ODBC Driver which is developed by Oracle and can provide best
support to Oracle.
You can get it from:
Oracle ODBC Driver
http://www.oracle.com/technology/tech/windows/odbc/index.html
(Click the Software on the right panel to download it.)

If you are very concerned with Microsoft ODBC Driver for Oracle, I
recommend that you give Microsoft feedback via this link and your feedbacks
will be routed to SQL team so that this issue can be fixed in the next
release of MDAC:
http://connect.microsoft.com

If you have any other questions or concerns, please feel free to let me
know. It is my pleasure to be of assistance.

Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

.

Relevant Pages

  • RE: ORACLE DRIVER
    ... The thing is that I'm using in a Linux machine. ... So is there any free Oracle ODBC driver for Linux? ... UnixODBC is a freeware but couldn't find any free Oracle Drivers. ...
    (perl.dbi.users)
  • Re: CA-Realia, SqlState -91, Odbc preprocessor and Oracle database
    ... Using Microsoft Odbc Driver for Oracle, the buffer size was 64K ...
    (comp.lang.cobol)
  • RE: SQLFetch() very slow with Oracle
    ... Based on my understanding, the problem is when calling the SQLFetchto ... fetch the data from Oracle database, you found Microsoft's ODBC driver is ... so much slower than the Oracle driver to complete the above operation. ... ODBC driver and Oracle driver just as you mentioned. ...
    (microsoft.public.vc.database)
  • Oracle 10.2 ODBC driver: SQLDescribeCol returns too small a precision for numeric expressions
    ... I hope this is the correct newsgroup to ask about the Oracle ODBC driver ... I allocate a buffer of size Scale+Prec+2 bytes and call SQLBindCol ... the computed expression has up to 16 digits ...
    (comp.databases.oracle.server)
  • Re: Using a bookmark and applying a switch to it
    ... your suggested Macro works a treat! ... Unfortunately, I don't currently have an Oracle DBMS to test things with, ... Also worth exploring any options in the ODBC driver configuration. ... Selecting F9 does not show the Mergefield codings. ...
    (microsoft.public.word.mailmerge.fields)