<!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>