Re: [Help-glpk] ODBC Excel driver

[Heinrich Schuchardt]

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