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.
DATA
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