ORA 12154 error when fetching data from Oracle

1149570 pts.
Tags:
Microsoft Excel
Oracle
My boss gave me a Microsoft Excel file (which my predecessor used) and it uses an external data connection to fetch our data from Oracle. I've been trying to migrate this file to my PC but I keep getting this error message: ORA 12154 TNS could not resolve the connect identifier specified. What's the best way to fix this?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

You probably need Oracle client installed with oo40
Do you have a TNS_ADMIN set in your global environment?
TNS_ADMIN=c:\mytns
inside of c:\mytns is you tnsnames.ora file

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: