OGR ODBC spatial query has invalid resultset

[Fabio D'Ovidio]

OK. the CONNECTION works fine !

My problem now is The CGI timeout because my VIEW has a large number of records.

How can I do to sovle this ?

Thanks !


On 27 Sep 2006 at 10:17, Eijnden, Bart van den (AGI) wrote:

> Fabio,
> 
> the documentation is here:
> 
> http://www.gdal.org/ogr/drv_odbc.html
> 
> Best regards,
> Bart
> 
> -----Oorspronkelijk bericht-----
> Van: UMN MapServer Users List
> [mailto:MAPSERVER-USERS at LISTS.UMN.EDU]Namens Fabio D'Ovidio
> Verzonden: woensdag 27 september 2006 10:15
> Aan: MAPSERVER-USERS at LISTS.UMN.EDU
> Onderwerp: Re: [UMN_MAPSERVER-USERS] OGR ODBC spatial query has invalid
> resultset
> 
> 
> Frank Thank you very much for help !
> 
> I need a reference about documentation to find the option that you sad me to consider Views 
> as Tables.
> 
> I have found the same problem here (but for MySQL DBMS) :
> 
> http://www.nabble.com/-UMN_MAPSERVER-USERS--OGR-with-SELECT-%2B-INNER-
> JOIN--using--MS-SQL-views---p1259454.html
> 
> But there is no described  solution .
> 
> 
> Could you say me a link about reference ?
> 
> 
> On 26 Sep 2006 at 13:59, Frank Warmerdam wrote:
> 
> > Fabio D'Ovidio wrote:
> > > Thank u ! I 'll try with this !
> > > 
> > > I have another problem. My table is a VIEW and It seems that OGR SQL doesn't connect to 
> > > VIEWS but only connects to Tables
> > > 
> > > Is it true ?
> > 
> > Fabio,
> > 
> > I believe that views will not by default be treated as layers.  But the
> > ODBC connection strings for OGR include an option for a comma delimited
> > list of "tables" at the end and I think this can include a named view
> > which will then be treated as a layer within OGR.
> > 
> > I apologize for this all being a bit hacky, and my memory weak.  It seems
> > like the ODBC driver could be a full time occupation it gets used in so
> > many ways by different people.  But I don't use it myself very often so it
> > hard for me to keep track of all the details.
> > 
> > Best regards,
> > -- 
> > ---------------------------------------+--------------------------------------
> > I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
> > light and sound - activate the windows | http://pobox.com/~warmerdam
> > and watch the world go round - Rush    | President OSGeo, http://osgeo.org
> 
> 
> ********************************************************************************************
> 
> 
>  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
> 
> ********************************************************************************************
> 
> 
> Disclaimer
> ************************************************************************
> Aan dit bericht kunnen geen rechten worden ontleend. Dit bericht is
> uitsluitend bestemd voor de geadresseerde. Als u dit bericht per abuis
> hebt ontvangen, wordt u verzocht het te vernietigen en de afzender te
> informeren. Wij adviseren u om bij twijfel over de juistheid of de
> volledigheid van de mail contact met afzender op te nemen.
> 
> This message shall not constitute any rights or obligations.
> This message is intended solely for the addressee.
> If you have received this message in error, please delete it and
> notify the sender immediately. When in doubt whether this message
> is correct or complete, please contact the sender.
> ************************************************************************
> 


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


 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

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