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

[Michael Schulz]

Hi,

did you try encapsulating the connection string in quotes? I can confirm 
that you have to use CONNECTION "scott/tiger at db_sid" and CONNECTIONTYPE 
oraclespatial.

This worked for me on with mapserver 4, win2000 and Oracle 8.1.7.

I experienced another error with an oracle 9.2 client, in that the 
syntax of the db_sid has changed (or more specific when creating the 
listener the name of the client was added automatically). Can someone 
confirm this?

HTH, Michael


thelen at ccgis.de schrieb:

> 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=capabilities&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
> 

-- 
-----------------------------------------------------------
Michael Schulz                                in medias res
Dipl.-Geologe                              Gesellschaft für
                                 Informationstechnologie mbH
                                      In den Weihermatten 66
		                             79108 Freiburg
                                      0761 55695-95 (Fax 96)
mschulz at webgis.de              www.webgis.de/www.zopecms.de