CLOB has me wishing for a new MDAC release

If I've done my Googling correctly, the Microsoft OLE DB driver
included in MDAC 2.8 was developed against Oracle 7.1. This means
that anything specific to the last 3 major versions of Oracle is not
supported by MSDAORA. Therefore, while Oralce has deprecated the Long
and Long Raw datatypes, I am forced to alter the CLOB columns in our
9i database to Long if I want to use MSDAORA.

One of my hands is tied by the fact that I'm using Crystal Reports to
read from the column in question. This means I can't write any
chunking code into my data access layer. The other is tied by the
fact that OraOLEDB.Oracle doesn't seem to work on the client's
server. They claim to have the appropriate Oracle client tools
installed, but the reports throw errors if any provider other than
MSDAORA is specified at design time.

So, what kind of trouble am I gong to encounter down the road if I
alter these CLOBs to Longs? Do I have any other alternatives?

Thanks much...
.

Relevant Pages

  • Re: ADO.NET and ODBC { CALL ..... } Syntax
    ... > Coonecting to Oracle 8i DB running on Unix ... > OleDB connection with provider as MSDAORA. ... > the same way as it works in ADO arena. ... You should really only do this at design-time, or with a command you will ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: linkserver error
    ... Distributed Queries Return Error 7356 with MSDAORA ... >I created a job that uses a linkserver to Oracle db for the past year. ... >OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. ...
    (microsoft.public.sqlserver.programming)
  • Error in distributed transaction with Oracle
    ... The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction. ... but the stored procedure (whitch access Oracle) even can't be saved SOMETIMES into the SQL database from Enterprise manager after edit. ...
    (microsoft.public.sqlserver.programming)
  • Oracle 9i Client/MSDAORA Problem
    ... I am using the MSDAORA OLE DB provider to connect to Oracle from ... Install 9i client ... We can connect to Oracle just fine (if we follow the procedure ... Uninstall 9i client ...
    (comp.databases.oracle.server)
  • Re: Crystal Reports and Oracle Stored Procedure Insert statments
    ... I'm using Oracle 9i, Crystal Reports 10, ODBC connection. ... My sub1 returns less rows than sub2, but is a more complicated query. ...
    (comp.databases.oracle.server)