NFA - Custom Reporting Server Error 500 - Internal server error ODBC

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

When trying to load an ASP page in NFA and you receive a 500 error and the URL could turn to this:

http://127.0.0.1/Error.asp?number=-2147467259&desc=%5BMicrosoft%5D%5BODBC+Driver+Manager%5D+Data+source+name+not+found+and+no+default+driver+specified&source=/customReportWiz.asp_dbConn&severity=9&user=

Environment

All versions of NFA 9.1.x and higer.

Cause

This is caused by the Session State being set to disabled in IIS.

Resolution

Found issue was that each NFA WebSite in IIS's ASP feature had the Session Properties > Session State set to False. We set it to true and all works fine now.

1. Open IIS and click on your server under 'Start Page' and then double click on the ASP feature. 

2. Expand out Session Properties and make sure Enable Session state is changed from 'False' to 'True' and then click apply on the right side pane. 

ASP pages should load fine now.