[gdal-dev] Oracle Connection issues

[abhay menon]

Hi Bruce,

Just quick answer to 1 question...

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.

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.

Note :.
The structure validation and memory implementation is more of part of OCI
than of OGR ( Mateusz correct me, if am wrong ).

Rgds.
Abhay.

On Thu, Jul 17, 2008 at 8:28 PM, Clay, Bruce <bclay at ball.com> wrote:

>  Two questions and one lesson learned passed on
>
>
>
> 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?
>
>
>
> 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?
>
>
>
>
>
> Lesson learned.
>
>
>
> 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.
>
>
>
> Patch download link:
>
>
> http://www.microsoft.com/downloads/details.aspx?FamilyId=32BC1BEE-A3F9-4C13-9C99-220B62A191EE&displaylang=en
>
>
>
> 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.
>
>
>
> 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/20080717/f2afd8d2/attachment.html