Apologies all, one last question...
To retrieve attributes from MS SQL I thought something like the following
would work:
DATA "SitePoint1 from (select SiteID,SitePoint1,SiteName from Site) USING
UNIQUE SiteID USING SRID=4326"
However, the layer fails to draw. Am I in need of a newer MSSQL2008 dr
Fixed it in the end.
PLUGIN "C:\..\...\msplugin_mssql2008.dll"
CONNECTION "server=x;uid=;pwd=xx;database=x;Integrated
Security=false"
What is odd is I can only get a geometry type to work, my driver is dated
Jan-10, maybe pre-geography datatype support - all I can think of.
DA