[gdal-dev] GDAL/OGR to Oracle connect problems

[abhay menon]

Hi Bruce,

OGR does requires Oracle Client as matter any dotnet or C++ app that is been
built for oracle based process need's it.

Secondly, You could use the Oracle's Instant Client : which keep everything
to bare minimum you find it here :
http://www.oracle.com/technology/tech/oci/instantclient/index.html

Include the dll or install a Oracle client.

also  databaseInstance you can use the //<servername>:<port>/<database
instance> to connect if you using Instant Client. as you don't need to
specify the TNS entry for the same.

Rgds.

Abhay.



On Thu, Jul 10, 2008 at 1:59 AM, Clay, Bruce <bclay at ball.com> wrote:

>  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.
>
>
>
> I am using Visual Studio 2005 C++ running on XP.  I am using GDAL_1.5.2.
>
>
>
> When I use OGR to connect I use the connection string
> "OCI:username/Password at databaseInstance" as the OCI driver instructions
> said to do.
>
>
>
> 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.
>
>
>
> Does OGR require the Oracle client tools to be installed before it will
> connect?
>
>
>
> Bruce
>
>
>
> 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.
>
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20080710/da127dfd/attachment-0001.html