[Mapserver-users] Error: Oracle Connection String wrong?

[thelen at ccgis.de]

Hi,

Thanks for your incredible quick response and sorry for my late one :-)!
Basically the connection is working properly encapsulating the connection
string in quotes. But using Oracle seems to be a kind of miracle, at least
at the moment ;-).

Kind regards,

Benjamin Thelen

---------------------------------
CCGIS GbR - Bonn
http://www.ccgis.de

Siemensstraße 8
53121 Bonn
Germany

Tel: ++49 (0) 228 90826 15
Fax: ++49 (0) 228 90826 11



> Hi,
>
> Here's a part of my mapfile that works fine:
>
>   CONNECTIONTYPE oraclespatial
>   CONNECTION "usr/pwd at db"
>   DATA "GEOLOC FROM SCHEMA.TABLE USING SRID 82196"
>   FILTER "QTID=3425"
>
> Hope this help.
> Nicolas
>
> -----Message d'origine-----
> De : thelen at ccgis.de [mailto:thelen at ccgis.de]
> Envoyé : Wednesday, December 17, 2003 9:41 AM
> À : mapserver-users at lists.gis.umn.edu
> Objet : [Mapserver-users] Error: Oracle Connection String wrong?
>
>
> Hi,
>
> We try to connect to a Oracle Spatial 9.2010 with Win32 MapServer 4. But
> we
> get the following error, passing the capabilites-request
> http://Server-URL/scripts/mapserv.exe?map=d:/mapserver/oracle.map&request=ca
> pabilities&wmtver=1.0.0:
>
> loadLayer(): Unknown identifier. Parsing error near (@):(line 53)
>
> The according line 53 in the map-file is
>
> CONNECTION user/pass at db
>
> That is nearly (user/pass[@]) what I copied from the MapServer
> documentation.
>
> Connecting via sql+ (oracle client) with "user/pass at db" is running
> properly.
>
>
>
> Up to now I could not find any example connection string on the internet
> (google, user list), but I will continue to search. As this is a quite
> urgent matter, I additionally post this e-mail!
>
>
> Thank you very much for any help!!
>
>
> Benjamin Thelen
>
> ---------------------------------
> CCGIS GbR - Bonn
> http://www.ccgis.de
>
> Siemensstraße 8
> 53121 Bonn
> Germany
>
> Tel: ++49 (0) 228 90826 15
> Fax: ++49 (0) 228 90826 11
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
>