Re: LONG RAW and ODBC

From: Philippe CASTELLA <philippe.castella_at_free.fr>
Date: Mon, 22 Dec 2003 08:45:07 +0100
Message-ID: <bs675i$6n4$1@s1.read.news.oleane.net>

"Justin Cave" <jocave_at_yahoo.com> a écrit dans le message de news: 233b7a65.0312191232.6d29b91f_at_posting.google.com...

> "Philippe CASTELLA" <philippe.castella_at_free.fr> wrote in message
news:<bru9l6$m09$1_at_s1.read.news.oleane.net>...

> > "Justin Cave" <jocave_at_yahoo.com> a écrit dans le message de news:
> > 233b7a65.0312181620.7934b6fa_at_posting.google.com...
> > > "Philippe CASTELLA" <philippe.castella_at_free.fr> wrote in message
> > news:<brsdo8$1no$1_at_s1.read.news.oleane.net>...
> > > >
> > > > Do someone know how to configure Oracle ODBC client in order to read
> > LONG
> > > > RAW data fields from a database
> > >
> > > Have you ensured that you've checked the "Force Retrieval of Longs"
> > > option in the DSN configuration?
> > >
> > No I have not but it is the problem... where can I check this parameter.
> > With Oracle ODBC Driver I use (8.0.5) this parameter does not exist and
I
> > haven't found how to activate this functionality yet. I found this
option on
> > a PC with an oracle 8.1.7 ODBC driver... does that mean I can't retrieve
> > long raw objects if I have an ODBC layer < 8.1 ?

>
> What is the full version of the Oracle ODBC driver you're using (i.e.
> 8.0.5.x)?  It's been a while since I've used a client that old, but
> I'd wager that you need  an updated version of the 8.0.5 Oracle ODBC
> driver.  The 8.0.5.10 driver is still available for download on OTN.

It's an old version : 8.0.5.0 (the one delivered with the Original Oracle 8.0.5 database CDs)... I will try to download the 8.0.5.10 and test it. My main problem is that I have customers wich use ODBC from 1.15 / 1.16 (Oracle 7.3.2) to ODBC 9i Release 2 (and SQL Server 7 and 2000). So I think I will be forced to limit the use of document storage in the database...

I tried with an Oracle 8.1.7 ODBC drvier and it works very well.

It's a pity that there was such a limitation in old ODBC drivers...

Thanks a lot for your help.

Philippe CASTELLA Received on Mon Dec 22 2003 - 01:45:07 CST