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

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Wed, 18 Mar 2009 08:39:50 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A90399FD71_at_usahm208.amer.corp.eds.com>

Nigel's guess is my guess also. You probably need to quote the ACCESS table name. If the target was SQL Server you would also likely need to identify the database and owner in the query.  

The 1305 error could indicate you have an issue with the MDAC installed on the ACCESS machine.  

This is not an exact match for your issue but I also found this
"Microsoft has confirmed this to be a problem in ODBC Access ODBC Driver
version 2.00.2317." (Q124322)  

You should use ACCESS to open and process the target table to make sure the sample you choose is valid and then I would look at the version of the drivers you are using. I would try to make sure the drivers were the most current available.  

• Mark D Powell -- Phone (313) 592-5148

  ---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nigel Thomas

	Sent: Tuesday, March 17, 2009 6:24 PM
	To: Chris.Langston_at_aa.com; oracle-l
	Subject: Re: Cannot See Table in MS ACCESS Using Oracle HS and

Database Link                  

        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 Wed Mar 18 2009 - 07:39:50 CDT