Re: Cannot See Table in MS ACCESS Using Oracle HS and Database Link

From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com>
Date: Tue, 17 Mar 2009 22:24:03 +0000
Message-ID: <53258cd50903171524k6c7f34b7gd14f8af410304899_at_mail.gmail.com>



Chris

<guess>
Is there any danger that the table name is case sensitive; have you tried selecting from "some_table"_at_MS_ACCESS_DB (or "Some_Table", or "SOME_Table", etc etc - I calculate only 512 possible combinations for you to try) </guess>

Regards Nigel

2009/3/17 Langston, Chris <Chris.Langston_at_aa.com>

>
>
>
> SQL> select count(*) from some_table_at_MS_ACCESS_DB;
>
> select count(*) from some_table_at_MS_ACCESS_DB
>
> *
>
> ERROR at line 1:
>
> ORA-00942: table or view does not exist
>
> [Generic Connectivity Using ODBC][Microsoft][ODBC Microsoft Access Driver]
> The
>
> Microsoft Jet database engine cannot find the input table or query
> 'SOME_TABLE'.
>
> Make sure it exists and that its name is spelled correctly. (SQL State:
> S0002;
>
> SQL Code: -1305)
>

> ORA-02063: preceding 2 lines from MS_ACCESS_DB
>
>
>
>
>
> I’ve searched then Net, OTN and Metalink and have found lots of good
> information on Oracle and Access but nothing so far that addresses this
> specifically. One article mentioned using MS ACCESS to export/import the
> database into a newly created database to remove the security settings, but
> as stated in the constraint, I do not have MS ACCESS installed and neither
> does anyone else around me.
>
>
>
> Any insight or link to some documentation would be most appreciated. It’s
> nearly 5:00 PM now (quittin’ time) and I’m heading out of the office for the
> day so an immediate answer is not required. I’ll check back first thing
> tomorrow morning (3/18).
>
>
>
>
>
> Chris Langston
>
>
>
> ------------------------------
> NOTICE: This email and any attachments are for the exclusive and
> confidential use of the intended recipient(s). If you are not an intended
> recipient, please do not read, distribute, or take action in reliance upon
> this message. If you have received this in error, please notify me
> immediately by return email and promptly delete this message and its
> attachments from your computer system.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 17 2009 - 17:24:03 CDT

Original text of this message