| Connecting Oracle to Remote Access Server [message #496813] |
Wed, 02 March 2011 09:32  |
infinitenumbers
Messages: 33
Registered: November 2010
|
Member |
|
|
Hi Guys,
Is it possible to connect Oracle to MS Access database sitting on remote server? I need to join the tables in Oracle and MS Access.
It would be really great if somebody could provide the steps to follow.
Thank you very much!
|
|
|
|
|
|
| Re: Connecting Oracle to Remote Access Server [message #496838 is a reply to message #496814] |
Wed, 02 March 2011 12:57  |
Solomon Yakobson
Messages: 3303
Registered: January 2010
Location: Connecticut, USA
|
Senior Member |
|
|
Roachcoach wrote on Wed, 02 March 2011 10:35Don't think you can do it the other way around though, maybe, but I've not heard of it.
It is called HS. All you need is:
1. Create ODBC DSN
2. Add SID entry (with program = hsodbc) to listener
3. Add entry to tnsnames (with hs = ok)
4. Create initSID.ora in hs\admin directory under Oracle home.
SY.
[Updated on: Wed, 02 March 2011 12:57] Report message to a moderator |
|
|
|
| Re: Connecting Oracle to Remote Access Server [message #496844 is a reply to message #496838] |
Wed, 02 March 2011 13:37 |
infinitenumbers
Messages: 33
Registered: November 2010
|
Member |
|
|
Thanks for the reply Roachcoach and syakobson.
But the HS method is to connect Oracle to any ODBC compliant database (MS Access, SQL Server etc.) on the
LOCAL SERVER
But my ACCESS database is in the REMOTE SERVER.. Does it work with the method mentioned above????? Please help me with this.
|
|
|
|
| Re: Connecting Oracle to Remote Access Server [message #496859 is a reply to message #496844] |
Wed, 02 March 2011 15:00 |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
I wouldn't to it, personally.
That's like putting the tire of a children's tricycle onto the axle of an eighteen-wheeler. It would be better to put all tables into Oracle and only keep Access as a front end if really needed. There might be cases where it is not avoidable, but in that case we would need more information about what the actual goal is.
Also, most solution would depend on the exact Oracle and OS versions involved.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
