[Portugal] mapserver, erro de sql server

[Lisete Vieira]

Warning: [MapServer Error]: msDrawMap(): Failed to draw layer named
'Lic_2004'. in C:\ms4w\apps\WebGis_PHP\htdocs\codigo.php on line 40 Warning:
[MapServer Error]: msMSSQL2008LayerGetShape(): Error executing MSSQL2008 SQL
statement: SELECT Geometry.STAsBinary(),convert(varchar(20), ID2) from
(select geometry, ID2 from lic_2004) as foo WHERE
Geometry.STIntersects(Geometry::STGeomFromText('POLYGON((-68546.6828046745
12158,-28519.3171953255 12158,-28519.3171953255 42166,-68546.6828046745
42166,-68546.6828046745 12158))',0)) = 1 -[Microsoft][ODBC SQL Server
Driver][SQL Server]Line 1: Incorrect syntax near 'Geometry:'. in
C:\ms4w\apps\WebGis_PHP\htdocs\codigo.php on line 40 Fatal error: Call to a
member function saveWebImage() on a non-object in
C:\ms4w\apps\WebGis_PHP\htdocs\codigo.php on line 42


No codigo alterei o campo DATA da seguinte forma:

LAYER
 METADATA
        "DESCRIPTION" "TESTE DE LIGAÇÃO A BD"
    END
    CONNECTIONTYPE PLUGIN
 PLUGIN "C:/ms4w/Apache/specialplugins/msplugin_mssql2008.dll"
 CONNECTION "server=***;uid=***;pwd=***;database=SIG; Integrated
Security=false"
 DATA "Geometry from (select geometry, ID2 from lic_2004) as foo using
unique ID2"
 NAME "Lic_2004"
   STATUS ON
    TRANSPARENCY 100
    TYPE POLYGON
    UNITS METERS
    CLASS
      STYLE
        COLOR 210 200 190
        OUTLINECOLOR 195 212 157
      END
    END

Será que podes enviar para ver se alguem responde?

Atentamente

Lisete Vieira
-------------- próxima parte ----------
Um anexo em HTML foi limpo...
URL: http://lists.osgeo.org/pipermail/portugal/attachments/20090819/bc8f0c02/attachment-0001.html