<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.EstiloCorreo18
{font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body bgcolor=white lang=CA link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi,</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I tested de DependencyWalker on the KingOracleProvider.dll
and it seemed to be missing the MSVCR80.dll and the MSVCP71.dll.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I searched and donwloaded this files from
the web.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>After that, the connection propreties on
Autodesk Studio displayed well and i managed the connection to the database.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Thank you for your help.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<div>
<p class=MsoNormal><font size=2 color=black face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'>Luís Ramos</span></font></p>
<p class=MsoNormal><font size=1 color=gray face=Verdana><span style='font-size:
8.0pt;font-family:Verdana;color:gray'>Dpto. de GIS, Movilidad y Datos</span></font></p>
<p class=MsoNormal><font size=3 color=black face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
</div>
<p class=MsoNormal style='margin-left:35.4pt'><font size=2 color=black
face=Tahoma><span lang=ES style='font-size:10.0pt;font-family:Tahoma;
color:windowtext'>-----Mensaje original-----<br>
<b><span style='font-weight:bold'>De:</span></b>
mapguide-users-bounces@lists.osgeo.org
[mailto:mapguide-users-bounces@lists.osgeo.org] <b><span style='font-weight:
bold'>En nombre de </span></b>Simon Pelicon<br>
<b><span style='font-weight:bold'>Enviado el:</span></b> dijous, 10 / abril /
2008 11:43<br>
<b><span style='font-weight:bold'>Para:</span></b> MapGuide Users Mail List<br>
<b><span style='font-weight:bold'>Asunto:</span></b> Re: [mapguide-users] King
Oracle Problem</span></font></p>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt'>Hi!<br>
<br>
</span></font></p>
<pre style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>Connection properties are blank because provider did not loaded successfully.</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>Open KingOracleProvider.dll with DependencyWalker ( <a
href="http://www.dependencywalker.com/">http://www.dependencywalker.com/</a>) and look for missing dll.</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>I think that Oracle client needs some Microsoft MFC dll files.</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'>Simon</span></font></pre><pre style='margin-left:35.4pt'><font size=2
color=black face="Courier New"><span style='font-size:10.0pt'> </span></font></pre>
<p class=MsoNormal style='margin-left:35.4pt'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt'><br>
<br>
<br>
Luis Ramos wrote: </span></font></p>
<pre style='margin-left:35.4pt' wrap=""><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt'>Hello,</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'>I'm facing a similar problem on a XP machine with MagGuide Server 2.0,</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>Apache 2 and Oracle 9.2.</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'>What I've done:</span></font></pre><pre style='margin-left:35.4pt'><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'>- downloaded and installed the King Oracle v.0.7.3 For FDO 3.3 with Oracle</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>Instant Client.</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>- downloaded and installed the Oracle Instant Client basic v 10.2.0.3</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>- changed the providers.xml file</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>- restarted the MapGuide Server</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'>What do I get when creating a new data connection:</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>- on Autodesk MapGuide Studio 2008, shows the King Provider on the FDO list</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>but after selecting this, the connection properties are blank and non</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>editable.</span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'>- on AutoCAD Map 3D 2008, shows the King Provider on the FDO list but after</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>selecting this, I get an unable to create connection to provider</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>"King.Oracle.0.1.1".</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'>If you managed to solve this problem please tell me how.</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'>Luís Ramos</span></font></pre><pre style='margin-left:35.4pt'><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'> </span></font></pre><pre style='margin-left:35.4pt'><font size=2
color=black face="Courier New"><span style='font-size:10.0pt'>A H wrote:</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre>
<blockquote style='margin-top:5.0pt;margin-bottom:5.0pt' type=cite><pre
style='margin-left:35.4pt' wrap=""><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>hello. i'm also currently facing the same problem. i'm using Oracle 9.2 as</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>database. i followed the steps and i got this message when testing the</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>connection in MapGuide Studio 2008:</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'>An exception occurred in FDO component.</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>ORA-12705: Cannot access NLS data files or invalid environment specified</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'>what does that mean?</span></font></pre><pre style='margin-left:35.4pt'><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'>my FDO version is 3.2.2. and i downloaded the v0.7.3 Windows 32-bit</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>provider with Oracle Instant Client from the website. i copied the</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>King.Oracle DLLs and Oracle instant clients DLL and put it in the FDO</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>folder. is this definition correct for providers.xml?</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'><FeatureProvider></span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'> <Name>King.Oracle.0.1.1</Name> </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> <DisplayName>King Provider for Oracle</DisplayName> </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> <Description>Read/write access to spatial and attribute data in an</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>Oracle Spatial.</Description> </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> <IsManaged>False</IsManaged> </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> <Version>0.1.1.0</Version> </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> <FeatureDataObjectsVersion>3.2.2.0</FeatureDataObjectsVersion> </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> <LibraryPath>C:\Program</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>Files\MapGuideOpenSource\Server\Bin\FDO\KingOracleProvider.dll</LibraryPath> </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </FeatureProvider></span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'>i thought everything should be fine since MapGuide Studio is enable to</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>display the providers but i got that message. i use</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>//[host]:1521/[service] as the service name as mentioned in the Oracle's</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>documentation.</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'> </span></font></pre><pre style='margin-left:35.4pt'><font size=2
color=black face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'>Simon Pelicon wrote:</span></font></pre><pre style='margin-left:35.4pt'><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'> </span></font></pre>
<blockquote style='margin-top:5.0pt;margin-bottom:5.0pt' type=cite><pre
style='margin-left:35.4pt' wrap=""><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>Hi,</span></font></pre><pre style='margin-left:35.4pt'><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'>Which version of MapGuide do you have?</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>There are providers v0.7.3 for different FDO versions (3.1 ,3.2 and</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>.3.2.2)</span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'> </span></font></pre><pre style='margin-left:35.4pt'><font size=2
color=black face="Courier New"><span style='font-size:10.0pt'>Do you restart MG server after changing provider files,xml etc...?</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>You can also check which files are missing or wrong , using "Dependency </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>walker" <a href="http://www.dependencywalker.com/">http://www.dependencywalker.com/</a></span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>With Dependency W. open KingProvider.dll.</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'>Simon</span></font></pre><pre style='margin-left:35.4pt'><font size=2
color=black face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>JeromeA wrote:</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre>
<blockquote style='margin-top:5.0pt;margin-bottom:5.0pt' type=cite><pre
style='margin-left:35.4pt' wrap=""><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>Hi,</span></font></pre><pre style='margin-left:35.4pt'><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>yes I think so. I took the first one: v0.7.3 Windows 32-bit provider</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>with</span></font></pre><pre style='margin-left:35.4pt'><font
size=2 color=black face="Courier New"><span style='font-size:10.0pt'>Oracle Instant Client.</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>I'm trying to connect to Oracle 9.2.0.4.0 from MG Studio 2008</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'>Jerome</span></font></pre><pre style='margin-left:35.4pt'><font size=2
color=black face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre></blockquote>
<pre style='margin-left:35.4pt' wrap=""><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt'>_______________________________________________</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'>mapguide-users mailing list</span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'><a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a></span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'><a
href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a></span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre><pre style='margin-left:
35.4pt'><font size=2 color=black face="Courier New"><span style='font-size:
10.0pt'> </span></font></pre><pre style='margin-left:35.4pt'><font size=2
color=black face="Courier New"><span style='font-size:10.0pt'> </span></font></pre></blockquote>
<pre style='margin-left:35.4pt' wrap=""><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre></blockquote>
<pre style='margin-left:35.4pt' wrap=""><font size=2 color=black
face="Courier New"><span style='font-size:10.0pt'> </span></font></pre><pre
style='margin-left:35.4pt'><font size=2 color=black face="Courier New"><span
style='font-size:10.0pt'> </span></font></pre></div>
</body>
</html>