I'm having a problem with a relatively simple map file that works fine on an existing linux host but won't run on windows. In the map file, I'm joining a shape file to a mysql table to use joined attribute data for displaying polygons in different colors based on the attribute field (no x y or lat long columns). The map does not display, do I need to make my OGR connect differently?
Here's how I'm making the connection now (does not work on new server)
DATA "SELECT * FROM Drought_County a LEFT JOIN 'MYSQL:dbname,host=hostname,user=****,password=*********'.dm_20111011 b ON a.fips = b.id"
Again, the MySQL table has no spatial component, I just want the MySQL data to be joined with the attribute table of the shape file (dbf).
NC Division of Water Resources
[hidden email] 919-715-5425
*E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties.