Location for TNS File
Moderators: chulett, rschirm, roy
Location for TNS File
Hi everybody,
I want to know the location where the TNS entry for the all databases are stored in the Datastage server.
I want to know the location where the TNS entry for the all databases are stored in the Datastage server.
Location?
[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
Yes to connect datastage server to any database it needs odbc entry right. where is the location of that file on the datastage server
.odbc.ini is located in your DataStage server where as Tnsnames.ora file is located in your client machine.
Thanks,
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
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.chulett wrote:Nope - at least not in a DataStage discussion. Both must be on the Server.mctny wrote:.odbc.ini is located in your DataStage server where as Tnsnames.ora file is located in your client machine.
Thanks,
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
Chad
__________________________________________________________________
"There are three kinds of people in this world; Ones who know how to count and the others who don't know how to count !"
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.
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.