NAV 5.0 Native - ODBC Excel 64 bit

Mukker

Hallo

I have the following issue:
I want to use the NODBC 32 bit for Nav 5.0.
The client is running on a hosted server (Both NAV client and server is on this hosted server).
The server is running Windows 2008 R2 (64 bit)
The Classic client is working fine.
I can configure the ODBC using the 32 bit ODBC (...SysWOW64\odbcad32.exe)
In Excel 64 bit, when trying to connet using ODBC I get an error.
"[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"

What am I doing wrong ?
Is it possible to use NAV ODBC on a 64 bit ?
Would it help with a 32 bit Excel ?

Regards,

Mukker

kine

1) Why you are using office 64bit?
2) You cannot use N/ODBC for 64bit office.
3) If you read what is recommanded (when to use 64bit office), you can find out, that it is recommended to use 64bit office only when you need to work with files bigger than 2GB and you DO NOT NEED TO USE SOME 32bit addins/drivers.