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

[Noli Sicad]

 Hi Aly,

This blog will help locate you odbc in Window 7

http://robertoschiabel.wordpress.com/2008/02/28/windows-x64-32bit-odbc-vs-64bit-odbc/

Noli


On 9/23/10, Noli Sicad <address@hidden> wrote:
> 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
>>
>