Re: CLOB has me wishing for a new MDAC release
- From: "Ralph" <nt_consulting64@xxxxxxxxx>
- Date: Wed, 30 Jan 2008 22:01:24 -0600
<fostermark@xxxxxxxxx> wrote in message
news:41a332ea-0bf8-4cba-b03d-f83450a951b9@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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...
Unsatisfactory reply follows.
I would work on trying to help them discover why they can't use the Oracle
supplied OLE DB providers with Crystal Reports. Until then you can cobble
the CLOBs to Longs - but I think you're going to have 'trouble' of some kind
any way. That provider is just plain out of date.
If you have a thick wallet you might investigate DataDirect providers. They
are very robust and come with good support.
http://www.datadirect.com/products/ado/index.ssp
-ralph
.
- References:
- CLOB has me wishing for a new MDAC release
- From: fostermark
- CLOB has me wishing for a new MDAC release
- Prev by Date: CLOB has me wishing for a new MDAC release
- Next by Date: Re: Programmatically create Access 2007 database
- Previous by thread: CLOB has me wishing for a new MDAC release
- Next by thread: Re: Programmatically create Access 2007 database
- Index(es):
Relevant Pages
|
