2006-03-10 15:02:55 UTC
(Microsoft Knowledge Base article number(s) 891518).
Recently we have been trying to get NODBC (from Nav 4.0 install disks) to
work using Excel to import the data and we keep getting the following error:
The server and client do not have the same program version number.
Database Error: 1111
Drivers' SQLSetConnectAttr failed
I have applied the above mentioned hotfix to the NODBC directories as per
the instructions and we have double checked the options on the ODBC
If I try to run Nav 4.0 SP1 NODBC (without upgrading the client or server to
SP1), the error goes away, but the query aborts once the query starts. This
to me is expected since running mixed versions of SP1 and non SP1 is likely
Also if I install al local database on my client computer and set the NODBC
with hotfix to access this data it works fine.
So from my experiments it looks like the hotfix has somehow broken the NODBC
access in a client server setup. Moving to SP1 all around is a possibility
but it is also a fair amount of work since our Navision setup has a fair
amount of customization in it.
Does anyone have any suggestions?