I have been using TOAD for ORACLE to connect to the Oracle server.
Yesterday, I downloaded the trial version of the TDM3.
I am using ‘Connections’ under File to connect to database. On selecting the ‘Native Client Connection method or TCP/IP’ , I can see the Service Name in the dropdown lists.
I am trying to connect to the same database but am running into errors like ‘Invalid SID’ while using TCP/IP or ‘Could not resolve connection identifier’ while using native client connection.
Even if I manually type the values for all the fields, and not use the dropdown values, I get the same error.
I have read couple of threads of this and other forums. Based on the suggestions mentioned there, here are the steps I tried, in that order:
Added ORACLE_HOME environment (user)variable with the value C:\ORACLE\OraXE\app\oracle\product\10.2.0\server\NETWORK\ADMIN.
Added TNS_ADMIN environment (user)variable with the value: C:\ORACLE\OraXE\app\oracle\product\10.2.0\server\NETWORK\ADMIN
Copied TNSNAMES.ORA to C:\Program Files (x86)\Quest Software\Toad Data Modeler 3\Bin
Copied OCI.DLL to C:\Program Files (x86)\Quest Software\Toad Data Modeler 3\Bin
Added TNS_ADMIN environment (system) variable.
I restarted TDM, after every change.
I have a Windows 7 system and could not find HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE.
I also could not edit the SQLNET.ORA file to add NAMES.DIRECTORY_PATH.
database RE: Oracle 10g.
Thanks for all the help.