<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Two questions and one lesson learned passed on</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>1. I built an application using GDAL 1.5.2 and Oracle 9.2
client tools. Everything works fine on my development system. When I take
the application to the customer system I can not connect to the Oracle database
and I am not getting an error that explains why. The target system does
have Oracle 10.2 client tools installed. Do versions have a match between
the development system and the target system to work with Oracle? And if
so what patch level in the version do we have to match? For example,
there are 4 digits in the Oracle version number. Do all 4 digits have to
be the same as what is compiled into GDAL for GDAL to be able to connect?</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>2. There seems to be a long pause when I connect to Oracle. I
used the debugger to follow the process and it looks like an internal structure
is created in GDAL memory space that contains information about all of the
tables in Oracle including the field names and data types. We have a database
with several tables so this takes a while to build. Is there a way to get
GDAL to do a quick connect without building this structure every time I
connect?</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Lesson learned.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>It seems that Microsoft has removed normal C++ support form
the operating system and starting with programs built with Visual Studio 2005 a
separate redistributable patch (link shown below) has to be applied to the
operating system to add the libraries required to run C++ based applications. This
also applies to C# applications that call DLLs such as GDAL. The error
message that you will see will not be very helpful but may include a mention of
“side-by-side”. More typically it will just say the
application can not run and reinstallation may help. Additionally, debug
versions of the program will not run on a computer that does not have Visual
Studio and the Microsoft rules state that debug versions of their libraries can
not be distributed. This of course really puts those of us who have to do
a lot of rapid prototyping and quick release of tools in a bind. Yes I
realize this only adds to the normal reluctance to use Microsoft stuff.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Patch download link:</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> <a
href="http://www.microsoft.com/downloads/details.aspx?FamilyId=32BC1BEE-A3F9-4C13-9C99-220B62A191EE&displaylang=en">http://www.microsoft.com/downloads/details.aspx?FamilyId=32BC1BEE-A3F9-4C13-9C99-220B62A191EE&displaylang=en</a></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>So the lesson learned: build GDAL and all of it’s
dependent libraries in release mode before trying to move off of the
development system.</span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Bruce</span></font></p>
</div>
</body>
</html>
<pre>
This message and any enclosures are intended only for the addressee. Please
notify the sender by email if you are not the intended recipient. If you are
not the intended recipient, you may not use, copy, disclose, or distribute this
message or its contents or enclosures to any other person and any such actions
may be unlawful. Ball reserves the right to monitor and review all messages
and enclosures sent to or from this email address.</pre>