Connecting a database in a linux system from a windows system through oracle 10g

15 pts.
Tags:
Database connectivity
Linux
Linux servers
Oracle 10g
Remote connection
Windows connections
hello sir/mam i have a linux server loaded with oracle 10g with so many databses. i want other windows systems to access the databases of server through oracle 10g. could u please explain me in detail how to make this set up.

Software/Hardware used:
oracle 10g,1 linux os(server), 3 windows os systems.
ASKED: October 7, 2010  7:25 PM
UPDATED: October 19, 2010  3:32 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hey you can connect to your MS Access database through ODBC. Only thing is even Oracle database server should be installed on the same machine.
Configure the Listener on the oracle server with required details about MS Access server, the same procedure should be adopted for MS Access server. TNS Ping should be done to ensure the connectivity between these two servers. You are ready to go…

Shashi singh

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Could you please explain what exactly is what you are trying to do ? What exactly do you mean by 'i want other windows systems to access the databases of server "through" oracle 10g' ? If the appropriate Oracle client software is installed on the windows machines, they can connect to the database without any special configuration, no matter what the server's OS is.
    65,110 pointsBadges:
    report
  • carlosdl
    I don't think an Access database in involved here...
    65,110 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following