title: ODBC connection to oracle time-out
body: <p>I'm new here so I introduce myself, my name is Ettore Giallaurito and my job is in the IT services in Italy.</p>
  
  <p>My question:</p>
  
  <p>I'm trying to connect to an Oracle DB instance through an odbc (System DNS) connections under XP but I get an error ORA1254 TNS:could not resolvethe connect identifier specified.</p>
  
  <p>I'm using oracle instant client 11.2 and I've my tnsnames properly configured, since I can get connected with DBVisualizer using the TNS method. 
  To be honest I do get connected in this case, but I need to insert the full connect string: </p>
  
  <pre><code>(DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = repsit01.sit.sor)(PORT = 1521))
      (CONNECT_DATA = (SERVICE_NAME = REPSIT01))
    )
  </code></pre>
  
  <p>since it doesn't get me in if I use just the SID, in my case REPSIT01 as showed below.</p>
  
  <p>My tns entry is as follow:</p>
  
  <pre><code>REPSIT01 =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
      (CONNECT_DATA = (SERVICE_NAME = REPSIT01))
    )
  </code></pre>
  
  <p>Any help would be much apprecciated.</p>
  
  <p>Thanks in advance Ettore.</p>