Connect Navision SQL Server's database & Visual Basic

Comments

• Options

  kriki Member, Moderator Posts: 9,089

  2007-07-25

  [Topic moved from Navision forum to SQL General forum]
  
  A Navision on SQL DB is just a SQL DB. Search for ADO to find how to do it in Visual Basic (best search in the VB-help or a VB-forum)

  Regards,Alain Krikilion
  No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
  
  

  0
• Options

  DenSter Member Posts: 8,304

  2007-07-25

  Be careful though, and only use ADO to read from core NAV tables. When you insert/modify records in a NAV database on SQL Server, crucial business logic will not be processed. If you need to integrate with NAV, I suggest you write to staging tables and have a NAV process take it from there, to ensure that business logic is executed.

  Daniel Rimmelzwaan
  RIS Plus, LLC
  MVP - Business Apps

  0