Hi,<div><br></div><div>I'm not exactly sure about your issue specifically but if you don't specify the full tns name in the connection string, then oci will look up for tnsnames.ora at specific locations. Use <a href="http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx">Process Monitor</a> to identify the possible lookup locations.</div>
<div><br></div><div>Best regards,</div><div><br></div><div>Tamas</div><div><br></div><div><br><br><div class="gmail_quote">2013/7/30 <span dir="ltr"><<a href="mailto:Nelly.Howind@kivbf.de" target="_blank">Nelly.Howind@kivbf.de</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="DE" link="blue" vlink="purple">
<p></p>
<div>
<p class="MsoNormal"><span lang="EN-US">Hi,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">I try to access an oracle DB using following entry in mapfile:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">CONNECTIONTYPE PLUGIN<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">PLUGIN "msplugin_oracle.dll"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">CONNECTION "localhost,port:1521,<DBname>,<user>,<password>"
<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">DATA "GEOM FROM WSG USING SRID 31467"<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">I installed Oracle 11g locally on Windows 2008 R2 64 bit system and can connect to it via Net Manager or SQL Developer.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">I use a compiled mapserver release MSVC2010 Win 64 downloaded from
</span><a href="http://www.gisinternals.com/sdk/" target="_blank"><span lang="EN-US">http://www.gisinternals.com/sdk/</span></a><span lang="EN-US">, which works fine with file based geodata.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Now I get an error message ORA-01005 (null password given; logon denied), but I set password correctly.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Has anybody an idea, what I am making wrong? Has connection string using oracle another syntax?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Thanks in advance<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Nelly<u></u><u></u></span></p>
</div>
<p></p>
<p> </p>
<p><span style="font-family:Verdana;font-size:x-small">Kommunale Informationsverarbeitung Baden-Franken</span></p>
<p><span style="font-family:Verdana;font-size:x-small;font-weight:normal">Nelly</span> <span style="font-family:Verdana;font-size:x-small;font-weight:normal">Howind</span></p>
<u></u>
<div>
<div><span style="font-family:Verdana;font-size:x-small">Kommunale Dienstleistungen</span><u></u></div>
<div><u></u><span style="font-family:Verdana;font-size:x-small">Geoinformation und Umwelt</span><u></u></div>
<div><font face="Verdana">Betriebsstätte </font><span style="font-family:Verdana;font-size:x-small">Karlsruhe</span><u></u><u></u></div>
<u></u>
<div><span style="font-family:Verdana;font-size:x-small">Pfannkuchstraße 4</span><u></u><font face="Verdana">,
</font><span style="font-family:Verdana;font-size:x-small">76185</span><u></u><font face="Verdana">
</font><span style="font-family:Verdana;font-size:x-small">Karlsruhe</span></div>
<div>
<table cellspacing="0">
<tbody>
<tr>
<td><span style="font-family:Verdana;font-size:x-small">Fon: </span></td>
<td><span style="font-family:Verdana;font-size:x-small"><a href="tel:%2B49%20721%209529%20351" value="+497219529351" target="_blank">+49 721 9529 351</a></span></td>
</tr>
<tr>
<td><span style="font-family:Verdana;font-size:x-small">Fax: </span></td>
<td><span style="font-family:Verdana;font-size:x-small"><a href="tel:%2B49%20721%209529%20500351" value="+497219529500351" target="_blank">+49 721 9529 500351</a></span></td>
</tr>
<tr>
<td><span style="font-family:Verdana;font-size:x-small">E-Mail: </span></td>
<td><span style="font-family:Verdana;font-size:x-small"><a href="mailto:Nelly.Howind@kivbf.de" target="_blank">Nelly.Howind@kivbf.de</a></span></td>
</tr>
<tr>
<td><span style="font-family:Verdana;font-size:x-small">Internet:</span></td>
<td><span style="font-family:Verdana;font-size:x-small"><a href="http://www.kivbf.de" target="_blank">http://www.kivbf.de</a></span></td>
</tr>
</tbody>
</table>
</div>
<div><font face="Verdana"></font> </div>
<div><font face="Verdana"></font></div>
<div>
<hr>
</div>
<div>
<table style="BORDER-COLLAPSE:collapse" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td style="BORDER-BOTTOM:#d4d0c8;BORDER-LEFT:#d4d0c8;PADDING-BOTTOM:0cm;BACKGROUND-COLOR:transparent;PADDING-LEFT:5.4pt;WIDTH:230.3pt;PADDING-RIGHT:5.4pt;BORDER-TOP:#d4d0c8;BORDER-RIGHT:#d4d0c8;PADDING-TOP:0cm" valign="top" width="307">
<p style="MARGIN:0cm 0cm 0pt" class="MsoNormal"><span style="FONT-FAMILY:'Arial','sans-serif';COLOR:#333333;FONT-SIZE:8pt">Zweckverband<br>
Kommunale Informationsverarbeitung Baden-Franken</span></p>
<p style="MARGIN:0cm 0cm 0pt" class="MsoNormal"><span style="FONT-FAMILY:'Arial','sans-serif';COLOR:#333333;FONT-SIZE:8pt">Pfannkuchstraße 4, 76185 Karlsruhe</span></p>
<p style="MARGIN:0cm 0cm 0pt" class="MsoNormal"><span style="FONT-FAMILY:'Arial','sans-serif';COLOR:#333333;FONT-SIZE:8pt">Fon <a href="tel:%2B49%20721%209529%200" value="+4972195290" target="_blank">+49 721 9529 0</a>, Fax <a href="tel:%2B49%20721%209529%20120" value="+497219529120" target="_blank">+49 721 9529 120</a><br>
Verbandsvorsitzender: LR Hämmerle<br>
Hauptgeschäftsführer: William Schmitt</span></p>
</td>
<td style="BORDER-BOTTOM:#d4d0c8;BORDER-LEFT:#d4d0c8;PADDING-BOTTOM:0cm;BACKGROUND-COLOR:transparent;PADDING-LEFT:5.4pt;WIDTH:230.3pt;PADDING-RIGHT:5.4pt;BORDER-TOP:#d4d0c8;BORDER-RIGHT:#d4d0c8;PADDING-TOP:0cm" valign="top" width="307">
<p style="MARGIN:0cm 0cm 0pt" class="MsoNormal"><span style="FONT-FAMILY:'Arial','sans-serif';COLOR:#333333;FONT-SIZE:8pt">Kommunales Rechenzentrum Baden Franken GmbH</span></p>
<p style="MARGIN:0cm 0cm 0pt" class="MsoNormal"><span style="FONT-FAMILY:'Arial','sans-serif';COLOR:#333333;FONT-SIZE:8pt">Pfannkuchstraße 4, 76185 Karlsruhe</span></p>
<p style="MARGIN:0cm 0cm 0pt" class="MsoNormal"><span style="FONT-FAMILY:'Arial','sans-serif';COLOR:#333333;FONT-SIZE:8pt">Fon <a href="tel:%2B49%20721%209529%200" value="+4972195290" target="_blank">+49 721 9529 0</a>, Fax <a href="tel:%2B49%20721%209529%20120" value="+497219529120" target="_blank">+49 721 9529 120</a></span></p>
<p style="MARGIN:0cm 0cm 0pt" class="MsoNormal"><span style="FONT-FAMILY:'Arial','sans-serif';COLOR:#333333;FONT-SIZE:8pt">Hauptgeschäftsführer: William Schmitt<br>
Handelsregister des Amtsgerichts Mannheim Nr. HRB 109683</span></p>
</td>
</tr>
</tbody>
</table>
</div>
<div></div>
</div>
<p> </p>
<p></p>
<u></u>
<p></p>
<div></div>
<div></div>
<u></u>
<div></div>
<div></div>
<u></u>
<div></div>
<div></div>
<u></u><u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
<div></div>
<u></u>
</div>
<br>_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
<br></blockquote></div><br></div>