[Mapserver-users] virtual spatial data

[Jenu Abraham]

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/