[mapserver-users] oraclespatial connect error

[Yu-Hsin Chen]

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