OraFAQ Forum: Windows » Connecting Oracle to Remote Access Server

Home » Infrastructure » Windows » Connecting Oracle to Remote Access Server

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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!

Report message to a moderator

Re: Connecting Oracle to Remote Access Server [message #496814 is a reply to message #496813]

Wed, 02 March 2011 09:35

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

Solomon Yakobson
Messages: 3305
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

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.

Report message to a moderator

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.

Report message to a moderator

Re: Connecting Oracle to Remote Access Server [message #496862 is a reply to message #496859]

Wed, 02 March 2011 15:09

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Here's me again, pointing to Maaher's walkthrough.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 13:40:40 CDT 2025