Re: [Help-glpk] MySQL Driver Error

[Andrew Makhorin]

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.