Using NAV Developer’s Toolkit with Microsoft Dynamics NAV 2009 SP1

I’ve been  encountering SQL Trace Flag 4616 issues when attempting to open a NAV 2009 R2 SQL database with the latest NDT Microsoft Dynamics NAV Developer’s Toolkit. I was a little taken aback  being aware that from NAV 5 Sp1 latest build, Trace Flag 4616 is no longer required. However, little did I know that Microsoft have somehow failed to update the underlying  compatibility support files which will enable the Tool to automatically comply with NAV 2009 SP1 to R2 Databases (SQL).  Anyway,  long story short, the following error Error messages were sequentially triggered when attempting to open NAV SQL database:

NDT Trace Flag Error

Trace Flag Error

 

Microsoft has provided a walk-around for this issue

The latest version of the Microsoft Dynamics NAV Developer’s Toolkit (version 3.01.410) is developed for Microsoft Dynamics NAV 2009. Therefore, you need to create the Developer’s Toolkit database with Microsoft Dynamics NAV 2009 client executables.

This How To article describes how you can make version 3.01.410 of the Developer’s Toolkit work with a Developer’s Toolkit database created with Microsoft Dynamics NAV 2009 SP1 client executables.

The Microsoft Dynamics NAV Developer’s Toolkit (NDT) uses C/Front to connect to the NDT database.  You can make the Developer’s Toolkit connect to a database that was created with Microsoft Dynamics NAV 2009 SP1 client executables by following these steps:

Install a Microsoft Dynamics NAV 2009 SP1 Classic client

Install the Microsoft Dynamics NAV Developer’s Toolkit version 3.01.410

Create the Developer’s Toolkit database following the instructions in the Developer’s Toolkit manual

Install C/Front for Microsoft Dynamics NAV 2009 SP1

Copy the following C/FRONT files from the C/Front installation folder to the Developer’s Toolkit folder:

  1. CFRONT.DLL
  2. cfront.ocx
  3. cfrontsql.dll
  4. Microsoft.Dynamics.NAV.CFront.CFrontDotNet.dll
  5. Microsoft.Dynamics.NAV.CFront.CFrontDotNet.xml

Note:

C/Front is by default installed in the following directory: C:\Program Files\Microsoft Dynamics NAV\60\SDK\CFRONT.

The Developer’s Toolkit is by default installed in the following directory: C:\Program Files \Microsoft Dynamics NAV\Developers Toolkit

Copy the following files from the Microsoft Dynamics NAV Classic client folder to the Developer’s Toolkit folder:

  1. nc_netb.dll
  2. nc_tcp.dll
  3. nc_tcps.dll
  4. ndbcs.dll
  5. slave.exe
  6. dbm.dlll

Note:

The Microsoft Dynamics NAV Classic client is by default installed in the following directory: C:\Program Files\Microsoft Dynamics NAV\60\Classic

The Developer’s Toolkit is by default installed in the following directory: C:\Program Files \Microsoft Dynamics NAV\Developers Toolkit

You can find the Microsoft Dynamics NAV 2009 SP1 Classic client and C/Front for Microsoft Dynamics NAV 2009 SP1 on the Microsoft Dynamics NAV 2009 SP1 installation media, which can be downloaded here: Microsoft Dynamics NAV 2009 Service Pack 1 (SP1).

You can download the Microsoft Dynamics NAV Developer’s Toolkit here: Developer’s Toolkit for Microsoft Dynamics NAV. Please note that access to Microsoft Partnersource is required in order to download this Tool.

via How to Use the Microsoft Dynamics NAV Developer’s Toolkit with Microsoft Dynamics NAV 2009 SP1.