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

I've been trying to get a response to your suggestion replied back to you and the list for the last two days but for whatever reason, it isn't going thru. Just to let you know I did get it resolved but I'm not exactly sure what it was since I tried several solutions at once and undoing each didn't recreate the issue (a reboot of my PC was one of those). The Oracle driver did not resolve the issue and in fact, I'm using the same MS ACCESS driver. I wish I knew exactly what the issue was so I could post the resolution.

I just wanted to say thank you for your feedback and suggestion. I hope this email finds you.

Regards,
Chris Langston

-----Original Message-----
From: alanbort_at_gmail.com [mailto:alanbort_at_gmail.com] On Behalf Of Guillermo Alan Bort Sent: Tuesday, March 17, 2009 8:32 PM
To: nigel.cl.thomas_at_googlemail.com
Cc: Langston, Chris; oracle-l
Subject: Re: Cannot See Table in MS ACCESS Using Oracle HS and Database Link

[Generic Connectivity Using ODBC][Microsoft][ODBC Microsoft Access Driver]

Have you tried using Oracle's driver? you can install it with the rdbms or client (I think instanc client is sufficient).

hdh
Alan Bort
Oracle Certified Professional

On Tue, Mar 17, 2009 at 7:24 PM, Nigel Thomas <nigel.cl.thomas_at_googlemail.com> wrote:
> 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.
>
>

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