Hi Bruce,<br><br>OGR does requires Oracle Client as matter any dotnet or C++ app that is been built for oracle based process need's it.<br><br>Secondly, You could use the Oracle's Instant Client : which keep everything to bare minimum you find it here : <br>
<a href="http://www.oracle.com/technology/tech/oci/instantclient/index.html">http://www.oracle.com/technology/tech/oci/instantclient/index.html</a><br><br>Include the dll or install a Oracle client. <br><br>also <font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;">databaseInstance you can use the //<servername>:<port>/<database instance> to connect if you using Instant Client.</span></font> as you don't need to specify the TNS entry for the same. <br>
<br>Rgds.<br><br>Abhay.<br><br><br><br><div class="gmail_quote">On Thu, Jul 10, 2008 at 1:59 AM, 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;">I have an OGR application that runs fine on my development
system. When I moved the program to the target system I can not connect to the
Oracle database. The first round of problems seemed to be related to the
Visual Studio C++ redistributable files. After installing them, one of the
systems quit throwing exceptions but still won't connect and the other
systems continues to throw exceptions.</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;">I am using Visual Studio 2005 C++ running on XP. I am using
GDAL_1.5.2.</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;">When I use OGR to connect I use the connection string "OCI:username/Password@databaseInstance"
as the OCI driver instructions said to do.</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;">My development system has the Oracle client tools but
neither target system do. How does OGR resolve the instance name to host and
port? If the client tools are installed there is a TNS name file that has this
information. </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;">Does OGR require the Oracle client tools to be installed
before it will 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;">Bruce</span></font></p>
<p><font size="2" face="Arial"><span style="font-size: 10pt; font-family: Arial;"> </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>