Re: [mapserver-users] Re: ODBC OGR MS SQL CONNECTION

ibrahimsaricicek wrote: I've changed like this CONNECTION " ODBC:webuser/webu...@mssql,AracView SELECT * FROM AracView wkbPoint " And result; msDrawMap(): Image handling error. Failed to draw layer named 'Araclar'. msOGRFileOpen(): OGR error. Ope

[mapserver-users] Re: ODBC OGR MS SQL CONNECTION

I've changed like this CONNECTION " ODBC:webuser/webu...@mssql,AracView SELECT * FROM AracView wkbPoint " And result; msDrawMap(): Image handling error. Failed to draw layer named 'Araclar'. msOGRFileOpen(): OGR error. Open failed for OGR connecti

[mapserver-users] Re: ODBC OGR MS SQL CONNECTION

Hi all, This now works, I've used * instead of listing columns.. SELECT * FROM MOBILEUNIT INNER JOIN MUGPSDATALOG ON MOBILEUNIT.MUID=MUGPSDATALOG.MUID WHERE MUGPSDATALOG.EVENTLOGID IN(SELECT MAX(EVENTLOGID) FROM MUFLEET INNER JOIN MUGROUP ON MUFLEET.FLEETID = MUGROUP.FLEETID INNER JOIN MOBILE

Re: [mapserver-users] ANGLE [attribute]

Daiane Azevedo de Fraga wrote: Hello everyone! I wonder if ANGLE accepts an attribute that comes from a table in a database, eg Oracle Spatial? Either he accepts only one attribute of a DBF? Yes, that should work for all connection types (but I didn't test oracle spatial specifically mysel

Re: [mapserver-users] ODBC OGR MS SQL CONNECTION

Some things to try: 1. Create a view in MS SQL to do most of SQL 2. List the view name in the SrcDataSource: ODBC:webuser/webu...@mssql,MyView so ogr/odbc/sqlserver doesn't have to enumerate all the db objects 3. Using means that GDAL/ogr/mapserver is not using any spatial indexing, and pote

Re: [mapserver-users] ODBC OGR MS SQL CONNECTION

ibrahimsaricicek wrote: This doesn't and syas; msDrawMap(): Image handling error. Failed to draw layer named 'Araclar'. msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `Araclar'. Parse error at EOF, not all elements have been closed, starting with SrcSQL CONNECTIONTYPE OGR

[mapserver-users] ANGLE [attribute]

Hello everyone! I wonder if ANGLE accepts an attribute that comes from a table in a database, eg Oracle Spatial? Either he accepts only one attribute of a DBF? Thanks! -- Daiane ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://li

[mapserver-users] ODBC OGR MS SQL CONNECTION

Dear all, This definition works, CONNECTIONTYPE OGR CONNECTION " ODBC:webuser/webu...@mssql SELECT TOP 10 * FROM MUGPSDATALOG wkbPoint " This doesn't and syas; msDrawMap(): Image handling error. Failed to draw layer named 'Araclar'. msOGRFileOpe

[mapserver-users] One-to-many JOIN works only on integer fields?

Hi list! I have a mapfile with a one-to-many JOIN, but PostgreSQL logs a syntax error whenever I query such an object on the map: - ERROR: syntax error at or near "_3" at character 333 STATEMENT: SELECT "codvia_num"::text, "cognome"::text, "nome"::text,