Home » RDBMS Server » Networking and Gateways » listener for remote database
listener for remote database [message #4904] Mon, 20 January 2003 08:55 Go to next message
Dries
Messages: 2
Registered: January 2003
Junior Member
I hope this is the right board,, otherwise redirect me please.
I'll explain my problem first :

I have an nt network, only the server (nt4) has connection to the oracle database, the clients don't.
I need to be able to access the oracle server (via odbc) from the clients without altering anything in the network configuration.

I was thinking in the direction of :

setting up a net8 listener on the ntserver listening for incoming connections from the network, and getting the data from the remote database. Setting up odbc links to that listener on the clients in the network.
But : how do i set up a listener for a remote database? I always get a : TNS name not found error.

This is quite urgent...

Thnx, in advance
Re: listener for remote database [message #4906 is a reply to message #4904] Mon, 20 January 2003 10:22 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you need oracle client installed in every participating terminal/client.
use ODBC drivers to create DSN and connect to oracle using hoststring ( hoststrings are created as tnsentries in tnsnames.ora in every client machine. you can have any hoststring u want
Previous Topic: Listener consuming lot of CPU
Next Topic: Calling External Dll Issue - RPC
Goto Forum:
  


Current Time: Thu Mar 28 10:26:06 CDT 2024