Skip to main content

Navision Classic Client - Shortcut Points to a specific Database.

Hi all,

Just a small Post, but this was asked to me by lot of peoples, so planned to keep user updated.

Most of you might know it.

Consider a scenario where company have two databases, say a Live Database and Test Database.

Each database have multiple companies.

Now client ask you to create two shortcuts which Points to Live & Test Database receptively and opens a specific company.

So below is way how you can do that -

1. Right click on say desktop and select new shortcut.


2. It will ask you the command name or path that you want to execute via this shortcut.

3. Let's see how to create command.

  a) Provide the path of Exe where it is located in your drive.

     * In My case the exe is located in "C:\Program Files (x86)\Microsoft Dynamics NAV\60\Classic\finsql.exe"
     * Mandatory parameter.

  b) Now I Require to provide server Name.(Parameter Server Name)

     * In My Case its TestServer.
     * Mandatory Parameter in case of Database on SQL Server.

  c) Now I Require Parameter i.e. database Name. (Parameter Database) -

     * In My Case its Demo Database NAV (6-0).
     * In case of Native database Specify complete path with database name.
     * Mandatory Parameter.

  d) Now I Need to provide the company Name. (Parameter Company)

     * In My Case Company is Cronus India Ltd.
     * Additional Parameter Required if you want to open a company.

  e) Now I need to provide the authentication type. (Parameter NTAuthentication) 

     * ntauthentication have value 1 & 0 for Windows & Database Login Respectively.
     * Additional Parameter Required if you want to Specify authentication, if not specified it take information based on zup file.

  f) If required we can also specify Net Type. (parameter NetType).

     * I will be using Net Type as TCP.
     * Additional Parameter Required if you want to NET TYPE, if not specified it take information based on zup file.

  g) If you require to specify the path of zup file. (Parameter ID).

     * Parameter is not mandatory.
     * Additional Parameter Required if you want to Specify ZUP File.

So my complete command without zup file is - (Remember parameter are separated by (Comma and a space).

NATIVE DATABASE- 

"C:\Program Files (x86)\Microsoft Dynamics NAV\60\Classic\fin.exe" database=D:\NAV 6.0 R2 IN\Database\database.fdb, COMPANY="CRONUS India Ltd.", ntauthentication=1, nettype=tcp

SQL DATABASE -

"C:\Program Files (x86)\Microsoft Dynamics NAV\60\Classic\finsql.exe" servername=TestServer, database=Demo Database NAV (6-0), COMPANY="CRONUS India Ltd.", ntauthentication=1


4. Copy the complete command in the shortcut window as shown below.


5. Provide a friendly name to shortcut.


6. click Finish and shortcut is ready on your desktop.

7. You can replace the server name, database name, company name in above command and create as many shortcuts as you want.

In Next Post we will see how to open a specific object via a shortcut.

Regards,
Saurav Dhyani

www.sauravdhyani.com

Comments

Popular posts from this blog

BC 21 and Higher - PowerShell Cmdlet (Replacement of Business Central Administration).

Hi Readers, As discussed in last article about deprecating of Business Central Administration, there are few common actions that we use in administration till Business Central 20. For our on-prem customers, we will still require doing activities. As Microsoft suggest we need to start using PowerShell cmdlet.    Let's see how to do those via PowerShell, or Administration Shell. I will be keep adding commands as you comment to this article.

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

MSDYN365BC - Data Upgrade To Microsoft Dynamics 365 Business Central on premises.

Hi Readers, We have already talked about the number of steps for upgrading to Business Central on Premises from different NAV versions. After that article, I received multiple requests for an article which list down steps for Data Migration. In this article, we will discuss steps of data migration to MSDYN365BC (on-Prem) from NAV 2017. For this article, I am considering a Cronus Demo Database without any customization. For an actual upgrade project, we will have to complete object merge using compare and Merge process. After the Merge Process, the next step is data migration. Let's discuss those steps. Direct Upgrade to Microsoft Dynamics 365 Business Central (on-Prem) is from following versions - 1. NAV 2015. 2. NAV 2016. 3. NAV 2017. 4. NAV 2018.