RE: [Help-glpk] ODBC access with 64-bit Windows 7

[Meketon, Marc]

You're amazing.  Thank you.

Just by switching "w64" and "w32" in my path to glpsol.exe, that fixed the 
problem.  I had read the wiki entry before sending out the email for help, but 
I didn't connect all the dots correctly.  I now edited the wiki page to reflect 
what you just said (almost word for word), and I would appreciate if you could 
take a look at the edits to ensure accuracy.

Again, thank you.

-Marc


-----Original Message-----
From: Xypron [mailto:address@hidden
Sent: Sunday, February 13, 2011 6:07 AM
To: Meketon, Marc
Cc: address@hidden
Subject: Re: [Help-glpk] ODBC access with 64-bit Windows 7

Hello Marc,

 > I am trying to use the "table" command in GMPL, under the 64-bit version of 
 > Windows 7, and Access 2007.

in 64bit Windows there are separate libraries 32bit and 64bit data sources. How 
to proceed depends on whether you use a 32bit or the 64bit glpsol.exe.

Please, read
http://en.wikibooks.org/wiki/GLPK/ODBC

Microsoft Access 2007 is a 32bit program hence it only installed 32bit ODBC 
drivers. You could also use it in conjunction with the 32bit version of 
glpsol.exe if your problem is sufficiently small.

Assuming you want to run a 64bit application:
Install a 64bit ODBC connector for Access. It is contained in the 64bit version 
of "Microsoft Access Database Engine 2010 Redistributable" or in the 64bit 
version of Microsoft Office 2010. 64bit and 32bit installations of Microsoft 
Office are mutually exclusive. You will have to remove 32bit Access 2007.

For other databases like MySQL it is possible to install both 32bit and 64bit 
ODBC drivers on the same system.

Best regards

Xypron


----------------------------------------------------------------------------
This e-mail and any attachments may be confidential or legally privileged.  If 
you received this message in error or are not the intended recipient, you 
should destroy the e-mail message and any attachments or copies, and you are 
prohibited from retaining, distributing, disclosing or using any information 
contained herein.  Please inform us of the erroneous delivery by return e-mail.

Thank you for your cooperation.
----------------------------------------------------------------------------


This e-mail and any attachments may be confidential or legally privileged. If 
you received this message in error or are not the intended recipient, you 
should destroy the e-mail message and any attachments or copies, and you are 
prohibited from retaining, distributing, disclosing or using any information 
contained herein.  Please inform us of the erroneous delivery by return e-mail. 
Thank you for your cooperation.