Re: [Help-glpk] ODBC Excel driver

[Haroune ZAGHDAOUI]

Heinrich,

I downloaded glpk-4.55 and unzipped the directory. I copied the 64bit glpsol 
executable and the "glpk_4_55.dll" and pasted them in Gusek directory. And it 
works :-)


Andrew,

I tested SolverStudio for other Operation Research problems. It's seems a very 
good application, I liked it and I will use it for problems with fixed data. 
But with this problem, my tables on Excel are not always identical. The size 
always changes (and is updated by someone else on my Dropbox). So, I prefer to 
enter (or let other people enter) the data in the Excel tables and call them 
with Gusek IDE via instruction "table IN". 

Thank you for developping SolverStudio,



Thanks for your help guys :-)
Haroune.



----- Mail original -----
De: "Heinrich Schuchardt" <address@hidden>
À: "Haroune ZAGHDAOUI" <address@hidden>
Cc: "Help Glpk" <address@hidden>
Envoyé: Mardi 25 Novembre 2014 10:55:29
Objet: Re: [Help-glpk] ODBC Excel driver

Hello Haroune,

a 64bit glpsol executable is available at
http://winglpk.sf.net

Best regards

Heinrich Schuchardt

http://www.xypron.de

Am 25.11.14 um 09:34 schrieb Haroune ZAGHDAOUI

> Hello Heinrich,
> 
> 
> 
> Thank you for your help. I uninstalled Excel x64, installed the 32bit ODBC 
> driver for Excel and it works. I have to find a way to the 32bit Excel 
> version. 
> 
> I heard there is another way : starting the 32bit glpsol executable in x64 
> manually by calling it via the Windows command prompt, is it true? If it's 
> the case, I would like to try to do it.
> 
> 
> 
> Thanks again,
> 
> Haroune.
> 
> 
> 
> ----- Mail original -----
> 
> De: "Heinrich Schuchardt" <address@hidden>
> 
> À: "Haroune ZAGHDAOUI" <address@hidden>, "Help Glpk" <address@hidden>
> 
> Envoyé: Lundi 24 Novembre 2014 17:05:31
> 
> Objet: Re: [Help-glpk] ODBC Excel driver
> 
> 
> 
> Hello Haroune,
> 
> 
> 
> Gusek comes with the 32bit glpsol executable. You need a 32bit ODBC driver 
> for Excel (not X64).
> 
> 
> 
> Best regards
> 
> 
> 
> Heinrich Schuchardt
> 
> 
> 
> http://www.xypron.de
> 
> 
> 
> Am 24.11.14 um 16:06 schrieb Haroune ZAGHDAOUI
> 
> 
> 
> > Hello everyone, 
> 
> > 
> 
> > 
> 
> > 
> 
> > I need your help please : 
> 
> > 
> 
> > I have an Excel table where I put my data in columns. Then I wrote a gusek 
> > program to get this data through via ODBC. If I register my Excel file as 
> > an Excel from 97-2003, and I write the following instruction, it works : 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > table LOCATIONS IN 'ODBC' 
> 
> > 
> 
> > 'DRIVER={Microsoft Excel Driver (*.xls)};dbq=.\exemple-format-excel.xls' 
> 
> > 
> 
> > 'SELECT * FROM [LOCATIONS$]': 
> 
> > 
> 
> > LID <- [LID], LName, LType, LLon, LLat, LAddr, LCity, LZIP; 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > But if my Excel file is from 2010 (as my Excel version), it says that there 
> > is a problem with the driver : 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > Program : 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > table LOCATIONS IN 'ODBC' 
> 
> > 
> 
> > 'DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) 
> > };dbq=.\exemple-format-excel. xlsx ' 
> 
> > 
> 
> > 'SELECT * FROM [LOCATIONS$]': 
> 
> > 
> 
> > LID <- [LID], LName, LType, LLon, LLat, LAddr, LCity, LZIP; 
> 
> > 
> 
> > 
> 
> > 
> 
> > Here is the message error : 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > GLPSOL: GLPK LP/MIP Solver, v4.55 
> 
> > 
> 
> > Parameter(s) specified in the command line: 
> 
> > 
> 
> > --cover --clique --gomory --mir -m test-locations.mod 
> 
> > 
> 
> > Reading model section from test-locations.mod... 
> 
> > 
> 
> > 20 lines were read 
> 
> > 
> 
> > Reading LOCATIONS... 
> 
> > 
> 
> > Failed to connect 
> 
> > 
> 
> > 
> 
> > 
> 
> > The driver reported the following diagnostics whilst running 
> > SQLDriverConnect 
> 
> > 
> 
> > IM002:1:0:[Microsoft][Gestionnaire de pilotes ODBC] Source de données 
> > introuvable et nom de pilote non spécifié 
> 
> > 
> 
> > test-locations.mod:12: error on opening table LOCATIONS 
> 
> > 
> 
> > MathProg model processing error 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > I really don't know where does the problem come from : I downloaded the 
> > Excel driver from Microsoft website (AccessDatabaseEngine_X64) but it still 
> > doesn't work. 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > Thank you so much for your help. 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > 
> 
> > Yours Sincerly, 
> 
> > 
> 
> > 
> 
> > 
> 
> > Haroune. 
> 
> > 
> 
> > University of Technology of Troyes 
> 
> > 
> 
> > Engineering of Industrial Systems 
> 
> > 
> 
> > 
> 
> > 
> 
> > _______________________________________________
> 
> > 
> 
> > Help-glpk mailing list
> 
> > 
> 
> > address@hidden
> 
> > 
> 
> > https://lists.gnu.org/mailman/listinfo/help-glpk