How to get access to an external database

Comments

• Options

  DenSter Member Posts: 8,304

  2005-01-06

  If you already have SQL Server, I'd consider moving your Navision to it as well. This way you can create a view in the Navision database into your external database, and create a linked table inside Navision. From there on it behaves exactly like a regular Navision table.

  Daniel Rimmelzwaan
  RIS Plus, LLC
  MVP - Business Apps

  0
• Options

  Arhontis Member Posts: 667

  2005-01-07

  Hello,
  
  If you want to go thru VALIDATE, INSERT e.t.c function of navision you can access i.e. SQL-Server with Automation. I include some code as an example:
  

  Variables:
  autSQLServer    Automation     'Microsoft SQLDMO Object Library'.SQLServer
  res    Automation    'Microsoft SQLDMO Object Library'.QueryResults
  
    //Connect...
    CREATE(autSQLServer); 
    autSQLServer.Connect(ServerName, Username, Password); 
  
    //Get Results
    res:=autSQLServer.ExecuteWithResults('SELECT anID  FROM databasename.dbo.Sometable WHERE anID >1000');
    MESSAGE(res.GetColumnString(1,1));
  
    //Disconnect
    autSQLServer.DisConnect; 
    autSQLServer.Close; 
    CLEARALL; 
  
  

  You can see in the SQL-Server help for other functions available.
  
  I have used it and it is fast...

  Regards,
  Arhontis
  
  https://forum.mibuso.com/search

  0