Hello Andrew,
Alex experiences a return code indicating a memory access error after
glpsol --check
writes
Model has been successfully generated
to the console.
Do you have an idea how to identify the cause.
The glpsol dll and executable are those of Gusek 0.2.12, which are the
same ones
that I published as GLPK for Windows 4.45.
Best regards
Xypron
-------- Original Message --------
Subject: RE: RE: RE: RE: [Help-glpk] ODBC Connection to MS-Access -
WHERE Clause Syntaxproblems
Date: Wed, 29 Jun 2011 16:09:14 +1000
Xypron,
I'm not sure if I have done what you asked correctly.
I created a .bat file with the 2 lines.
The model ran and returned "Model has been successfully generated". The
glpsol.exe failure dialog box also displayed. The error returned was
-1073741819.
I'm not sure how to copy the text contents displayed by cmd.exe - hence
the reason that I have just typed the error code for you.
I hope this is satisfactory.
Regards, Alex
-----Original Message-----
From: glpk xypron [mailto:[email protected]]
Sent: Wednesday, 29 June 2011 1:57 PM
To: Alex Morelli
Subject: Re: RE: RE: RE: [Help-glpk] ODBC Connection to MS-Access -
WHERE Clause Syntaxproblems
Hello Alex,
the error occurs after all SQL stuff has already been handled.
Currently you are calling the solver glpsol.exe from inside Gusek.
Just to exclude that the problem has anything to do with Gusek,
could you please,
- open the console (cmd.exe)
- navigate to the gusek directory where you will find glpsol.exe
- execute the following commands:
glpsol -m --check --cover --clique --gomory --mir -m c:\temp\Xypron.mod
echo %errorlevel%
Please, adjust the path to Xypron.mod.
Please, send me the output.
Best regards
Xypron
-------- Original-Nachricht --------
Datum: Wed, 29 Jun 2011 09:39:28 +1000
Betreff: RE: RE: RE: [Help-glpk] ODBC Connection to MS-Access - WHERE
Clause Syntaxproblems
Xypron,
Sorry for the delay.
The model is Xypron.mod (the one I sent to you), i.e.
set prods dimen 3;
param qpers{(i,j,k) in prods};
table products_table IN "ODBC"
'DSN=glpk_Xypron'
'SELECT Product, MaterialDesc as pdesc, [Manuf Code] as
prodman,
QPer'
'FROM qProductsUnique'
'WHERE [Manuf Code] Like ''[_]%'';':
prods<- [Product, pdesc, prodman], qpers~QPer;
display prods;
end;
------------------------------------------
The output lines are:
GLPSOL: GLPK LP/MIP Solver, v4.45
Parameter(s) specified in the command line:
--check --cover --clique --gomory --mir -m Xypron.mod
Reading model section from Xypron.mod...
14 lines were read
Reading products_table...
Connected to ACCESS 04.00.0000 - C:\Documents and Settings\MORELALE\My
Documents\MyNetworkFiles\Yorke\Data\Sales\Xypron
SELECT Product, MaterialDesc as pdesc, [Manuf Code] as prodman, QPer
FROM qProductsUnique WHERE [Manuf Code] Like '[_]%'
Display statement at line 12
prods:
('001BMOPVC','125ml Bottle - PVC',_Purchased)
('001BMOTUB','250g tub - black',_Purchased)
('020CBLCK','20lt drum cap - black',_Purchased)
('038CMOBLU','38mm cap - blue',_Purchased)
('038CMOSK3001N','38mm cap - silver T/E(item 8)',_Purchased)
('038CMOSK3002N','38mm cap - black T/E(item 16)',_Purchased)
('038CMOSK3003','38mm cap - blue T/E(item 69)',_Purchased)
('038CMOSK3006','38mm cap - Charcoal(item 39)',_Purchased)
Model has been successfully generated
>Exit code: -1073741819 Time: 8.669
----------------------------------------------------------------
Driver tab has the following:
Microsoft Access Driver (*.mdb) - Version 4.00.6305.00, File
ODBCJT32.DLL, 14/04/2008
Microsoft Access (from Help / About)
Microsoft Access 2003 (11.6566.8172) SP2
Part of Microsoft Professional Edition 2003
Microsoft Access (from System Information)
Microsoft Access
Version 11.0
Build 6566
ADO Version - not available
VBA version - 6.05
There is some other stuff in "Jet Core Components" the
significance of which I, of course, don't understand, but I noticed
that
there seemed to lots of dlls for various things (Excel, Exchange, Jet
2.x, Jet 3.x, Jet 4.0, Lotus, Paradox, SharePoint, Text, Xbase),
except
the entry for ODBC says path = not available.
I know you didn't ask, but I thought I may as well be clear on the
following:
Microsoft Windows XP Professional, Version - 5.1.2600 Service Pack 3
Build 2600
I hope that this answers your questions. Any further help I can give,
please ask.
Regards, Alex
_______________________________________________
Help-glpk mailing list
[email protected]
https://lists.gnu.org/mailman/listinfo/help-glpk
