Re: ODBC drivers

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.

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/ Received on Tue Dec 26 2000 - 16:47:44 CST