Andrew, 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.
Thanks, Eric On Fri, Sep 16, 2011 at 1:33 AM, Andrew Makhorin <[email protected]> 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. > >
_______________________________________________ Help-glpk mailing list [email protected] https://lists.gnu.org/mailman/listinfo/help-glpk
