<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<!-- Template generated by Exclaimer Mail Disclaimers on 09:07:11 Dienstag, 30 Juli 2013 -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">P.590817de-3159-49c9-9b46-7186ee606780 {
MARGIN: 0cm 0cm 0pt
}
LI.590817de-3159-49c9-9b46-7186ee606780 {
MARGIN: 0cm 0cm 0pt
}
DIV.590817de-3159-49c9-9b46-7186ee606780 {
MARGIN: 0cm 0cm 0pt
}
TABLE.590817de-3159-49c9-9b46-7186ee606780Table {
MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
page: Section1
}
</style>
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Nur Text Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
span.NurTextZchn
{mso-style-name:"Nur Text Zchn";
mso-style-priority:99;
mso-style-link:"Nur Text";
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
span.E-MailFormatvorlage19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.E-MailFormatvorlage20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body scroll="yes" lang="DE" link="blue" vlink="purple">
<p class="590817de-3159-49c9-9b46-7186ee606780"></p>
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I try to access an oracle DB using following entry in mapfile:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">CONNECTIONTYPE PLUGIN<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">PLUGIN "msplugin_oracle.dll"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">CONNECTION "localhost,port:1521,<DBname>,<user>,<password>"
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">DATA "GEOM FROM WSG USING SRID 31467"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></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.<o:p></o:p></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/"><span lang="EN-US">http://www.gisinternals.com/sdk/</span></a><span lang="EN-US">, which works fine with file based geodata.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></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.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></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?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thanks in advance<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Nelly<o:p></o:p></span></p>
</div>
<p></p>
<p class="590817de-3159-49c9-9b46-7186ee606780"> </p>
<p class="590817de-3159-49c9-9b46-7186ee606780"><span style="font-family:Verdana; font-size:x-small; ">Kommunale Informationsverarbeitung Baden-Franken</span></p>
<p class="590817de-3159-49c9-9b46-7186ee606780"><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>
<EXCLAIMER:AD Field="description">
<div>
<div><span style="font-family:Verdana; font-size:x-small; ">Kommunale Dienstleistungen</span></EXCLAIMER:AD></div>
<div><EXCLAIMER:AD Field="title"><span style="font-family:Verdana; font-size:x-small; ">Geoinformation und Umwelt</span></EXCLAIMER:AD></div>
<div><font size="2" face="Verdana">Betriebsstätte </font><span style="font-family:Verdana; font-size:x-small; ">Karlsruhe</span><EXCLAIMER:AD Field="l"></EXCLAIMER:AD></div>
<EXCLAIMER:AD Field="streetAddress">
<div><span style="font-family:Verdana; font-size:x-small; ">Pfannkuchstraße 4</span></EXCLAIMER:AD><font size="2" face="Verdana">,
</font><span style="font-family:Verdana; font-size:x-small; ">76185</span></EXCLAIMER:AD><font size="2" face="Verdana">
</font><span style="font-family:Verdana; font-size:x-small; ">Karlsruhe</span></div>
<div>
<table cellspacing="0" class="590817de-3159-49c9-9b46-7186ee606780Table">
<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; ">+49 721 9529 351</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; ">+49 721 9529 500351</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; ">Nelly.Howind@kivbf.de</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; ">http://www.kivbf.de</span></td>
</tr>
</tbody>
</table>
</div>
<div><font size="2" face="Verdana"></font> </div>
<div><font face="Verdana"></font></div>
<div>
<hr>
</div>
<div>
<table style="BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm" class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr style="mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes">
<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 +49 721 9529 0, Fax +49 721 9529 120<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 +49 721 9529 0, Fax +49 721 9529 120</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 class="590817de-3159-49c9-9b46-7186ee606780"> </p>
<p class="590817de-3159-49c9-9b46-7186ee606780"></p>
</EXCLAIMER:AD>
<p></p>
<div></div>
<div></div>
</EXCLAIMER:AD>
<div></div>
<div></div>
</EXCLAIMER:AD>
<div></div>
<div></div>
</EXCLAIMER:AD></EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
<div></div>
</EXCLAIMER:AD>
</body>
</html>