Olá
Sem ter muita certeza (uma vez que setrata de ligação ao MSSQL e não
POSTGIS) mas acho que na linha
DATA "geometry from lic_2004"
Há que ter o comando : using unique GID
Em que GID é o campo chave da tabela.
Stelmo
2. erro na conec??o ao sql server (Lisete Vieira)
Message: 2
Date: Tue, 18 Aug 2009 16:19:59 +0100
From: Lisete Vieira <[email protected]>
Subject: [Portugal] erro na conec??o ao sql server
To: [email protected], [email protected]
Message-ID:
<[email protected]>
Content-Type: text/plain; charset="iso-8859-1"
Boa tarde,
Tenho uma duvida ao tentar usar SQL server no MAPSERVER.
Consigo efectuar a connection mas no parametro DATA dá o seguinte erro:
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]: msMSSQL2008LayerOpen(): Could not parse the layer data in
C:\ms4w\apps\WebGis_PHP\htdocs\codigo.php on line 40 Warning: [MapServer
Error]: msMSSQL2008LayerParseData(): No primary key defined for table, or
primary key contains more that one column Error with MSSQL2008 data
variable. You specified 'lic_2004'.
Standard ways of specifiying are :
(1) 'geometry_column from geometry_table'
(2) 'geometry_column from (<sub query>) as foo using unique <column name>
using SRID=<srid#>'
Make sure you utilize the 'using unique <column name>' and 'using with
<index name>' clauses in.
For more help, please see http://www.mapdotnet.com
mapmssql2008.c - version of 2007/7/1. in
C:\ms4w\apps\WebGis_PHP\htdocs\codigo.php on line 40 Warning: [MapServer
Error]: msMSSQL2008LayerRetrievePK(): Error executing MSSQL2008 statement
(msMSSQL2008LayerRetrievePK():SELECT convert(varchar(50), sys.columns.name)
AS ColumnName, sys.indexes.name FROM sys.columns INNER JOIN sys.indexes
INNER JOIN sys.tables ON sys.indexes.object_id = sys.tables.object_id INNER
JOIN sys.index_columns ON sys.indexes.object_id =
sys.index_columns.object_id AND sys.indexes.index_id =
sys.index_columns.index_id ON sys.columns.object_id =
sys.index_columns.object_id AND sys.columns.column_id =
sys.index_columns.column_id WHERE (sys.indexes.is_primary_key = 1) AND (
sys.tables.name = N'lic_2004') 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
Como posso aceder a uma tabela em em SQL de forma a ficar visivel a
geometria no map server?
Criei a seguinte Layer:
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 lic_2004"
NAME "Lic_2004"
STATUS ON
TRANSPARENCY 100
TYPE POLYGON
UNITS METERS
CLASS
STYLE
COLOR 210 200 190
OUTLINECOLOR 195 212 157
END
END
END
Dá o erro acima indicado.
Obrigado
Lisete Vieira
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.osgeo.org/pipermail/portugal/attachments/20090818/98e03ea6/attachment-0001.html
------------------------------
_______________________________________________
Portugal mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/portugal
End of Portugal Digest, Vol 17, Issue 23
****************************************
_______________________________________________
Portugal mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/portugal
