How to get access to an external database

itsme

:?:
I'd like to read some external data from Navision. Mentioned data is accesible by a database view in an external MS-SQL database. Im am looking for ideas for a simple but effective solution. Navision is running with the native database.
Thanks for any ideas!

Markus

DenSter

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.

Arhontis

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...