[Mapserver-users] [mapserver]virtual spatial data

Van Ulden, Joost jvanulde@nrcan.gc.ca
Thu, 27 May 2004 18:03:45 -0400


Try doing something like the following in your mapfile:

LAYER
  NAME OGRPoints
  TYPE POINT
  CONNECTIONTYPE OGR
  CONNECTION 
  
  '<OGRVRTDataSource>
       <OGRVRTLayer name="foo">
 
<SrcDataSource>ODBC:user_name/password@system_dsn,table_name</SrcDataSource>

         <SrcLayer>table_name</SrcLayer> 
        <GeometryType>wkbPoint</GeometryType> 
        <LayerSRS>WGS84</LayerSRS>
        <GeometryField encoding="PointFromColumns" x="story_x" y="story_y"/>

      </OGRVRTLayer>
  </OGRVRTDataSource>'

  DUMP TRUE # for WFS only
  DATA "foo" # this must be the same as your OGRVRTLayer name
  STATUS default
  CLASS
    SYMBOL 'circle'
    SIZE 25
    COLOR 255 0 0
  END
END

============================================ 
Joost van Ulden 
Programmer/Analyst 
Natural Resources Canada / Ressources naturelles Canada 
Geological Survey of Canada / Commission geologique du Canada 
101 - 605 Robson Street / 101 - 605 rue Robson 
Vancouver, B.C. / Vancouver (C.B.) 
V6B 5J3 
Office/Bureau:  604.666.7525 
fax/telecopieur: 604.666.1124 
jvanulde@nrcan.gc.ca 
============================================



-----Original Message-----
From: Chip Hankley [mailto:Chip.Hankley@rmtinc.com] 
Sent: Thursday, May 27, 2004 2:08 PM
To: jvanulde@nrcan.gc.ca
Subject: RE: [Mapserver-users] [mapserver]virtual spatial data


I know you didn't ask, but... since I'm having the same problem.

Works as expected when doing ogrinfo... but fails with MapServer (just like
Jenu's... same error).

chip

>>> "Van Ulden, Joost" <jvanulde@nrcan.gc.ca> 05/27/04 03:41PM >>>
Jenu, can you send me your ovf.  Please remove any usernames and passwords.
I have been doing this successfully with three different db's for the last
few months and may be able to help you.

Cheers,

============================================ 
Joost van Ulden 
Programmer/Analyst 
Natural Resources Canada / Ressources naturelles Canada 
Geological Survey of Canada / Commission geologique du Canada 
101 - 605 Robson Street / 101 - 605 rue Robson 
Vancouver, B.C. / Vancouver (C.B.) 
V6B 5J3 
Office/Bureau:  604.666.7525 
fax/telecopieur: 604.666.1124 
jvanulde@nrcan.gc.ca 
============================================



-----Original Message-----
From: Jenu Abraham [mailto:jenu_ab@hotmail.com] 
Sent: Thursday, May 27, 2004 11:57 AM
To: zak-ms@hoppsan.org 
Cc: mapserver-users@lists.gis.umn.edu 
Subject: [Mapserver-users] [mapserver]virtual spatial data


hi Zac,

*-i tried using the file dsn in win 2003 Small business Server-MS -SQL... It

didnt work with originfo

*-I checked the mapserver.exe using the dependency walker -------GDAL12.dll
Product version version - N/A ----------------------File ver - N/A
---------------------Linker Ver- 6.0 --------------------OS ver - 4.0
-------------------Subsystem ver - 4.0


Other thing u asked to check----

*-ogrinfo -ro config.ovf     -
           gave the output --
VRT successful 1: mylayer <point>

*- ogrinfo -ro config.ovf mylayer
           - gave the same output as with the command-   originfo 
virtual.ovf mylayer


hope this might help in figuring out where the problem lies..


thanks
jenu

_________________________________________________________________
Best Restaurant Giveaway Ever! Vote for your favorites for a chance to win 
$1 million! http://local.msn.com/special/giveaway.asp 

_______________________________________________
Mapserver-users mailing list
Mapserver-users@lists.gis.umn.edu 
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users 
_______________________________________________
Mapserver-users mailing list
Mapserver-users@lists.gis.umn.edu 
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users

Outgoing messages, along with any attachments, are scanned for viruses at
RMT prior to sending.
----------------------------------------------------------------------------
--
NOTICE--This email may contain confidential and privileged information 
for the sole use of the intended recipient.  Any review or distribution by
others is strictly prohibited.  If you are not the intended recipient,
please contact the sender immediately and delete all copies.
_______________________________________________
Mapserver-users mailing list
Mapserver-users@lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users