how to provide username and password in tnsnames.ora

sql excel oracle odbc database-administration
sandhiya picture sandhiya · Sep 26, 2016 · Viewed 7.6k times · Source

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?

Answer

mohsen.b picture mohsen.b · Sep 26, 2016

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

Related questions

Excel VBA connect to remote Oracle DB with InstantClient

I am trying to use Excel (mainly 2003, for more user compatibility) to connect to a remote Oracle DB. I would like to run a .sql script and return the dataset to a worksheet. I am on a Windows 7 64bit machine. …

Read More
Generate sql insert script from excel worksheet

I have a large excel worksheet that I want to add to my database. Can I generate an SQL insert script from this excel worksheet?

Read More
How to run a SQL query on an Excel table?

I'm trying to create a sub-table from another table of all the last name fields sorted A-Z which have a phone number field that isn't null. I could do this pretty easy with SQL, but I have no clue how …

Read More