Re: ACCESS/ORACLE/ODBC HELP!!

There is a bug somewhere in there that limits the length of attached table names to less than the 30 character Oracle limit, if your object names are near that limit then JET won't let you attach them! This seems to be a new 'feature' introduced in the Oracle 8 drivers, I have never had the problem with the 7x drivers, either 16 or 32 bit.

Just SYNONYM your tables to a nice short name and they should attach OK.

Keith L

ME <74577.1525_at_CompuServe.COM> wrote in message ...
>Oracle 8.0.3.0, Access 97 and Oracle ODBC that came with the Oracle8
>client software. Sql*net works fine.
>Here is the problem. I start ACCESS 97 and attempt to attach an Oracle
>table. Oracle will allow me to attach the system tables and the tables
>from the scott database. If, however, I create a new user, and that
>user creates tables in the database, I can not attach to those tables.
>I can SEE the tables in the popup box that asks me to select the table,
>but then I get a jet error that says that the MS jet engine cant find
>the table. I can select * from the tables from the Oracle ODBC test
>utility.
Received on Fri Jan 30 1998 - 00:00:00 CST