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:[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. > ************************************************************************ > ******************************************************************************************** Ing. Fabio D'Ovidio WebGIS Staff Planetek Italia Srl via Massaua, 12 - 70123 Bari - Italy web : http ://www.planetek.it e-mail : [EMAIL PROTECTED] ********************************************************************************************
