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.

How to apply the 6.0 Hotfix to the existing Demo Install

Usage Scenarios

4.1 You have downloaded the RTM image of Microsoft Dynamics NAV 2009 and want to update it with the Hotfix.

  1. Download the HF package from PartnerSource.
  2. Copy the updated database files into the existing database folders and overwrite the existing databases: Demo Database NAV (6-0)_Data.MDF, database.fdb, and database.fbk.
  3. Overwrite the existing form transformation tool files in the Transformation Tool folder with the updated form transformation tool files.

4.2 You have installed the demo database and want to update it with the Hotfix.

  1. Download the HF package from PartnerSource.
  2. Detach or delete the existing Demo Database NAV (6-0)_Data.MDF.
  3. Attach the updated Demo Database NAV (6-0)_Data.MDF from the HF package as described in the C/SIDE online help. To view the online help, on the Open Database form, click Help. In the Microsoft Dynamics NAV Classic Client Help, in the Open Database topic, click the Microsoft SQL Server Option for Microsoft Dynamics NAV link and then go to step 8.
  4. Overwrite the existing form transformation tool files in the Transformation Tool folder with the updated form transformation tool files.

4.3 You have downloaded the RTM image of Microsoft Dynamics NAV 2009 and want to update it with the Hotfix, and you have already started transforming custom forms to pages.

  1. Export language modules for all pages.
  2. Export forms.
  3. Retransform the forms, including report request forms, in your development database to pages by using the new form transformation tool.
  4. Import pages.
  5. Import language modules for pages.
  6. Retransform the forms in your development database to pages by using the new form transformation tool.
  7. Import the transformed pages and report request pages.
  8. Import the language module into the development database.

List-page to Card-page relationship

To successfully create a logical relationship between a List page and Card page in RTC, perform the following steps:

  1. In Dynamics NAV classic client, go Tools || Object Designer || Page.
  2. Select the List page required || Click Design || Go to first blank line preceding the Field Controls
  3. Select the page properties (Shift+F4) || Page Properties Window Displays.
  4. In the Page Properties Window:
    1. Change the Value of Editable to NO.
    2. Change the Value of CardFormID to the Card Page required (Enter the object ID).
  5. Save and Compile the List Page.
  6. Test the List page :
    1. In Dynamics NAV 2009 SP1 –>> Select and Run the Object Designer :
      1. Double Click a Record, the Card Page for the Record Displays.
    2. Alternatively, In Dynamics NAV 2009 –>>  At Run cammand, type : DynamicsNAV:////runpage?page=<page ID> to invoke the Listpage
  7. The above simulates the logical relationship between Customer List and Customer Card in RTC.

Copy Text From Error Messages in NAV

An alternative to taking screenshot of an error message generated by Dynamics NAV is to copy the text.  This can be achieved by using keyboard shortcut CTRL + C (Copy)  on the Error. This is ideal for copying and pasting error messages when raising a support query where screenshot capture is not possible.

Example

Select the error, CTRL = C , Paste (CTRL + V )

Result:

—————————
Microsoft Dynamics NAV Classic
—————————
There is nothing to post.
—————————
OK
—————————

Error: Installing Database Component

When installing NAV 2009 database component on window server 2008 that has SQL server 2008 installed, the following error may occur:

Failed to connect to SQL database (-2147467259 master)

This error is typically triggered because when the local database was installed and then subsequently uninstalled, the SQL Server not available during the uninstallation. It is possible that SQL server was either uninstalled or was not running during the uninstallation.

This issue can be resolved by performing one of the following tasks:

1. Run the following command:

msiexec /x {B4222DEE-71BD-11DC-8BA7-C1C855D89593} SKIPUNINSTALLSQLDATA=1

2.  Install/start SQL Server and manually drop MantisSQLDB or MantisSQLDBEval database after

the uninstallation.

Source: http://msdn.microsoft.com/en-us/library/bb521687(WinEmbedded.51).aspx