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 <[EMAIL PROTECTED]> 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.
