Problems Compiling for & Using Oracle Spatial

[Timothy J Nolte]

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.