Setting up ODBC connection to 11g database
Posted on 2012-03-27
Hi - My co-workers and I use an Excel spreadsheet that connects to an Oracle 11g database. We are all running Oracle 8 client versions (plan to upgrade in the near future). In the meantime, we have a new employee who had the version 11 client installed on his notebook (no prior versions existed on his computer). I need to set him up to use the Excel tool and would like to confirm that I have to follow the same steps I did for setting up access from my own Oracle 8 client: (1) Set up entry in TNSNAMES.ORA file and (2) create ODBC data source. I can't seem to locate a TNSNAMES.ORA file on his notebook - if I do need to add an entry, can someone steer me in the right direction? Thank you!