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.
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.
Refer article on how to decide between Generation 1 and Generation 2.
🙂
Categories: Misc
Boot Failure, Generation, Hyper V
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
Informix, SSRS, Stored Procedure