Originally posted by: vijji_WTX

Good Morning All,

I have WTX 8.4.1.3 installed and i am testing .MDQ file in Database Interface Designer. I have oracle connecting details ( host/SID/User/Pass) and I have Oracle Client installed.

I am getting ORA-12560: TNS:protocal adapter error when u try to connect with DID ( with SID/username/password)

I do not have any previlages to change tnsnames.ora file with these connection details. Now challenge is... Is there any way to connect to database by connection details directly in DID/.mdq file?

I have to generate some typetrees from Oracle and i guess DID will refer Oracle/..network/admin/tnsnames.ora.

Thanks in advance !

vijji

Originally posted by: Ejay

Hi ,

You will need to have the Database setup in the tnsnames.ora in order to be able to connect with the Oracle adapter to the database .

It use the Oracle native Client so we need the tnsnames.ora definition .

Ejay .

Originally posted by: paul.brett

Make a copy of the existing tnsnames.ora file in a location in your personal workspace.  You will be able to edit this new file.

Set the TNS_ADMIN variable to point to this new file, and then you should be able to get a working system.

http://www.orafaq.com/wiki/TNS_ADMIN

Thank-you.

Paul.

Follow me on Twitter

Originally posted by: vijji_WTX

Thank you very much Guys for Answers. Have Great Day.