Home » Infrastructure » Windows » Connecting Oracle to Remote Access Server
Connecting Oracle to Remote Access Server [message #496813] Wed, 02 March 2011 09:32 Go to next message
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 #496814 is a reply to message #496813] Wed, 02 March 2011 09:35 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
You can create an ODBC from access>oracle. Don't think you can do it the other way around though, maybe, but I've not heard of it.

Since I hate access I'd suggest dumping out the tables, loading them to oracle and burning that access database Smile

[Updated on: Wed, 02 March 2011 09:36]

Report message to a moderator

Re: Connecting Oracle to Remote Access Server [message #496838 is a reply to message #496814] Wed, 02 March 2011 12:57 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3010
Registered: January 2010
Location: Connecticut, USA
Senior Member
Roachcoach wrote on Wed, 02 March 2011 10:35
Don'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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
ThomasG
Messages: 3211
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.

Re: Connecting Oracle to Remote Access Server [message #496862 is a reply to message #496859] Wed, 02 March 2011 15:09 Go to previous message
Littlefoot
Messages: 21624
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Here's me again, pointing to Maaher's walkthrough.
Previous Topic: PL/SQL: ORA-02185: a token other than WORK follows COMMIT ORA-06550:
Next Topic: how to retrieve the blob column data from table?
Goto Forum:
  


Current Time: Sat Dec 05 12:27:55 CST 2020