[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Help-glpk] MySQL Driver Error

From: Andrew Makhorin
Subject: Re: [Help-glpk] MySQL Driver Error
Date: Fri, 16 Sep 2011 09:33:32 +0400

On Thu, 2011-09-15 at 23:25 -0400, Eric Moore wrote:
> I hope someone can help me with this.  I've got my model working and I
> just wanted to take the next step and use a MySQL database as the data
> source instead of a text file.  No matter what I try, I constantly get
> the error message below.  I'm wondering if it is an issue with 32 bit
> vs. 64 bit MySQL.  I don't know if that is an issue at all, but I
> guessing it could be.  Below is the error message that I am getting.
> Below that is the table statement that I am trying to use to read in
> the data.  I think it is pretty straighforward.  If anyone has any
> suggestions on what I might be doing wrong, I would greatly appreciate
> it.
> Reading export_fmatdcloc...
> MySQL table driver not supported
> SCM_MYSQL.mod:24: error on opening table export_fmatdcloc
> MathProg model processing error
> /* Import fmatdcloc from MySQL database */
>  table export_fmatdcloc IN "MySQL"
>  'Database=SupplyChainOptimization;UID=test;PWD=test'
>  'select fmatdcloc from export_fmatdcloc' :
>  fmatdcloc <- [ fmatdcloc ];
> Thanks a lot,
> Eric

Your version of glpk has been built with the MySQL table driver disabled
(by default). To enable this feature you need to configure the package
as follows:

./configure --enable-mysql ...

and then rebuild it with 'make'. For more details please see file
INSTALL or the glpk reference manual (doc/glpk.pdf, Appendix A), which
both are included in the distribution.

reply via email to

[Prev in Thread] Current Thread [Next in Thread]