Using VS.NET 2005 & SQL Reporting Services with Nav ODBC

matthewl

Hi all,

I am trying to integrate SQL Reporting Services 2005 with Navision. I have a native Navision 4.0 SP2 database that contains my data. I have created a Navision ODBC data source that points to this database.

In Visual Studio .NET 2005 I have created a new reporting project and added a reporting data source that connects to my Navision database using the Navision ODBC. I have then created a report that just pulls back a list of customers from the Navision Database.

When I run the report my Visual Studio .NET crashes and dissapears.

Has anyone had any difficulties in using the Navision ODBC with SQL Reporting Services or VS.NET 2005.

Thanks in advance,

Matthew

fatewong

Since you are using Navision 4.0 SP2, I will suggest to develop your .NET application using CFRONT.NET instead of N/ODBC.

Firstly, N/ODBC is slow compared with CFRONT.NET on its data retrieving speed. You can code your application by the comprehensive API too.

Second, if you are dealing with multi companies database, CFRONT.NET allows you to open different company in coding dynamically while you need to create different DSN for each company by using N/ODCB.

matthewl

Well I don't think I would be able to use CFRONT.NET as I am trying to preview a report that will be hosted on SQL Reporting Services. SQL Reporting Services requires me to use an ODBC connection for my database.

I have actually managed to get a step nearer. Once I have finished designing my report in Visual Studio .NET 2005, I preview it and it still crashes. If I upload my report to the reporting server however, I can see my report there! It seems to be an issue with Visual Studio .NET 2005.

Thanks

Marije_Brummel

Maybe a look at this site wil provide some help.

http://blogs.msdn.com/clausba/