Fabio, the documentation is here:
http://www.gdal.org/ogr/drv_odbc.html Best regards, Bart -----Oorspronkelijk bericht----- Van: UMN MapServer Users List [mailto:[EMAIL PROTECTED] Fabio D'Ovidio Verzonden: woensdag 27 september 2006 10:15 Aan: [email protected] 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, [EMAIL PROTECTED] > 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 : [EMAIL PROTECTED] ******************************************************************************************** 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. ************************************************************************
