[mapserver-users] oraclespatial connect error

[Yu-Hsin Chen]

This is a multi-part message in MIME format.

------_=_NextPart_001_01C1BC0F.08A8E81F
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

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@lists.gis.umn.edu
Cc:=09
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@yorktel.com>
To: <mapserver-users@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@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@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





------_=_NextPart_001_01C1BC0F.08A8E81F
Content-Type: application/ms-tnef;
	name="winmail.dat"
Content-Transfer-Encoding: base64

eJ8+IjMCAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEgAEAMgAAAFJFOiBbbWFwc2VydmVyLXVz
ZXJzXSBvcmFjbGVzcGF0aWFsIGNvbm5lY3QgZXJyb3IAtRIBBYADAA4AAADSBwIAFgAVAAgAMQAF
AEQBASCAAwAOAAAA0gcCABYAFQAIADEABQBEAQEJgAEAIQAAADVBM0YzMEM5Njk0MjMxNEZCMTc1
NjkyRkEwNEMxQTA2AAcHAQOQBgB4DAAANgAAAAMANgAAAAAAQAA5AB/oqAgPvMEBHgA9AAEAAAAF
AAAAUkU6IAAAAAACAUcAAQAAADAAAABjPXVzO2E9IDtwPVlvcmt0ZWw7bD1ZVENNQUlMLTAyMDIy
MzAyMDg0OVotNDUxOAAeAEkAAQAAADIAAABSZTogW21hcHNlcnZlci11c2Vyc10gb3JhY2xlc3Bh
dGlhbCBjb25uZWN0IGVycm9yAAAAQABOAAAO2YgBvMEBHgBaAAEAAAAPAAAAUm9kcmlnbyBDYWJy
YWwAAAIBWwABAAAAPgAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAFJvZHJpZ28gQ2FicmFsAFNN
VFAAY2FicmFsQHlhZGF0YS5uZXQAAAACAVwAAQAAABcAAABTTVRQOkNBQlJBTEBZQURBVEEuTkVU
AAAeAF0AAQAAAA8AAABSb2RyaWdvIENhYnJhbAAAAgFeAAEAAAA+AAAAAAAAAIErH6S+oxAZnW4A
3QEPVAIAAAAAUm9kcmlnbyBDYWJyYWwAU01UUABjYWJyYWxAeWFkYXRhLm5ldAAAAAIBXwABAAAA
FwAAAFNNVFA6Q0FCUkFMQFlBREFUQS5ORVQAAB4AZgABAAAABQAAAFNNVFAAAAAAHgBnAAEAAAAS
AAAAY2FicmFsQHlhZGF0YS5uZXQAAAAeAGgAAQAAAAUAAABTTVRQAAAAAB4AaQABAAAAEgAAAGNh
YnJhbEB5YWRhdGEubmV0AAAAHgBwAAEAAAAuAAAAW21hcHNlcnZlci11c2Vyc10gb3JhY2xlc3Bh
dGlhbCBjb25uZWN0IGVycm9yAAAAAgFxAAEAAAAbAAAAAcG8ABd5Z29Et8m/TniOlJjwd/dimQAD
pa2TAB4AdAABAAAAMAAAAFl1LUhzaW4gQ2hlbjsgbWFwc2VydmVyLXVzZXJzQGxpc3RzLmdpcy51
bW4uZWR1AB4AGgwBAAAADQAAAFl1LUhzaW4gQ2hlbgAAAAAeAB0OAQAAAC4AAABbbWFwc2VydmVy
LXVzZXJzXSBvcmFjbGVzcGF0aWFsIGNvbm5lY3QgZXJyb3IAAAACAQkQAQAAAKoFAACmBQAAtAkA
AExaRnUBv0fFAwAKAHJjcGcxMjXiMgNDdGV4BUEBAwH3/wqAAqQD5AcTAoAP8wBQBFY/CFUHshEl
DlEDAQIAY2jhCsBzZXQyBgAGwxEl9jMERhO3MBIsETMI7wn3tjsYHw4wNREiDGBjAFAzCwkBZDM2
FlALpiBXAGVsbCwgbXkgRnADYAJgZW0gBAAgjnQT4AVAHjBlIGQeUM0BoGEUEB3ybm8FQAIgux5z
F7BjB0AdQADQaAuAgGUuICBJIGcKUMcEESEwBaB1bGQhwBggfx5QHqAf+B7HAHAiEA6wc6UFQGkf
oXV0IQJmHiTVHgFzGtBjIXFmIfAhouMDkQdAd2F5BCAiNR7HmmwLgGsd8AOgT3IA0PsdwB4gbyPA
JcMecyJBIyTuLgqiCoQKgFQT4ChABCA3AhAFwB6CdAUgH7JEQVxUQSEDA/AdECAT4HbnHqAEYBgg
IHEhYSxAAiD7BCAfAGMoUB/DHgEkYB3Q4SqLWXUtSACQC5Aqqc0qlC0yQiigaWcLgCBhYk0hcWFn
ZTJDKpRGbQNhOgyCB/FkMqEpIEP/AaAosBgAKqMGYAIwNIQ0QCBpIDIvMjcBMDCRFEA3OjMUQFBN
KvWebzSEMLUSIB6QbjsggYpwFBByLbByLXU6AcxzQCggJDBzLjLAOxBwdW1uLgmADHAqo0PGYzSE
NcV1YmoFkDZVoFJlOiBbOd1dH7C9KLNzCrAsQCBhBaBuIODtPXAgBJADYHIv+whhQKT/HUAiUAYx
HjcopSjQCJACMLsmYh+CZguAI/Eemig6AnkN4GUpKpQpEUA1IQBU7nIdYDpwC4BnJZAHcAtQ3R1g
JzpyMuAHgC8KsAQQEncFsGQnK7NDT07gTkVDVElKICkCFBDdHzFmRmUekgEQYSHwBUAfReUtMAWw
K5Aqi0Fsc/pvHTB5QdIssiWQAZAvsX9EAh9VNTBH4ikRTPIhACfYY2lyKNFJsG06cAVA/mIfMR/T
KpQUEB3AQIE60tEhAExpax6gIlEkK7AvA2FFwlMDUSQuVbApIpEhAEJVVB0wd2gdYH8KwB6gTnEe
sFAyS1YeUD8/R3MvUjSAKqlOw1QGRlLUT00p4G8DcF8zcBehPGMiKpRA5lmfWqogVRBTSU5HBgBS
SUQIIDxzBRBkIz4i/0shVuMtkwORXvIfcDtwUfD3QPUBASDRZCqLNOEqizJDeyiRMrwgM55T8Dj6
X1A8dnkT0AnwQE5wTRAOsGzyLgWgbT44F17QOd867i9oRTYjNrIewHkdMEZlfTWAdQrAHWA3IB0w
N1M0+DowNDfnPSY+Lz8/QE/ZMXtJJy2xaBFwAxAJgOE5yCAzLjUtMR4wb/3ebwUwLoEfsh1RTSPR
KLAPU9AqlFOwYLB4IDguDxZQdJMopXfQMS43aT0hAVc5gSEhbJBgQXFs/wtQaaAjwAVAd3QdgUhA
BUD/JlMqlDNwHmEpIB6LdJN54PFJIHdAYh4BF7AywSEBcEhvd2VpYVZSeYN03wiBIhAkYQNSKpRh
OcJEoQco4SExfFEibXNPQ+ZJCFBxAygpKGKCQSizmlNwdEwm4ASQT3AJ8N+DAFjFg4txVCEARUIj
VnD7gZJ/8HlQRRggf/ItsQ6zQyvCcWlPUkEtDiE0/jFfUXZDNYB/AGkxIQGJ98Ed8iJUTlM6IdQf
gvsYIE4wbC2xReUqlEjiVfDdKppNHWCBRxewbyuRKCCDU9FYj0xBWUVSKpThIRBOQU1FU/BwBFtl
4yEQShhUWVCTUHALk//3SqBIkH3mJ5KmXFtUi1qz318QHTAXsEfwJGB1AQCaoX9wgZsSgHlauVXg
kqaVE1CqT15QVJKmUyzQVF4wfSiQTpKmIRBVsZ+vCoBFnE5EKp8vgSaRZHYAcPNMwVCCaG9/IiZj
HpB6MF9CYS/vOTZxvyrlfagwAAAeADUQAQAAAD0AAAA8MDVEMzFERDM1Mjg1RDQ0ODg2MTBEOEMw
QzA4RjU5NjIwOTBCOTFAeXRjbWFpbC55b3JrdGVsLmNvbT4AAAAAHgBHEAEAAAAPAAAAbWVzc2Fn
ZS9yZmM4MjIAAAsA8hABAAAAHwDzEAEAAABwAAAAUgBFACUAMwBBACAAWwBtAGEAcABzAGUAcgB2
AGUAcgAtAHUAcwBlAHIAcwBdACAAbwByAGEAYwBsAGUAcwBwAGEAdABpAGEAbAAgAGMAbwBuAG4A
ZQBjAHQAIABlAHIAcgBvAHIALgBFAE0ATAAAAAsA9hAAAAAAQAAHMLGKLq4OvMEBQAAIMNOsrQgP
vMEBAwDeP+QEAAADAPE/CQAAAB4A+D8BAAAADQAAAFl1LUhzaW4gQ2hlbgAAAAACAfk/AQAAAFwA
AAAAAAAA3KdAyMBCEBq0uQgAKy/hggEAAAAAAAAAL089WU9SS1RFTC9PVT1GSVJTVCBBRE1JTklT
VFJBVElWRSBHUk9VUC9DTj1SRUNJUElFTlRTL0NOPVlDSEVOAB4A+j8BAAAAFQAAAFN5c3RlbSBB
ZG1pbmlzdHJhdG9yAAAAAAIB+z8BAAAAHgAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAAAAAAu
AAAAAwD9P+QEAAADABlAAAAAAAMAGkAAAAAAAwAdQAAAAAADAB5AAAAAAB4AMEABAAAABgAAAFlD
SEVOAAAAHgAxQAEAAAAGAAAAWUNIRU4AAAAeADJAAQAAABIAAABjYWJyYWxAeWFkYXRhLm5ldAAA
AB4AM0ABAAAAEgAAAGNhYnJhbEB5YWRhdGEubmV0AAAAHgA4QAEAAAAGAAAAWUNIRU4AAAAeADlA
AQAAAAIAAAAuAAAACwApAAAAAAALACMAAAAAAAMABhBSVJPFAwAHEOAFAAADABAQAAAAAAMAERAA
AAAAHgAIEAEAAABlAAAAV0VMTCxNWVBST0JMRU1JU1RIQVRUSEVEQVRBQkFTRUlTTk9UT05USEVM
T0NBTE1BQ0hJTkVJR1VFU1NJQ09VTERDUkVBVEVUSEVMT0NBTERBVEFCQVNFQU5EVEVTVElUT1VU
SQAAAAACAX8AAQAAAD0AAAA8MDVEMzFERDM1Mjg1RDQ0ODg2MTBEOEMwQzA4RjU5NjIwOTBCOTFA
eXRjbWFpbC55b3JrdGVsLmNvbT4AAAAAVWk=

------_=_NextPart_001_01C1BC0F.08A8E81F--