mapjoin : msPOSTGRESQLJoinClose & Fastcgi & OGR ODBC Connection

Fabio D'Ovidio dovidio at PLANETEK.IT
Thu Sep 28 01:14:09 PDT 2006


I have set isapi_fcgi.dll for IIS and I have choose a mapserver version with FASTCGI 
support.

I have done the following external connection with OGR ODBC to SQL Server :

LAYER
  NAME "pug2_iffi"
  TYPE POINT
  STATUS ON
  TEMPLATE  "query.html"
  TOLERANCEUNITS  PIXELS
  TOLERANCE 1000
  CLASS
    NAME "Pug2_iffi"
    # TEMPLATE
    STYLE
    SYMBOL  "circlefd"
    SIZE 7
    COLOR  127 255 0  
    OUTLINECOLOR 0 0 0
   END
  END
  PROJECTION
		#Lat/Lon
		"init=EPSG:32633"
	END
	CONNECTIONTYPE OGR
  CONNECTION "pug_iffi.shp"
 DATA "SELECT * from pug_iffi c LEFT JOIN 
'ODBC:swra at CartaewnetIFFI,Query_prova_IdFrana'.Query_prova_IdFrana b ON 
c.IDFRANA = b.IDFRANA"
   
  PROCESSING "CLOSE_CONNECTION=DEFER"
  
  END


There are two type of problems :

one :

I have Timeout error of CGI again even if  FASTCGI is activated. I think the problem is that 
SQL SERVER with OGR ODBC Connection downloads all of the records in the table I need 
and after it makes SQL SELECT.


two :

If I try to do this in the Layer Object :

...
DATA "SELECT id from 'ODBC:sa at CartanetIFFI,Query_IdFrana'.Query_IdFrana WHERE 
subid = 04"
....

or :

...
DATA "SELECT IDFRANA from pug_iffi c"
...

I have the following error with a simple GetFeatureInfo Request :

GetFeatureInfo results:

  Search returned no results.
msPOSTGRESQLJoinClose() already close or never opened.
msPOSTGRESQLJoinClose() already close or never opened.

"Search returned no results" it's OK for me because the table is not 
a Geometry, but Why I have "msPOSTGRESQLJoinClose()" ERROR if my 
connection is to DBF or to SQL Server ??


I'd like to know how can download ONLY the Selection in my SQL 
Server without problem with TIMEOUT CGI (with or without FASTCGI 
support ? )




Thank you very much !


********************************************************************************************


 Ing. Fabio D'Ovidio
 WebGIS Staff
 Planetek Italia Srl
 via Massaua, 12 - 70123 Bari - Italy
 web : http ://www.planetek.it
 e-mail : dovidio at planetek.it

********************************************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060928/787bd9ff/attachment.htm>
-------------- next part --------------
The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.

   ---- File information -----------
     File:  planetek.gif
     Date:  28 Feb 2006, 16:15
     Size:  1899 bytes.
     Type:  Unknown
-------------- next part --------------
A non-text attachment was scrubbed...
Name: planetek.gif
Type: application/octet-stream
Size: 1899 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060928/787bd9ff/attachment.obj>


More information about the MapServer-users mailing list