CODEWITHSUNDEEP
sqlexceloracle-databaseodbcdatabase-administration
sandhiya
sandhiya

Reputation: 133

how to provide username and password in tnsnames.ora

I have connected oracle server database in excel with the help of oracle instant client software and i am getting table and data but whenever i am restarting excel to connect with oracle database it is asking username and password so i want to save the username and password so is this possible to provide username and password in tnsnames.ora file itself?

ASDCOM=
 (description=
   (address_list=
     (address = (protocol = TCP)(host = 10.1.1.128)(port = 1521))
   )
 (connect_data =
   (service_name=ASDCOM)
 )
)

Upvotes: 4

Views: 14828

Answers (3)

Mohm Zanaty
Mohm Zanaty

Reputation: 649

You can save the username and password manually only for Tracking and it will not reflect anywhere in tnsnames.ora

like this

SEADEV.WORLD = (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521))
)
(CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = TEST)
)
 (USER ID=myUser) (PASSWORD=myPaswoer)
)

Upvotes: 0

Ghayaz Dot Net Apps Developer
Ghayaz Dot Net Apps Developer

Reputation: 77

you cannot save username and password in tnsnames.ora instead you can save username and password in .odc file which is generated when you provide username and password in excel data connection wizard and click on savePasswordInFile checkbox.

Upvotes: 2

mohsen.b
mohsen.b

Reputation: 436

It isn't possible to save username and password in tnsnames.ora file. you should fix it in excel.

Upvotes: 3

Related Questions