[Help-glpk] How to use Access mdb in Windows 7

[Noli Sicad]

Hi Aly,

I am not using  Windows 7 now. I try to avoid it as much I can. I am
using linux - Ubuntu 10.04 and Mac OS X. I don't know how to setup
odbc MS access in Windows 7.

It seems that there are problems in using ODBC and MS Access driver in Window 7.

Read these postings:

http://stackoverflow.com/questions/2013837/is-there-a-windows-7-odbc-driver-for-access

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/685eacc1-a670-42d4-8392-924230fa90cb

http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/1c63e3ae-e001-4066-9eac-ad9162116603

http://social.answers.microsoft.com/Forums/en-US/addbuz/thread/fe67fc03-7b7d-4c5c-b448-a63bf5a5d7a9

http://www.google.com.au/#hl=en&q=odbc+MS+access+Windows+7&aq=f&aqi=&aql=&oq=&gs_rfai=&fp=f8742a0da852d549

Noli


On 9/23/10, Aly Megahed <address@hidden> wrote:
> Hi Noli,
>
> I hope you are doing fine.
>
> If you remember, you sent me before the below EXCELLENT instructions to use
> Access and call it with the ODBC in MathProg. It worked perfectly either
> using your idea, or by creating a .dsn file that I'd call from MathProg. So,
> for instance, I created a file called d2.dsn and had this in it:
>
> [ODBC]
> DRIVER=Driver do Microsoft Access (*.mdb)
> DBQ=./my_database.mdb
>
> And then in the MathProg code, I'd have something like this:
>
> set S;
> table set_i IN "ODBC"
>  'FileDSN=.\d2.dsn;READONLY=FALSE'
>   'Suppliers':
>  S<-  [FacilityID];
>
>
> And that worked perfectly in windows xp as well, but didn't work under
> windows 7, 64 bit as there was some driver problems!
>
>
> Now, my question is: how can that be done to windows 64 bit (as windows
> 7)??? Do you mind giving me clear instructions like the ones below, in order
> to have that work for windows 7? Also, if I wanna do it with the way I
> described above (using a .dsn file), how can that be done?
>
> Your help will be greatly appreciated.
>
> Thanks a lot,
>
> Aly
>