MS SQL SPATIAL- MAPSERVER FAILURE CONNECTION

Carlos A. Gordon cagb78 at YAHOO.COM
Wed May 16 15:50:20 PDT 2007


Hi, i'm carlos, and recently i start use MS SQL SPATIAL, before i always 
shapefiles as my primary source for mapserver, now I'm trying to generate a 
map using Mapserver and MS SQL Spatial... i try to make
a connection with ODBC Virtual Directory (.ovf)... i follow the instructions 
presented
in mapserver and mssqlspatial discussions and forums, but nothing seems to 
work properly
1. I create a system dsn, using Sql native cliente (SPATIALSQL)
2. Later i tested using ogrinfo

C: \> ogrinfo ODBC: spatialsql

That give a result a list of the all tables in the database...

Later i tested this:

C: \> ogrinfo ODBC: spatialsql parque_pt

the result is a list with all the data in the table...

3. I create an ovf file to make a call to database and put into a new folder in 
my ms4w installation
C:\ms4w\apps\metro\DBCONNECTION\virtual.ovf
virtual.ovf
##################
<OGRVRTDataSource>
<OGRVRTLayer name="parque">
<SrcDataSource>ODBC:@spatialsql</SrcDataSource>
<SrcLayer>parque_pt</SrcLayer>
<GeometryField encoding="WKB" field="the_geom"/>
</OGRVRTLayer>
</OGRVRTDataSource>
###############################

4. I run the ogrinfo to test the virtual.ovf
This is the result...

C:\> ogrinfo virtual.ovf
FAILURE:
Unable to open datasource `virtual.ovf' with the following drivers.
-> ESRI Shapefile
-> MapInfo File
-> UK .NTF
-> SDTS
-> TIGER
-> S57
-> DGN
-> VRT
-> AVCBin
-> REC
-> Memory
-> CSV
-> GML
-> KML
-> SQLite
-> ODBC
-> PGeo
-> PostgreSQL
-> MySQL

This is my .map....
MAP
NAME "METROTEST"
ANGLE 0
IMAGETYPE PNG
EXTENT -79.64 8.89 -79.29 9.17
UNITS METERS 
SIZE 900 500 
SHAPEPATH "../DBCONNECTION/virtual.ovf"
SYMBOLSET "../etc/symbols.sym"
FONTSET "../etc/fonts.txt"
IMAGECOLOR 222 254 251
TRANSPARENT Off
RESOLUTION 100

WEB
TEMPLATE 'C:/ms4w/apps/metro/template/main.html'
IMAGEPATH 'C:/ms4w/tmp/ms_tmp/'
IMAGEURL '/ms_tmp/'
METADATA
wms_title "Servidor de la Ciudad de Panamá"
wms_onlineresource "http://localhost/cgi-bin/mapserv.exe?
map=/ms4w/apps/metro/map/metrotest.map&mode=map"
wms_srs "EPSG:4326 EPGS:32617"
wms_abstract "Este es un servicio de información geoespacial de la ciudad de 
Panamá. El mismo incluye cartografía base (calles, área urbana, lagos, zonas 
verdes, aeropuerto) para generar un mapa a escalas 1:1000k a 1:50k. Los 
datos fueron proporcionados por Geobis Internacional." 
END
END

OUTPUTFORMAT
NAME png
DRIVER "GD/PNG"
MIMETYPE "image/png"
IMAGEMODE PC256
EXTENSION "png"
END

PROJECTION
"init=epsg:4326"
END

LEGEND
KEYSIZE 10 10
IMAGECOLOR 255 255 255
STATUS embed
POSTLABELCACHE TRUE
POSITION LL
LABEL
TYPE TRUETYPE
FONT ARIAL
SIZE 8
COLOR 0 0 89
END
END

LAYER
NAME "parques"
TYPE POINT
CONNECTIONTYPE OGR
CONNECTION "C:/ms4w/apps/metro/DBCONNECTION/virtual.ovf"
DATA "parque"
STATUS DEFAULT
UNITS METERS
SIZEUNITS PIXELS
TOLERANCE 0
TOLERANCEUNITS PIXELS
END
END

CLASS
NAME "parks"
STYLE
COLOR 255 0 0
SIZE 6
SYMBOL "star"
END
END
END

When i call from browser, mapserver give me this message...

msDrawMap(): Image handling error. Failed to draw layer named 'parques'. 
msOGRFileOpen(): OGR error. Open failed for OGR connection 
`C:/ms4w/apps/metro/DBCONNECTION/virtual.ovf'. File not found or 
unsupported format. 

I have look through several forums and list and seems that's a very common 
problem, altougth i haven't found a solution yet... so any help it's 
welcome...
i'm working with MS Sql Server 2005 y MS Sql spatial, Apache and ms4w 
version 2.2.2

Thanxs a lot

Carlos 



More information about the MapServer-users mailing list