[Mapserver-users] [mapserver]virtual spatial data

[Van Ulden, Joost]

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 at 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 at nrcan.gc.ca 
============================================



-----Original Message-----
From: Chip Hankley [mailto:Chip.Hankley at rmtinc.com] 
Sent: Thursday, May 27, 2004 2:08 PM
To: jvanulde at 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 at 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 at nrcan.gc.ca 
============================================



-----Original Message-----
From: Jenu Abraham [mailto:jenu_ab at hotmail.com] 
Sent: Thursday, May 27, 2004 11:57 AM
To: zak-ms at hoppsan.org 
Cc: mapserver-users at 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 at lists.gis.umn.edu 
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users 
_______________________________________________
Mapserver-users mailing list
Mapserver-users at 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.