Hello Andrew,
the error was possibly caused by an old iODBC release.
Please, consider the proposal by Marius to allow specifying the path to
the include files for MySQL (and iODBC) when calling configure.
Best regards
Xypron
Marius Schamschula wrote:
Thanks a lot!
This was most strange, since the previous version of glpk had
worked out of the box:
1)
I wasn't aware that it had picked up the (now) obsolete version of
iODBC from the OS install. Since I don't need these drivers and don't
plan on updating them under 10.3.9, I used --disable-odbc for the
10.3.9 build.
2) I enabled mysql support by
adding: CPPFLAGS=-I/usr/local/mysql/include
LDFLAGS=-L/usr/local/mysql/lib. It would be nice to be able to pass a
--with-mysql=/usr/local configure argument instead.
Now glpk builds correctly on all versions of Mac OS X that I
support (10.3.9 - 10.5.2).
On May 9, 2008, at 11:27 AM, Xypron wrote:
Hello Marius,
looking at config.h I read:
#define ODBC_DLNAME "libiodbc.so"
/* #undef MYSQL_DLNAME */
Obviously the package iODBC was detected during "configure". MySQL was
not. Hence after successful compilation you will end up with a library
and a glpsol which can access MySQL only via ODBC (e.g. table ti IN
'iODBC' ...). http://support.openlinksw.com/support/mac-faq.html
gives some information on using ODBC on a Mac.
If you want to use the native MySQL interface you have to install the
MySQL development files.
see http://dev.mysql.com/downloads/mysql/5.0.html
Looking at sql.h the installed version of iODBC is outdated:
* $Id: sql.h,v 1.1.1.2 2002/04/30 00:40:22 miner Exp $
It contains symbol "FAR" which leads to an error when compiling with my
version of gcc (GCC) 4.2.3 (Ubuntu 4.2.3-2ubuntu7):
sql.h:1254: Error: expected »;«, »,« or »)« before »*« token
The version I have been using when writing the SQL extension of GLPK was
* $Id: sql.h,v 1.9 2006/01/20 15:58:34 source Exp $
Could you, please, update the package iODBC on your computer and tell
me if this fixes your problem. If not, please, send me the new sql.h
and sqlext.h
see http://www.iodbc.org/downloads/iODBC/libiodbc-3.52.6.tar.gz
Best regards
|