Archive

Archive for November, 2015

Boot failure reboot and select proper boot device – Error connecting to VM – Hyper V

November 14, 2015 1 comment

I was getting below ‘Boot failure error’, while connecting to one of my VM with Windows Server 2012 OS, from Hyper V.

Hyper V Boot Issue

Hyper V Boot Issue

Reason & Fix

  • There could be many reasons for this problem. In my case below steps solved the issue.
  • I initially chosen ‘Generation 1’ while configuring VM.
  • Re-configuring the VM by opting ‘Generation 2’ solved my issue.

 

Hyper V - Generation options

Hyper V – Generation options

Refer article on how to decide between Generation 1 and Generation 2.

🙂

Categories: Misc Tags: , ,

Executing Informix DB Stored Procedure in SSRS

November 14, 2015 Leave a comment

Recently we got a requirement to pull the data from IBM Informix DB and prepare report using SSRS.

For who does not know what is Informix, refer here

Below are Stored Procedure details

Name: sp_getcustomersbycity

Description: Accepts date range and City codes as parameters and returns Customer result set.

Query Execution Syntax in SSRS:

{

call sp_getcustomersbycity(‘2015-09-30 20:00:00′,’2015-10-31 19:59:59′,’0′,’HYD,BLR’,null)

}

🙂

Categories: SSRS Tags: , ,