Problems Compiling for & Using Oracle Spatial

[Fernando Simon]

Hi Timothy,
    It's a strange problem, the same occur with GDAL and Mapserver 
native connection.
    I believe that it's a problem with Oracle libs, to compile Mapserver 
you need to have Oracle libs (from Client or instant library) in your 
system. If you have them from Oracle Client you need to set the Oracle 
environments too (ORACLE_HOME, ORACLE_BASE at least).
    You can use a client to connect in a server in another machine 
without problem.
     Best regards.

--------------------------------------------------------------
Fernando Simon
UMN Mapserver and Oracle Spatial developer
--------------------------------------------------------------

Timothy J Nolte wrote:
> On Mon, 6 Aug 2007 12:54:16 -0500, Timothy J Nolte <tnolte at ILPCS.COM> wrote:
>
>   
>> I've been going crazy to figure out why I'm having so many problems with
>> trying to setup MapServer to connect to Oracle and get some spatial data. No
>> matter what I've tried I'm unable to get GDAL (=>1.4.2) to configure and
>> compile with Oracle Spatial support. I decide to skip that and I seemingly
>> compiled MapServer (4.10.2) with Oracle Spacial support but whenever
>> MapServer tries to connect to the database it always returns invalid
>> username/password. In my testing it appears to be picking up the right
>> service from the tnsnames file and/or environment. I thought perhaps we
>> didn't actually have the full client installed, even though we do have a
>> full Oracle Enterprise database running on the same machine. Even installing
>> the Runtime Oracle Client things don't seem to work. This is a Solaris Sparc
>> 64 machine. MapServer works otherwise but I really need to be able to
>> connect to Oracle. Does anyone have any thoughts on this?
>>     
>
> I forgot to mention this is Oracle 10g (10.1.0.5)..thx.
>
>