Hello again,
Hopefully this will be the last time on the same topic.
My desire to use the DSN is also driven by the maximum connection string
using DSN-less. As I understand it, the 'DRIVER={Microsoft Access
Driver (*.mdb)};dbq=glpk.mdb' cannot be split over multiple lines, so if
the path to the .mdb is lengthy the connection will fail. I have tried
to split the connection string but received similar failure.
If there is a way to split the DSN-less connection it would be very
useful, please.
Regards, Alex
> _____________________________________________
> From: Alex Morelli
> Sent: Monday, 10 October 2011 7:58 PM
> To: '[email protected]'
> Subject: RE: MS Access 64 bit
>
> 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
