[mapserver-users] oraclespatial connect error

[Yu-Hsin Chen]

Well, my problem is that the database is not on the local machine.  I
guess I could create the local database and test it out.  If that is
successful I can always create database link in Oracle to access the
real data.

Thanks for the tip on DATA.  I will have more questions back on this
item.

Yu-Hsin


-----Original Message-----
From:	Rodrigo Cabral
Sent:	Fri 2/22/2002 7:32 PM
To:	Yu-Hsin Chen; mapserver-users at lists.gis.umn.edu
Cc:	
Subject:	Re: [mapserver-users] oraclespatial connect error

Your error means that the Oracle client cannot find the database
(service)
to connect. Try using simply 'username/password' for CONNECTION to see
if
the default service works.

Also, your DATA statement is not going to work. 'circle' must be in the
select list. Like "circle from (select circle...)". BUT, why are you
doing
that? Try this:

DATA "circle FROM room_geoloc"
or
DATA "circle FROM room_geoloc USING SRID <srid#>" if you have an srid
number
defined.

Rod.

----- Original Message -----
From: "Yu-Hsin Chen" <ychen at yorktel.com>
To: <mapserver-users at lists.gis.umn.edu>
Sent: Friday, February 22, 2002 4:04 PM
Subject: [mapserver-users] oraclespatial connect error


I've compiled mapserver 3.5 with oraclespatial option on my Mandrake
Linux 8.0 with Oracle 8.1.7i.  When I run sqlplus at Linux prompt I can
get to the database with un/pw at bis login.  However, when I tried it from
a map file I get "msOCIConnect() in msOracleSpatialLayerOpen():
OracleSpatial error. Error while trying to retrieve text for error
ORA-12541" in my browser.  ORA-12541 is "TNS:could not resolve service
name".

My map file looks like this:

LAYER
  NAME "oracle"
  CONNECTIONTYPE oraclespatial
  CONNECTION 'un/pw at bis'
  DATA "circle from (select room_id, longitude, latitude from
room_geoloc)"
  TYPE POINT
  STATUS ON
    ...
    ...
END

Thanks in advance to whoever can help me.

Yu-Hsin Chen




-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 3446 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapserver-users/attachments/20020222/0b0e5e38/attachment.bin