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
