| listener for remote database [message #4904] |
Mon, 20 January 2003 08:55  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
