[Help-glpk] MS Access 64 bit

[Alex Morelli]

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

The information included in this email and any attached documents from the Sender may be confidential and/or subject to legal privilege. This information is intended to be for the use of the addressee only. The information contained in this email may not represent the views or opinions of the Sender’s employer. If you are not the intended recipient, note that any disclosure, photocopying, distribution or use of the contents of the emailed information is prohibited. If you have received this email in error, please contact the sender promptly and delete the email from any system and destroy any hard copies. Thank you.