Connectivity tool [message #621954] |
Wed, 20 August 2014 01:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/c70e51380f6e8af6765f6e8fede51587?s=64&d=mm&r=g) |
m.abdulhaq
Messages: 254 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 #621960 is a reply to message #621959] |
Wed, 20 August 2014 02:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68647 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 #622180 is a reply to message #622175] |
Fri, 22 August 2014 05:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/c70e51380f6e8af6765f6e8fede51587?s=64&d=mm&r=g) |
m.abdulhaq
Messages: 254 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 #622202 is a reply to message #622191] |
Fri, 22 August 2014 08:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
m.abdulhaq wrote on Fri, 22 August 2014 18:07but 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.
|
|
|
|
|
|