Hello again,
My apologies - I was in error regarding the DSN-less syntax including
spaces. It was my error for not specifying the path correctly. Spaces
are allowed.
If you wish the following is preferred for my original question (I have
removed the DSN-less space comments).
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+++++++++++++
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.
I am baffled because the DSN-less connection works?
Assistance with this problem would be appreciated.
Regards, Alex
Regards, Alex
_________
Alex Morelli
Bldg 6, 650 Church Street, Richmond VIC 3121
Mobile +61 400 365 754 / [email protected]
> _____________________________________________
> From: Alex Morelli
> Sent: Monday, 10 October 2011 7:17 PM
> To: [email protected]
> Subject: MS Access 64 bit
>
> 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
