<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head>
<title></title>
<meta http-equiv="content-type" content="text/html;charset=utf-8"/>
<meta http-equiv="Content-Style-Type" content="text/css"/>
</head>
<body>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
I have set isapi_fcgi.dll for IIS and I have choose a mapserver version with FASTCGI
support.</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
I have done the following external connection with OGR ODBC to SQL Server :</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
LAYER</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
  NAME "pug2_iffi"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
  TYPE POINT</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
  STATUS ON</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
  TEMPLATE  "query.html"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
  TOLERANCEUNITS  PIXELS</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
  TOLERANCE 1000</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
  CLASS</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
    NAME "Pug2_iffi"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
    # TEMPLATE</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
    STYLE</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
    SYMBOL  "circlefd"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
    SIZE 7</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
    COLOR  127 255 0  </span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
    OUTLINECOLOR 0 0 0</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
   END</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
  END</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
  PROJECTION</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
                        #Lat/Lon</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
                        "init=EPSG:32633"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
            END</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
            CONNECTIONTYPE OGR</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
  CONNECTION "pug_iffi.shp"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
 DATA "SELECT * from pug_iffi c LEFT JOIN
'ODBC:swra@CartaewnetIFFI,Query_prova_IdFrana'.Query_prova_IdFrana b ON
c.IDFRANA = b.IDFRANA"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
   </span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
  PROCESSING "CLOSE_CONNECTION=DEFER"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
  </span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
  END</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
There are two type of problems :</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
one :</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
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.</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
two :</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
If I try to do this in the Layer Object :</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
...</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
DATA "SELECT id from 'ODBC:sa@CartanetIFFI,Query_IdFrana'.Query_IdFrana WHERE
subid = 04"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
....</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
or :</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
...</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
DATA "SELECT IDFRANA from pug_iffi c"</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
...</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
I have the following error with a simple GetFeatureInfo Request :</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Courier New" size="2">
<span style=" font-size:10pt">
GetFeatureInfo results:</span></font>
</div>
<div align="left">
<font face="Courier New" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Courier New" size="2">
<span style=" font-size:10pt">
  Search returned no results.</span></font>
</div>
<div align="left">
<font face="Courier New" size="2">
<span style=" font-size:10pt">
msPOSTGRESQLJoinClose() already close or never opened.</span></font>
</div>
<div align="left">
<font face="Courier New" size="2">
<span style=" font-size:10pt">
msPOSTGRESQLJoinClose() already close or never opened.</span></font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Courier New" size="2">
<span style=" font-size:10pt">
"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 ??</span></font>
</div>
<div align="left">
<font face="Courier New" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Courier New" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Courier New" size="2">
<span style=" font-size:10pt">
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 ? )</span></font>
</div>
<div align="left">
<font face="Courier New" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Courier New" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Courier New" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Courier New" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Courier New" size="2">
<span style=" font-size:10pt">
Thank you very much !</span></font>
</div>
<div align="left">
<font face="Courier New" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
********************************************************************************************</span></font>
</div>
<div align="left"><img src="cid:3846350.1159438450.16498" width="89" height="36" border="0" alt="graphic"/>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
<b><br />
</b>
</span>
</font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
<b> Ing. Fabio D'Ovidio</b></span></font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
 WebGIS Staff</span></font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
 Planetek Italia Srl</span></font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
 via Massaua, 12 - 70123 Bari - Italy</span></font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
 web : </span></font>
<font face="Comic Sans MS" color="#0000ff" size="2">
<span style=" font-size:10pt">
http ://www.planetek.it</span></font>
</div>
<div align="left">
<font face="Comic Sans MS" size="2">
<span style=" font-size:10pt">
 e-mail : </span></font>
<font face="Comic Sans MS" color="#0000ff" size="2">
<span style=" font-size:10pt">
dovidio@planetek.it</span></font>
</div>
<div align="left">
<font face="Comic Sans MS" color="#0000ff" size="2">
<span style=" font-size:10pt">
<br />
</span>
</font>
</div>
<div align="left">
<font face="Arial" size="2">
<span style=" font-size:10pt">
********************************************************************************************</span></font>
</div>
</body>
</html>