Re: [Help-glpk] [Fwd: Re: [No Memory Available Error]]

[glpk xypron]

Hello Aly,

> DRIVER={Microsoft Excel Driver (*.xls)}

You want to use
DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);

See
http://en.wikibooks.org/wiki/GLPK/ODBC#Microsoft_Excel

Please, subscribe to the GLPK help list, so Andrew does not have to
forward your mails manually, see
https://lists.gnu.org/mailman/listinfo/help-glpk

Best regards

Xypron

> -------- Forwarded Message --------
> Subject: Re: [Help-glpk] [Fwd: No Memory Available Error]
> Date: Sat, 18 Aug 2012 08:31:16 -0400 (EDT)
> 
> Thanks a lot for your replies, Robbie and Xypron. I did understand your
> excellent remarks, but I still do have a couple of questions, please:
> 
> 1. So, I tried to use the 64 bit GLPK on a machine with windows 7 64 bit
> and Excel and Access 64 bit. However, when connecting to the Excel or
> the access database through ODBC, I get the following error:
> 
> "data source name not found and no default driver specified".
> 
> I use a .dsn file to connect to the database, and that has been working
> perfectly with the 32 bit GLPK. In that .dsn file, I have this written:
> 
> [ODBC]
> DRIVER={Microsoft Excel Driver (*.xls)}
> dbq=TestOne.xls
> 
> Any thoughts why this is not working, and how can I get it to work?
> 
> I understand Xypron's advice regarding switching my database to MySql. I
> could potentially do this in the future, but for now, I really need to
> connect to Excel and Access!
> 
> 2. I used to use CPLEX through generating the .lp or the .mps file
> through GLPK, then solve that using CPLEX. However, I was wondering if
> there is a way to automatically call CPLEX within the GLPK code (which
> would enable me to get the solutions from CPLEX back, and play with
> them,....etc). I saw in one of the links that Robbie sent, a C code that
> apparently does this. Is there any other direct easier way to do that?
> 
> Your help will be greatly appreciated!
> 
> Best,
> Aly
>