Bingo !.... yes, that worked... <div><br></div><div>resuming:</div><div><br></div><div>replaced TNS connection string </div><div><br></div><div>CONNECTION "OCI:GEO_US_DATA/GEO_US_DATA@MFUATDB:CA_WILDFIRE" </div><div>
<br></div><div>with <span class="Apple-style-span" style="font-family: Calibri, Verdana, Helvetica, Arial; font-size: 15px; ">EZConnect syntax</span></div><div><br></div><div>CONNECTION "OCI:GEO_US_DATA/<a href="http://GEO_US_DATA@192.168.60.70/MFUATDB:CA_WILDFIRE">GEO_US_DATA@192.168.60.70/MFUATDB:CA_WILDFIRE</a>"</div>
<div><br></div><div>where the tnsnames.ora is</div><div><br></div><div><div>MFUATDB =</div><div> (DESCRIPTION =</div><div> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))</div><div> (CONNECT_DATA =</div>
<div> (SERVER = DEDICATED)</div><div> (SERVICE_NAME = MFUATDB)</div><div> )</div><div> )</div></div><div><br></div><div>Thanks<br><br><div class="gmail_quote">On Tue, Oct 5, 2010 at 12:48 PM, Michael Smith <span dir="ltr"><<a href="mailto:michael.smith@usace.army.mil">michael.smith@usace.army.mil</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
<font face="Calibri, Verdana, Helvetica, Arial"><span style="font-size:11pt">Sebastian,<br>
<br>
Instead of using TNS, you could try the EZConnect syntax of @host:port/service_name. That way you bypass even needing a TNS. Also if your port is 1521, you can just not include it and use<br>
<br>
CONNECTION “user/pass@hostname/service_name”<br>
<br>
Mike<br><font color="#888888">
<br>
<font class="Apple-style-span" color="#000000" face="arial"><span class="Apple-style-span" style="font-size: small; "><font class="Apple-style-span" color="#888888" face="Calibri, Verdana, Helvetica, Arial" size="4"><span class="Apple-style-span" style="font-size: 15px;"><br>
</span></font></span></font></font></span></font></div></blockquote></div><br><br>
</div>