[GRASSLIST:9602] Re: Using unixODBC to connect GRASS to MySQL

[Paolo Cavallini]

Hi all.
Just for you to know: we're planning to sponsor the development of a direct 
MySQL driver for GRASS, so hopefully the issue will be solved soon.
If somebody need this functionality, additional sponsorship would be welcomed.
pc

At 00:01, giovedì 22 dicembre 2005, William Kyngesburye has probably written:
> I believe the MySQL ODBC connector binary is meant for iODBC as
> provided by Apple in the system.  GRASS uses UnixODBC.
>
> GRASS can be made to use iODBC instead - I think the ODBC API is
> standard.  I have built GRASS with iODBC instead of UnixODBC, but
> haven't tested it yet.  I have an installer that you can try (it
> would be nice to get some testing to see if this works):
>
> <http://www.kyngchaos.com/macosx/files/grass-6.1cvs.pkg.zip>
>
> This requires my Graphics Libs and GIS Libs installers from my site.
> It's the CVS from mid-November, I think.  It's sortof in preparation
> to releasing my own Mac OS X binaries - it's lacking a proper readme
> and license file.
>
> If you want to try building grass yourself with iODBC (unless you're
> using Lorenzo's binaries), try this: in configure change every
> instance of -lodbc to -liodbc (use case sensitive, whole words to
> avoid possibly damaging something else).  GRASS configure will now
> find iodbc and build that in.
>
>
> To configure iODBC for the MySQL connector, see the readme that comes
> with the MySQL connector - you use /Applications/Utilities/ODBC
> Administrator.app.  I haven't really gotten very far with this, so I
> can't help with the gorey details.
-- 
Paolo Cavallini
email+jabber: cavallini at faunalia.it
www.faunalia.it
Piazza Garibaldi 5 - 56025 Pontedera (PI), Italy   Tel: (+39)348-3801953