[Help-glpk] [Fwd: Re: MySQL Driver Error]

[Andrew Makhorin]

-------- Forwarded Message --------
From: Eric Moore <address@hidden>
To: Robbie Morrison <address@hidden>
Cc: GLPK help list <address@hidden>, Xypron <address@hidden>
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 <address@hidden>
wrote:
        
        Hello Eric, Xypron
        
        ------------------------------------------------------------
        To:           Eric Moore <address@hidden>
        Subject:      Re: [Help-glpk] MySQL Driver Error
        Message-ID:  <address@hidden>
        From:         Xypron <address@hidden>
        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) : address@hidden
        Webmail (preferred)           : address@hidden
        [from Webmail client]