Location for TNS File

parsi_cnu · Post by **parsi_cnu** » Tue Apr 17, 2007 8:54 am

Hi everybody,

I want to know the location where the TNS entry for the all databases are stored in the Datastage server.

DSguru2B · Post by **DSguru2B** » Tue Apr 17, 2007 9:00 am

TNS entries are only for Oracle and not for all databases. Do you mean the odbc connection info?

parsi_cnu · Post by **parsi_cnu** » Tue Apr 17, 2007 9:12 am

[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

DSguru2B · Post by **DSguru2B** » Tue Apr 17, 2007 9:33 am

On windows there is no .odbc.ini file. Refere to Ray's reply in thispost.

mctny · Post by **mctny** » Tue Apr 17, 2007 10:31 am

.odbc.ini is located in your DataStage server where as Tnsnames.ora file is located in your client machine.

chulett · Post by **chulett** » Tue Apr 17, 2007 10:36 am

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.

mctny · Post by **mctny** » Tue Apr 17, 2007 10:59 am

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.

kommven · Post by **kommven** » Tue Apr 17, 2007 11:22 am

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.

DSguru2B · Post by **DSguru2B** » Tue Apr 17, 2007 11:46 am

kommven wrote: You should be using ONLY ODBC Stage.

Psst....

DRS stage too

chulett · Post by **chulett** » Tue Apr 17, 2007 12:08 pm

kommven wrote:You should be using ONLY ODBC Stage.

Why? I shun ODBC at every opportunity, preferring native interfaces whenever possible.

kommven · Post by **kommven** » Tue Apr 17, 2007 12:24 pm

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

DSXchange

Location for TNS File

Location for TNS File

Location?