<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>MS4W/CHAMELEON/Virtual Spatial Data (odbc/ovf) - Only works on my PC</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hello All,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Let me describe my situation.</FONT>
<BR><FONT SIZE=2 FACE="Arial">I'm running MS4W and Chameleon for MapServer on my pc.</FONT>
<BR><FONT SIZE=2 FACE="Arial">I used </FONT><A HREF="http://mapserver.gis.umn.edu/docs/reference/vector_data/VirtualSpatialData"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://mapserver.gis.umn.edu/docs/reference/vector_data/VirtualSpatialData</FONT></U></A>
<BR><FONT SIZE=2 FACE="Arial">To create the connection etc..</FONT>
<BR><FONT SIZE=2 FACE="Arial">My .ovf file is also on my c:\</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I have an MS access data base with a command button called "Stations" which exports a .csv file to my/or anyone elses C:\ based on a query. The query dumps name, latitude and longitude into a .csv file. - This works great.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Following this event, a browser is opened which displays:</FONT>
<BR><A HREF="http://localhost/myapp/index.phtml"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://localhost/myapp/index.phtml</FONT></U></A>
<BR><FONT SIZE=2 FACE="Arial">Which maps BASED on my newly created .csv file.</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">I.E. The map looks different based on what you have queried in MS ACCESS.</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">Here is my problem.</FONT>
<BR><FONT SIZE=2 FACE="Arial">When I do all of this on my pc (where everything is setup) it WORKS GREAT.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">If I send the database to a collegues computer, and they click button "Stations", the map is produced based on the .csv ON MY computer.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">For example if they do a new query and click the button, it still produces the .csv on my c:\</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">How do I get it so that the newly exported .csv is reflected on ANYONE's PC.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Do I make the change in ogrinfo? .map file? FWTools Shell? My .ovf file?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Here is my .ovf file</FONT>
<BR><FONT SIZE=2 FACE="Arial"><OGRVRTDataSource></FONT>
<BR><FONT SIZE=2 FACE="Arial"> <OGRVRTLayer name="stations"></FONT>
<BR><FONT SIZE=2 FACE="Arial"> <SrcDataSource>ODBC:rcs_stations</SrcDataSource></FONT>
<BR><FONT SIZE=2 FACE="Arial"> <SrcLayer>sta.csv</SrcLayer></FONT>
<BR><FONT SIZE=2 FACE="Arial"> <GeometryField encoding="PointFromColumns" x="LATITUDE_DECIMAL_DEGREES" y="LONGITUDE_DECIMAL_DEGREES"/></FONT>
<BR><FONT SIZE=2 FACE="Arial"> <GeometryType>wkbPoint</GeometryType></FONT>
<BR><FONT SIZE=2 FACE="Arial"> </OGRVRTLayer></FONT>
<BR><FONT SIZE=2 FACE="Arial"></OGRVRTDataSource></FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">Any help would be appreciated,</FONT>
<BR><FONT SIZE=2 FACE="Arial">Bruce Persaud</FONT>
</P>
<BR>
<BR>
<BR>
<BR>
</BODY>
</HTML>