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 <[email protected]> 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 > _______________________________________________ Help-glpk mailing list [email protected] http://lists.gnu.org/mailman/listinfo/help-glpk
