Re: ODBC drivers

In article <92b76f$3fv$1_at_nnrp1.deja.com>,   p_forman_at_my-deja.com wrote:
> Do you happen to know what version of Oracle driver you use. Like I
> previously mentioned, when we use the ODBC from Oracle here, we have
> trouble with Long in MS Access.

I'd generally recommend using the latest driver for you Oracle client (i.e. 8.1.6.2 if you have an 8.1.6 client installed, 8.1.5.7 if you have an 8.1.5 client). You can grab the latest ODBC drivers from the Oracle Technology Network (OTN)
<http://otn.oracle.com/software/utilities/software_index.htm>

>
> In article <91uh68$c1t$1_at_nnrp1.deja.com>,
> jocave_at_my-deja.com wrote:
> > In article <91tgv9$gt0$1_at_nnrp1.deja.com>,
> > pforman_at_edmunds.com wrote:
> > > What's the recommended ODBC driver to use with something like
 Access
> > > and Oracle.
> > >
> > > Someone mentioned to me that we had a problem if the Oracle ODBC
 driver
> > > was used and we tried to view a table in Access that had a long
> > > column. If the MS ODBC driver was used, we couldn't view a table
 if
 it
> > > had a CLOB column.
> >
> > You shouldn't have any problem using the Oracle driver to retrieve
 LONG
> > or [C/B]LOB columns. The Microsoft ODBC driver doesn't support
 either
> > of these types.
> >
> > There may be problems in the Access front-end that will prevent you
> > from displaying the contents of some of these columns. Access, for
> > instance, tends to dislike binary data, so BLOB's won't display
> > particularly well.
> >
> > Justin Cave
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 02 2001 - 10:33:57 CST