Hello,
I would appreciate any advice for enabling the DSN connection to MS
Access 64-bit.
I am using:
Microsoft Windows 7 Professional SP1 64-bit
Microsoft Office Professional 2010 64-bit
I have setup the user DSN ODBC connections using the
%windir%\system32\odbcad32.exe.
The Microsoft Access driver selected is - "Microsoft Access Driver
(*.mdb, *accdb)" with Version = 14.00.6015.1000, file = ACEOBDC.DLL,
date = 21/12/2010.
For each DSN the user / password is glpk/gnu (as per previous examples).
I am also using GUSEK. I have copied the following files from
glpk-4.47/w64 to the gusek folder (which contains gusek.exe)
glpsol.exe 11/09/2011 at 2:26am 75,264 bytes
glpk_4_47.dll 11/09/2011 at 2:26am 1,498,624 bytes
glpk_4_47_java.dll 11/09/2011 at 2:26am 392,192 bytes
When I run my model the first DSN call generates the following error:
"IM014:1:0:[Microsoft][ODBC Driver Manager] The specified DSN contains
an architecture mismatch between the Driver and the Application ....."
When I replace this with connection with:
'DRIVER={Microsoft Access Driver (*.mdb)};dbq=glpk.mdb'
the connection works properly.
For simplicity, I would prefer to continue with the DSN connections.
One reason is that I have linked tables between various mdb files and
worse than that the folder names include spaces (which makes the DSN
less connection fail in the connection string - I can't work out how to
represent the path including the space in the folder name - I have tried
enclosing in "", '', [] to no avail).
I am baffled because the DSN-less connection works (except for those
folder names with spaces)?
Assistance with either / both of the DSN problem or how to specify
DSN-less path including spaces would be appreciated.
Regards, Alex
_______________________________________________
Help-glpk mailing list
[email protected]
https://lists.gnu.org/mailman/listinfo/help-glpk
