[Help-glpk] Fwd: RE: ODBC Connection to MS-Access - WHERE Clause Syntaxproblems

[Xypron]

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:address@hidden] 
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
>