OGR ODBC spatial query has invalid resultset

[Eijnden, Bart van den (AGI)]

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.
************************************************************************