TechBlog

With ADO you can execute SQL Scripts and Stored Procedures from Navision.

To use ADO in Navision, you have to use the automation “Microsoft ActiveX Data Objects 2.8 Library”

Lets take a closer on how to make a SQL connection and perform a SQL Query in Navision.

Read the rest of this entry »

For test purpose I did a little test in C#, where I did use ADO.NET to make a connection to my SQL Server.

The common way to access a database is to do the following:

1. Open a connection to the Database
2. Perform the Query using a recordset for the returned data
3. Extract Data needed and close the recordset
4. Close the connection

Lets take a close look on how to do it in C# ADO.NET

Read the rest of this entry »