-------- Forwarded Message -------- From: Eric Moore <[email protected]> To: Robbie Morrison <[email protected]> Cc: GLPK help list <[email protected]>, Xypron <[email protected]> Subject: Re: [Help-glpk] MySQL Driver Error Date: Sat, 17 Sep 2011 12:52:25 -0400
Robbie, Thanks a lot. I got this to work beautifully last night. Here is what I have running. Windows 7 64bit MySQL 64bit MySQL ODBC Connector downloaded from Oracle GLPK 4.47 64bit version If is used the 32 bit version of GLPK, I would get an error stating that the there was an architecture mismatch. When I switched to the 64 bit version of GLPK, everything worked. The code below worked nicely for me. table t IN "iODBC" 'DSN=SupplyChainOptimization;UID=test;PWD=test' 'export_fmatdloc' : fmatdloc <- [ fmatdloc ]; Thanks again for all your work on this software. It's exciting stuff. Thanks, Eric On Sat, Sep 17, 2011 at 12:15 PM, Robbie Morrison <[email protected]> wrote: Hello Eric, Xypron ------------------------------------------------------------ To: Eric Moore <[email protected]> Subject: Re: [Help-glpk] MySQL Driver Error Message-ID: <[email protected]> From: Xypron <[email protected]> Date: Sat, 17 Sep 2011 00:58:05 +0200 ------------------------------------------------------------ > Hello Eric, > > please, use ODBC to connect to your MySQL Server. ODBC > is installed on all Windows machines anyway. You will > need the MySQL-ODBC connector available from Oracle. > > Cf. > http://en.wikibooks.org/wiki/GLPK/ODBC > > In principle you should be able to compile GLPK with > MySQL enable by modifying the config.h file (defining > symbol MYSQL_DLNAME) and the Makefile (adjust the > include paths) in the w64 or w32 directory. The > relevant code implementing the MySQL connectivity is in > src/glpsql.c. > > Best regards > > Xypron [snip: remainder of thread] Yesterday I added a new section to the GLPK wikibook, recording what Andrew had said: http://en.wikibooks.org/wiki/GLPK/ODBC#MySQL_support I hope this new entry does not add to the confusion! When I get better view of the problem and solution, I will revise that entry accordingly. best wishes, Robbie --- Robbie Morrison PhD student -- policy-oriented energy system simulation Technical University of Berlin (TU-Berlin), Germany University email (redirected) : [email protected] Webmail (preferred) : [email protected] [from Webmail client] _______________________________________________ Help-glpk mailing list [email protected] https://lists.gnu.org/mailman/listinfo/help-glpk
