Home » SQL & PL/SQL » Client Tools » Connectivity tool (Oracle 10g)
Connectivity tool [message #621954] Wed, 20 August 2014 01:30 Go to next message
m.abdulhaq
Messages: 238
Registered: April 2013
Location: Ajman
Senior Member
I have tables created in access along with queries , i want to read this table info in oracle by connecting to access, is there a way to do that .Please let me know if i can set priviliges for running the queries alone .i want oracle to read the tables from access .
Re: Connectivity tool [message #621959 is a reply to message #621954] Wed, 20 August 2014 02:28 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
There couldn't be anything better than this tutorial which shows how to connect to MsAccess using SQL Developer.


[EDITED by LF: fixed URL tags]

[Updated on: Wed, 20 August 2014 03:38] by Moderator

Report message to a moderator

Re: Connectivity tool [message #621960 is a reply to message #621959] Wed, 20 August 2014 02:34 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I think the question is how to read an MS/Access table from an Oracle database session not from an Oracle tool.

Although the question is not clear: "i want oracle to read the tables from access", is this "I want to read MS/Access table from Oracle database (session)" or "I want to read Oracle tables from MS/Access"?

Edit; @OP, both ways are already been answered here (and in a single topic). I have not the time to search for it, do it and tell us the result.

[Updated on: Wed, 20 August 2014 02:35]

Report message to a moderator

Re: Connectivity tool [message #622174 is a reply to message #621960] Fri, 22 August 2014 02:46 Go to previous messageGo to next message
m.abdulhaq
Messages: 238
Registered: April 2013
Location: Ajman
Senior Member
I am sorry for not clearly specifying the requirements, it is first option michel, i want to read ms access tables from oracle.
Re: Connectivity tool [message #622175 is a reply to message #622174] Fri, 22 August 2014 02:50 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Read this wonderful Post: http://www.orafaq.com/forum/mv/msg/93840/286922/#msg_286922

Re: Connectivity tool [message #622180 is a reply to message #622175] Fri, 22 August 2014 05:10 Go to previous messageGo to next message
m.abdulhaq
Messages: 238
Registered: April 2013
Location: Ajman
Senior Member
thanks michel, i went thru the entire but one small query, is the entire changes on listner.ora are to be done on server where the oracle resides , i mean the home directory of server or client.and i dont understand this part , does he mean to make the change in init.ora.




STEP III:
Now we set up the HS init FILE: it's name is fixed (init<ODBCNAME>.ora). It contains only two lines of code:

$ORACLE_HOME/hs/admin/initOrafAccess.ora:
Code: [Select all] [Show/ hide]
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = OraFaccess
HS_FDS_TRACE_LEVEL = 0





its really wonderful to know and learn such great information.

[Updated on: Fri, 22 August 2014 05:11]

Report message to a moderator

Re: Connectivity tool [message #622186 is a reply to message #622180] Fri, 22 August 2014 07:16 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
No, it is to set the HS parameters in the init<ODBCNAME>.ora file.
Re: Connectivity tool [message #622191 is a reply to message #622186] Fri, 22 August 2014 07:37 Go to previous messageGo to next message
m.abdulhaq
Messages: 238
Registered: April 2013
Location: Ajman
Senior Member
Thanks lalit but what about listner settings is to be done on server,and do we need to create a seperate init file for ms access

[Updated on: Fri, 22 August 2014 07:38]

Report message to a moderator

Re: Connectivity tool [message #622202 is a reply to message #622191] Fri, 22 August 2014 08:41 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
m.abdulhaq wrote on Fri, 22 August 2014 18:07
but what about listner settings is to be done on server


That's step IV. Adding to sid list.

Quote:

and do we need to create a seperate init file for ms access


That's step III. Maaher has set up the init file for HS parameters.

Could you too post your steps, the way Maaher demonstrated. Just asking "what about this and that" doesn't make much sense.
Re: Connectivity tool [message #622221 is a reply to message #622180] Fri, 22 August 2014 10:40 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Listener.ora is a server file. It is never on the client.

Re: Connectivity tool [message #622229 is a reply to message #622221] Fri, 22 August 2014 14:13 Go to previous messageGo to next message
m.abdulhaq
Messages: 238
Registered: April 2013
Location: Ajman
Senior Member
Thanks lalit and michel.
Re: Connectivity tool [message #622230 is a reply to message #622229] Fri, 22 August 2014 14:17 Go to previous message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
So is your issue resolved? Could you finally connect to MSAccess the way you wanted to?
Previous Topic: EM Express--running queries
Next Topic: SQL*Plus on machine Oracle server is installed - TCP/IP or some sort of socket conection?
Goto Forum:
  


Current Time: Sat Jan 20 14:17:29 CST 2018

Total time taken to generate the page: 0.01310 seconds