OGR connection for LINUX

[Bart van den Eijnden]

Hi Frank,

this thread reminded me of a question I wanted to ask, is there a similar way to connect to DBF files with additional attribute information using OGR? Which works both on Windows and Linux? Or would that require a new driver?

Best regards,
Bart

Bart van den Eijnden
Syncera-ITSolutions
Postbus 270
2600 AG  DELFT

tel.nr.: 015-7512436
email: BEN at Syncera-ITSolutions.nl

>>> Frank Warmerdam <fwarmerdam at GMAIL.COM> 05/04/05 04:35pm >>>
On 5/4/05, joÿffffffffffe3o Antunes <bluetuna_goes_skying at yahoo.co.uk> wrote:
> Now the challenge is: I am transfering this system to LINUX environment and
> as far as could get so far I still have to use an ODBC connection... is this
> true? I mean beeing in LINUX environment souldn't I be able to make a direct
> connection between mapserver an MySQL without having to use a windows native
> technology? 
> 
> I am afraid I might be making things more complex than they could be.. 
> 
> thanks in advance for any tips. 

Joao, 

On Linux (or windows for that matter) you can access MySQL either
via ODBC or via a direct MySQL connection depending on how your
package is built.  The direct MySQL driver is minimally documented at:

  http://www.gdal.org/ogr/drv_mysql.html 

I find it easier to build OGR directly against MySQL and use that
instead of ODBC on Linux where ODBC can be pretty hairy.  

Note that in your example you were using a shapefile.  That 
configuration should work fine on Linux too. 

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    | Geospatial Programmer for Rent