OsiSymSolverInterface::readGMPL does not support SQL

[svigerske]

Issue created by migration from Trac.

Original creator: xypron

Original creation time: 2008-12-22 18:25:52

Assignee: @mjsaltzman

Version: 0.96.1

GLPK includes support to access SQL tables via the table statement.

Unfortunately the configure.ac supplied in Thirdparty/GLPK does not allow to enable ODBC.

Please add the lines below to Thirdparty/GLPK/configure.ac and copy
Thirdparty/GLPK/glpk/config.h.in to Thirdparty/GLPK.

This will add optional configure parameters:
--configure-ODBC=yes|unix
--configure-dl=yes
which will allow to use ODBC with package iODBC or unixODBC.

Best regards

Xypron

###########################################################################

SQL

###########################################################################

AC_CONFIG_HEADERS([config.h])

AC_ARG_ENABLE(dl,
AC_HELP_STRING([--enable-dl],
[enable shared library support [[default=no]]]),
[case $enableval in
yes | ltdl | dlfcn | no) ;;
*) AC_MSG_ERROR([invalid value `$enableval' for --enable-dl]);;
esac],
[enable_dl=no])

AC_ARG_ENABLE(odbc,
AC_HELP_STRING([--enable-odbc],
[enable MathProg ODBC support [[default=no]]]),
[case $enableval in
yes | unix | no) ;;
*) AC_MSG_ERROR([invalid value `$enableval' for --enable-odbc]);;
esac],
[enable_odbc=no])

AC_MSG_CHECKING([whether to enable shared library support])
if test "$enable_dl" = "yes"; then
AC_MSG_RESULT([ltdl])
AC_DEFINE([HAVE_LTDL], 59f4d6c)
LIBS="-lltdl $LIBS"
elif test "$enable_dl" = "ltdl"; then
AC_MSG_RESULT([ltdl])
AC_DEFINE([HAVE_LTDL], 59f4d6c)
LIBS="-lltdl $LIBS"
elif test "$enable_dl" = "dlfcn"; then
AC_MSG_RESULT([dlfcn])
AC_DEFINE([HAVE_DLFCN], 59f4d6c)
else
AC_MSG_RESULT([no])
fi

AC_MSG_CHECKING([whether to enable MathProg ODBC support])
if test "$enable_odbc" = "yes"; then
if test "$enable_dl" = "no"; then
AC_MSG_ERROR([--enable-odbc requires --enable-dl])
fi
AC_MSG_RESULT([yes])
AC_DEFINE([ODBC_DLNAME], ["libiodbc.so"])
elif test "$enable_odbc" = "unix"; then
if test "$enable_dl" = "no"; then
AC_MSG_ERROR([--enable-odbc requires --enable-dl])
fi
AC_MSG_RESULT([unix])
AC_DEFINE([ODBC_DLNAME], ["libodbc.so"])
else
AC_MSG_RESULT([no])
fi

[svigerske]

Attachment configure.ac by xypron created at 2008-12-22 18:27:08

coin-Osi/ThirdParty/Glpk/configure.ac

[svigerske]

Comment by @svigerske created at 2009-07-11 19:27:47

Hi,

this ticket should have gone into the BuildTools project, here it is easily overlooked.

I made some additions to the COIN-OR build system for Glpk - currently only in trunk:
https://projects.coin-or.org/BuildTools/changeset/1321

The database stuff is not tested, esp. Windows might not work.

Stefan

[svigerske]

Comment by @svigerske created at 2009-10-04 11:03:11

also now in ThirdParty/Glpk/stable/1.6