Re: MSAccess97(NT4SP3)-->ODBC-->Oracle7(Unix) Problem

Try checking the ownership of the exported table - it may have been created it a different schema.

Jim Garrison <jhg_at_austx.tandem.com> wrote:

>I have just installed the current version of Personal
>Oracle on my NT workstation, and successfully set up
>an ODBC connection to an Oracle7 database running
>on Unix (Solaris). The connection works, and I can
>link from Access to tables on the Oracle DB with no
>problem.
>
>Then I "exported" an Access table to Oracle
>(File:SaveAs/Export:External Database:ODBC). The
>export was successful, and I was then able to link
>from Access to the newly created Oracle table, and
>am able to view and manipulate the Oracle rows from
>within Access.
>
>However, on the Oracle side all is not well. When
>examining the Oracle database with SQLPLUS on the
>Unix system, the following behavior is observed:
>
>1) The table "exists" in that it is defined in the
> system catalog tables (USER_TABLES) and its
> columns are defined, with the proper attributes
> (in USER_TAB_COLUMNS).
>
>2) Any attempt to manipulate the table with DML
> (SELECT ...) or DDL (DROP TABLE ...) statements
> in SQLPLUS result in:
>
> ORA-00942: table or view does not exist
>
>3) I get exactly the same results when manipulating
> the table using the "Personal Oracle7 Navigator"
> tool on the NT Workstation. I.e., the table seems
> to exist in that it appears in the browser display,
> but I cannot access its rows and cannot delete it.
> The error code is identical (ORA-00942).
>
>In summary:
>
> 1) A table is exported from Access to Oracle7
> via ODBC.
> 2) The newly created Oracle table is then
> linked to from Access, and behaves normally.
> 3) The newly created Oracle table appears in
> Oracle's system catalog, but any attempt to
> refer to it results in ORA-00942.
>
>Suggestions?
>
>System Config:
> AST Pentium 90
> 72MB memory
> >400MB free disk space
> Windows NT4 SP3
> MS Office97 PRO with Service Release 1
>
>Personal Oracle:
> Personal Oracle 7.2.2.4.0
> Required Support Files 7.2.2.4.1C
> SQL*Net Client 2.2.2.1.0A
> SQL*Net Server 2.2.2.1.0A
> SQL*Plus 3.2.2.0.1
> Oracle TCP/IP Adapter 2.2.2.1.0
> Oracle7 ODBC Driver 1.13.5.0.4
> Oracle Call Interface 7.2.2.3.1
>
>Unix Oracle Version: 7.3.3.0.0
>
>--
>James Garrison mailto:jhg_at_austx.tandem.com
>Tandem Computers, Inc
>14231 Tandem Blvd, Rm 1038 Phone: (512) 432-8455
>Austin, TX 78728-6699 Fax: (512) 432-8247
Received on Tue Nov 04 1997 - 00:00:00 CET