[Mapserver-users] virtual spatial data
Jenu Abraham
jenu_ab at hotmail.com
Wed May 26 13:39:39 EDT 2004
I have tried what u had said Paul ...it didnt work...
I even went ahead and loaded mapserver 4.2b3-win32-pho4.3.4 binaries but it
didnt work
I have a doubt? ...do i have to use php or mapscript to use these
binaries?..as i'm not..
i was thinking is there something i have to set ODBC driver enviornmental
variables..if yes how?
again i'm using windows 2003 server- & MS SQL server
greatly appretiate any help
:) jenu
--------------------------------------------------------------------------------------------
>From: Paul Spencer <pagameba at magma.ca>
>Reply-To: spencer at dmsolutions.ca
>To: Jenu Abraham <jenu_ab at hotmail.com>
>CC: mapserver-users at lists.gis.umn.edu
>Subject: Re: [Mapserver-users] virtual spatial data
>Date: Wed, 26 May 2004 13:06:32 -0400
>
>nothing seems obviously wrong. A couple of things to try:
>
>* SrcLAYER -> SrcLayer ... I'd be suprised it if was case-sensitive, but
>you never know ;)
>
>* <SrcDataSource>ODBC:sa at localserver</SrcDataSource> or
> <SrcDataSource>ODBC:localserver</SrcDataSource> - my idea here is that
>the / is possibly an invalid character inside an XML element? And the
>parsing may not be handled the same way between ogrinfo and mapserver
>because of the inclusion of xerces in mapserver? Just a wild guess on this
>one ..
>
>Cheers,
>
>Paul
>
>Jenu Abraham wrote:
>>hi,
>>I'm using windows 2003 server with mapserver-4.1-dev-win32-php4.3.4
>>binaries (This is precompiled with GDAL)
>>i have loaded the gdal12.dll in the winnt/system folder
>>
>>and the testing2.ovf file works perfect with ogrinfo
>>
>>I have tried to run it in the inline connection mode and the file
>>connection mode...
>>when i run mapserver i get this error listed below- I cant figure out
>>whats wrong-
>>
>>the error with the inline connection string- (inside mapfile- commented
>>out in the source below)
>>--------------------------------------
>>msDrawMap(): Image handling error. Failed to draw layer named 'trucks'.
>>msOGRFileOpen(): OGR error. Open failed for OGR connection `
>>ODBC:sa/@localserver latlong wkbPoint WGS84 '. File not found or
>>unsupported format.
>>---------------------------------------
>>
>>------------------------------------------
>>
>>The error with the connection in the testing.ovf file
>>--------------------------------------
>>msDrawMap(): Image handling error. Failed to draw layer named 'trucks'.
>>msOGRFileOpen(): OGR error. Open failed for OGR connection
>>`C:\cgi-bin\testing2.ovf'. File not found or unsupported format.
>>
>>$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
>>testing2.ovf
>>$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
>><OGRVRTDataSource>
>><OGRVRTLayer name="mylayer">
>><SrcDataSource>ODBC:sa/@localserver</SrcDataSource>
>><SrcLAYER>latlong</SrcLAYER>
>><GeometryType>wkbPoint</GeometryType>
>><LayerSRS>WGS84</LayerSRS>
>><GeometryField encoding="PointFromColumns" x="x" y="y"/>
>></OGRVRTLayer>
>></OGRVRTDataSource>
>>$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
>>
>>@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
>>mapfile
>>@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
>>MAP
>> NAME e-test-rd-jbox_
>> IMAGETYPE GIF
>> EXTENT -2236857.50 -1744057.00 2786329.50 29069.36
>>
>> SIZE 800 600
>> SHAPEPATH "C:\cgi-bin\data\"
>>
>> FONTSET "C:\cgi-bin\fonts\fonts.list"
>>
>> WEB
>> TEMPLATE 'e-test-rd-jbox.html'
>> IMAGEPATH 'C:\cgi-bin\tmp\'
>> IMAGEURL '/tmp/'
>> END
>>
>> PROJECTION
>> "init=epsg:2163"
>> END
>>
>>
>> LAYER # States polygon layer begins here
>> NAME states
>> DATA statesp020
>> STATUS DEFAULT
>> TYPE POLYGON
>>
>> PROJECTION
>> "init=epsg:4326"
>> END
>> CLASS
>> COLOR 240 240 100
>> END
>> END # States polygon layer ends here
>>
>>LAYER # start of truck position from database
>> NAME trucks
>> TYPE POINT
>> CONNECTIONTYPE OGR
>> CONNECTION "C:\cgi-bin\testing2.ovf" # file connection
>> #CONNECTION '<OGRVRTDataSource> # inline connection
>> # <OGRVRTLayer name="mylayer">
>> # <SrcDataSource>ODBC:sa/@localserver</SrcDataSource>
>> # <SrcLAYER>latlong</SrcLAYER>
>> # <GeometryType>wkbPoint</GeometryType>
>> # <LayerSRS>WGS84</LayerSRS>
>> # <GeometryField encoding="PointFromColumns" x="x" y="y"/>
>> # </OGRVRTLayer>
>> # </OGRVRTDataSource>'
>> DATA "mylayer"
>> STATUS DEFAULT
>> #LABELITEM latlong.name
>> PROJECTION
>> "init=epsg:4326"
>> END
>> CLASS
>> SYMBOL 1
>> SIZE 6
>> COLOR 255 0 0
>> #LABEL
>> # SIZE MEDIUM
>> # TYPE BITMAP
>> # COLOR 0 0 0
>> #END
>> END
>>
>>END # end of connection layer
>>
>> # End of LAYER DEFINITIONS
>>END # end of map file
>>
>>@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
>>
>>
>>Jenu
>>
>>_________________________________________________________________
>>Watch LIVE baseball games on your computer with MLB.TV, included with MSN
>>Premium! http://join.msn.click-url.com/go/onm00200439ave/direct/01/
>>
>>_______________________________________________
>>Mapserver-users mailing list
>>Mapserver-users at lists.gis.umn.edu
>>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>
>
>--
> -----------------------------------------------------------------
>|Paul Spencer pspencer at dmsolutions.ca |
>|-----------------------------------------------------------------|
>|Applications & Software Development |
>|DM Solutions Group Inc http://www.dmsolutions.ca/|
> -----------------------------------------------------------------
>
_________________________________________________________________
Stop worrying about overloading your inbox - get MSN Hotmail Extra Storage!
http://join.msn.click-url.com/go/onm00200362ave/direct/01/
More information about the mapserver-users
mailing list