Page 1 of 1
Location for TNS File
Posted: Tue Apr 17, 2007 8:54 am
by parsi_cnu
Hi everybody,
I want to know the location where the TNS entry for the all databases are stored in the Datastage server.
Posted: Tue Apr 17, 2007 9:00 am
by DSguru2B
TNS entries are only for Oracle and not for all databases. Do you mean the odbc connection info?
Location?
Posted: Tue Apr 17, 2007 9:12 am
by parsi_cnu
[quote="DSguru2B"]TNS entries are only for Oracle and not for [b]all[/b] databases. Do you mean the odbc connection info?[/quote]
Yes to connect datastage server to any database it needs odbc entry right. where is the location of that file on the datastage server
Posted: Tue Apr 17, 2007 9:33 am
by DSguru2B
On windows there is no .odbc.ini file. Refere to Ray's reply in
thispost.
Posted: Tue Apr 17, 2007 10:31 am
by mctny
.odbc.ini is located in your DataStage server where as Tnsnames.ora file is located in your client machine.
Posted: Tue Apr 17, 2007 10:36 am
by chulett
mctny wrote:.odbc.ini is located in your DataStage server where as Tnsnames.ora file is located in your client machine.
Nope - at least not in a DataStage discussion.
Both must be on the Server.
Posted: Tue Apr 17, 2007 10:59 am
by mctny
chulett wrote:mctny wrote:.odbc.ini is located in your DataStage server where as Tnsnames.ora file is located in your client machine.
Nope - at least not in a DataStage discussion.
Both must be on the Server.
ok sorry, you are right, I was thinking when I am trying to connect to another oracle DB in another server, I need to have tnsnames.ora in my machine( i.e., client) , in order for the oracle to resolve the DB name, location etc of the oracle DB.
Posted: Tue Apr 17, 2007 11:22 am
by kommven
TNS Entries are part of Oracle Client and should be a Oracle Database related.
ODBC is a Clientless Drivers to connect to variety of databases
You should have Oracle Client on DataStage Server to Use any Oracle Stage and cannot use Ora Stage just defining TNS Entry at ORACLE_HOME\network\ADMIN\tnsnames.ora
where ORACLE_HOME = c:/oracle in most cases.
You should be using ONLY ODBC Stage.
See for "Datasources (ODBC)" Manager on your Server Control Panel. It should be part of Administrative Tools.
Posted: Tue Apr 17, 2007 11:46 am
by DSguru2B
kommven wrote:
You should be using ONLY ODBC Stage.
Psst....
DRS stage too
Posted: Tue Apr 17, 2007 12:08 pm
by chulett
kommven wrote:You should be using ONLY ODBC Stage.
Why? I shun ODBC at every opportunity, preferring native interfaces whenever possible.
Posted: Tue Apr 17, 2007 12:24 pm
by kommven
For connecting to any database we DONT need tns entry location.
parsi_cnu wrote:
Yes to connect datastage server to any database it needs odbc entry right. where is the location of that file on the datastage server