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

[Dylan Beaudette]

On Dec 21, 2005, at 11:56 PM, Paolo Cavallini wrote:

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


I'm Interested.


--
Dylan Beaudette
Soils and Biogeochemistry Graduate Group
University of California at Davis
530.754.7341