[Top][All Lists]

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

Re: [Help-glpk] MySQL Driver Error

From: Eric Moore
Subject: Re: [Help-glpk] MySQL Driver Error
Date: Fri, 16 Sep 2011 22:45:53 +0400

I really appreciate the quick response.  I'm running the software on a Windows machine.  When I looked at the manual, I thought it explaining how to install the software on a Linux machine.  Is that correct?  If so, could you let me know how to enable the MySQL driver on a Windows machine.  For Windows, I simply downloaded the Windows version, ran the installation executable and followed the instructions.  Do I need to go to a command prompt in Windows and run a script to activate the MySQL driver?  If so, could you email me the command that I need to run.  I am sorry....I might just be a little slow with this stuff.  It just seemed like the manual was describing installation on a Linux machine.

On Fri, Sep 16, 2011 at 1:33 AM, Andrew Makhorin <address@hidden> wrote:
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]