Trace Flag 4616

6 June 2008 iby 2

When using Navision (Dynamics NAV 5.0 or higher) with SQL 2005 (express or full) – you will receive a trace flag error, when trying to create a new database, unless you already has changed your […]

Using SQL Views in Navision

14 May 2008 iby 3

Did you know that it is possible to use views in Navision? If you often are collecting/viewing data from several tables it can be usefull to use a SQL View. Created SQL Views can then […]

No Picture

ADORecordSet

28 February 2008 iby 0

Hi ! This is a detailed description for the used ADORecordSet command mentioned in the articles Stored Procedures and Navision and ADO in Navision. ADORecordSet The ADO RecordSet is defined by the automation ‘Microsoft ActiveX […]

No Picture

ADOCommand

28 February 2008 iby 0

This is a detailed description for the used ADOCommand command in the articles Stored Procedures and Navision and ADO in Navision. ADOCommand The ADO Command is defined by the automation ‘Microsoft ActiveX Data Objects 2.8 […]

No Picture

ADOConnection

28 February 2008 iby 0

Hi ! I have been asked to describe the different ADO commands parameters more explicit. So here are a detailed description for the used ADOconnection command in the articles Stored Procedures and Navision and ADO […]

No Picture

Stored Procedures and Navision

21 February 2008 iby 0

If you are executing a specific SQL query very often, it would be usefully to have it as Stored Procedure on the SQL Server. Stored Procedures is a collection of SQL statements. There are 2 […]

ADO in Navision

20 February 2008 iby 5

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 […]

No Picture

ADO.NET

19 February 2008 iby 0

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 2