NAV 2009 R2 RTC client accessing different DB on same pc

Comments

• Options

  mik Member Posts: 79

  2011-08-31

  Hi,
  let me see if I understand correctly. You want to open two different databases with one RTC Client? One on your machine and the other one on a server? :?:
  
  Try the following:
  Create a <MyServiceName>.config File with a texteditor.

  <?xml version="1.0" encoding="UTF-8"?>
  <configuration>
  <appSettings>
      <add key="Server" value="<YOUR_MIDDLETIER_SERVERNAME_HERE>" />
      <add key="ServerInstance" value="<YOUR_SERVICE_INSTANCE_NAME_HERE>" />
      <add key="ServerPort" value="<YOUR_PORT_HERE>" />
      <add key="DelegationInfo" value="DomainUser" />
      <add key="AllowNtlm" value="false" />
      <add key="ServicePrincipalNameRequired" value="true" />
  </appSettings>
  </configuration>
  

  
  Create a shortcut for your RTC Client. Edit the properties of this shortcut to something like this ...

  "C:\Program Files\MBS_All_Versions\Navision 6.01\60\RoleTailored Client\Microsoft.Dynamics.Nav.Client.exe" -settings:"<PATH_TO_YOUR_CONFIG_FILE>\<CONFIG_FILENAME>"

  
  Also have a look at this http://msdn.microsoft.com/en-us/library/dd301254.aspx

  ---

  With kind regards
  mik

  0
• Options

  Gianfranco Member Posts: 8

  2011-08-31

  Hello Mik,
  
  thanks for your quick help.
  The two databases should be on the same notebook where the client is.
  Would your solution work?
  
  Till now, I've been using the classic client to develop on different databases on my pc and then export fob to customers SQL servers DB.
  Now I'd like to do the same with the RTC but I must be able to create and access different DB in the same way: close one and open another, etc.
  It is not necessary to have two DB open simultaneously.
  
  Thanks again.

  0
• Options

  Sog Member Posts: 1,023

  2011-09-01

  Any NAV server can only access one database at a given time.
  You have 2 choices to access multiple databases: either shut down the service, modify the config file to access the different server and restart the service. (With a bit of programming here and there you can automate this)
  Or have a service for each database.

  |Pressing F1 is so much faster than opening your browser|
  |To-Increase|

  0
• Options

  mik Member Posts: 79

  2011-09-01

  Hi Gianfranco!
  
  I have two posts for you. (in german :? )
  
  Here is a tool where you can easy install more service tiers on one machine.
  That is necessary if you want to access both databases at the same time.
  http://www.dynamicsblog.at/index.php/2008/12/06/tag-6-dynamicsblog-adventkalender-nav-20
  
  Here is another solution. But you can build this one by yourself.
  In your case create two config files one for each database. Modify the batch files for your environment. That batch file stops the service, changes the config file and starts the service again.
  So you can switch databases with only one installed service. Its only a bit quicker then doing this by hand.
  http://www.dynamics-community.at/post/2010/02/12/NAV2009-Workaround-Mehrere-NAV-2009-Datenbanken-mit-einem-NAV-Server.aspx
  
  Both things work fine. If you need more information feel free to ask.
  
  greetings mik

  ---

  With kind regards
  mik

  0
• Options

  Gianfranco Member Posts: 8

  2011-09-01

  Thanks to Google traslator (German is difficult!! :roll: )
  
  I'll try this solution that seems exactly what I needed.
  
  Thanks again.

  0