NAV 4 SP3 , ODBC, SQL Server 2008, Windows Server 2008 R2

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.

Found a solution:

Copy the following DLL:
NC_NETB.DDL
DBM.DLL
NC_TCP.DLL
NC_TCPS.DLL
NDBCS.DLL

That are located on Program Files (x86)\Microsoft Business Solutions-Navision\Client
to Program Files (x86)\LS Retail\Data Director\plugins\finplugin\cfront\403

This replacement of DLL updates the ODBC driver for LS Retail Data Director.

Oh, almost forgot to tell you the versions:

Windows Server 2008 R2 Cluster

SQL Server 2008 SP1

NAV W1 4.0 SP3 Build 25143

LS Retail Version 4.2

Data Director 2.28.1