When running an application on NAV called Data Director from LS Retail that synchronizes different DB locations with head office, doing a test for a local connection (the same for all connections) I get the following message:
"The SQL Server ODBC driver on your computer is not a recent enough version.
Before the driver can be used by Microsoft Business Solutions-Navision,
you must upgrade it, along with the network libraries and supporting files
to version 2000.85.1022 o "
From what I could find out Microsoft have changed the way it creates the version numbers on its drivers and they would go numbered accordingly to the OS they run; so apparently the MDAC version goes on the 2000.xxx.xxxx.xx and the Vista, Windows 7 and Server 2008 goes with a new numbering system that is lower (in this case 6.1.7600.16385) which means it’s an older version.Does anyone can help? Is there a work around? Contacted support from LS Retail and it’s been two days without any logical answer.