<div dir="ltr">Hi Bruce,<br><br>Just quick answer to 1 question...<br><br>The Client version of Oracle 10g R2 do have some issue of it own. Still the difference in the API of Oracle 9i to 10g is at large ( especially OCI and OCCI api). As a suggestion I would recommend you to use the same version of oracle as that of the client system.<br>
<br>Saying that 10.2.x.x and 10.1.x.x are also varying from each other too. I have past experience of running into trouble with them as well (i.e. not in GDAL/OGR context). But for implementation with OGR for pulling or pushing data to Oracle have been successful. So try using either 10.1 or 10.2 version of Oracle Client.<br>
<br>Note :.<br>The structure validation and memory implementation is more of part of OCI than of OGR ( Mateusz correct me, if am wrong ). <br><br>Rgds.<br>Abhay.<br><br><div class="gmail_quote">On Thu, Jul 17, 2008 at 8:28 PM, Clay, Bruce <<a href="mailto:bclay@ball.com">bclay@ball.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;">Two questions and one lesson learned passed on</span></font></p>
<p><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font size="2" face="Arial"><span style="font-size: 10pt; 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><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font size="2" face="Arial"><span style="font-size: 10pt; 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><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;">Lesson learned.</span></font></p>
<p><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font size="2" face="Arial"><span style="font-size: 10pt; 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><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;">Patch download link:</span></font></p>
<p><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;"> <a href="http://www.microsoft.com/downloads/details.aspx?FamilyId=32BC1BEE-A3F9-4C13-9C99-220B62A191EE&displaylang=en" target="_blank">http://www.microsoft.com/downloads/details.aspx?FamilyId=32BC1BEE-A3F9-4C13-9C99-220B62A191EE&displaylang=en</a></span></font></p>
<p><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font size="2" face="Arial"><span style="font-size: 10pt; 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><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;">Bruce</span></font></p>
</div>
</div>
<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>
<br>_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br></blockquote></div><br></div>