Monday, January 30, 2012

The backup set holds a backup of a database other than the existing database

Yesterday I received a database backup from my client and he told me to restore it to current database. I asked him how much time I have. Being from non-technical background, he said you 1 full day to do this and I was so happy. I was quite sure that, restoring database backup is of 5 minutes job using SQL Server Management Studio.
So needless to stay, whole day I was in table tennis room. It was only half an hour remaining for end of day, I came to desk and tried to restore the backup and I received following error – 
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'MySQLServerName.  (Microsoft.SqlServer.SmoExtended)
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'MyDBName' database. (Microsoft.SqlServer.Smo)
Error Id -3154
I was trying to restore my backup from SSMS only and I received this error every time I tried to restore.bak file.
Solution –There are two ways by which you can restore .bak file in SQL Server 2008 

Thursday, January 26, 2012

Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed

SSRS…Wonderful technology!!!
When you receive errors while development using SSRS 2008, you start understanding how wonderful it is…
Moral of the story, I received following error when I was trying to view some of the reports after configuring my Report Server - Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.
There are few concrete steps mentioned below which will resolve this error –
1.     Start Internet explorer and on “Tools” menu click “Internet Options”.
2.     Click “Security” – “Trusted Sites” – “Sites”.

3.     Under “Add this Web site to the zone”, type http://your-server-name. Make sure the uncheck the checkbox labeled as “Require server certification (https:) for all sites in this zone”. Then click ADD.

Thursday, January 12, 2012

An error occurred creating the configuration section handler for loggingConfiguration: Could not load file or assembly 'Microsoft.Practices.EnterpriseLibrary.Logging, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

I don’t understand why my client loves Enterprise Library. He is just mad about it. So people, I was trying to implement Enterprise Library in my application and suddenly I received the following error –
An error occurred creating the configuration section handler for loggingConfiguration: Could not load file or assembly 'Microsoft.Practices.EnterpriseLibrary.Logging, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
I know, I know, many of us get this type of error ample times for different assemblies and every time when we face it; we don’t have a concrete solution.
Alright so here I am presenting you a concrete solution which is good and fantastic and a real time saver.
To resolve above painful error we need to use – fuslogvw.exe tool – Assembly Binding Log Viewer.

Monday, January 9, 2012

What is Near Field Communication - NFC

Diabetes patients always have to check the sugar level in blood. Carrying sugar level checking machine everywhere is not possible. But everybody carries mobile with them. What if your mobile has an ability to check the blood sugar level?
Your wife is on shopping. She is in a shop looking at wonderful jeans she always dreamed and suddenly she founds her wallet empty. Now being a poor husband you don’t want to hurt her and out of fear you are ready to give more money, but you found yourself out of cash and no ATM center nearby so that you can go to the ATM, withdraw money and pay the bill. You have the mobile in your hand. What if mobile has an ability to give money to your wife account?
You and your family have decided to go for a vacation with no prior planning. As a matter of fact you want to get the railway tickets. Queue is huge and no possibility of reaching to ticket counter for next few hours. You have the mobile. What if you hold your mobile phone in front of a device and you get the tickets immediately within seconds?
Your colleague is in office working hard to solve a problem. You are on vacation. He calls up you and discusses the problem as he is real need to solve it. You understand problem and draws a solution on paper. Now you need to send this drawing to your collegue but you don’t have scanner not the computer and internet connection. You have mobile. What if you scan the drawing and send the file immediately from your mobile itself?
All anecdotes described above are quite easily possible now with new buzz word in technology – NFC Technology.
NFC technology is slowly acquiring every industrial field including medical field as well.

What is NFC?
NFC stands for “Near Field Communication”. NFC is another form of wireless technology. Very much similar to current wireless technologies like Infrared, Bluetooth; NFC is short ranged wireless telecommunication technology.
NFC is new form RFID (Radio Frequency Identification). The typical use of RFID you must have seen outside ATM where no security guard is present. You have to hold you card in front of sensor and door opens automatically. This sensor and card uses RFID.
NFC allows a device to collect and interpret data from another closely location NFC device or tag (panel). NFC uses loosely coupled inductive circuits to exchange power and data (or information) over a short distance usually less than 10 centimeters. NFC tags are passive device and data stored can be retrieved using active devices. NFC tags can be produced at cheaper costs and they get embedded nearly in anything like sticker, posters, glass etc. Especially in Europe and Japan you will find NFC tags in stores used for payment option.

Saturday, January 7, 2012

Olympus India – Olympus SZ-30MR review and India price

Electronics field is bringing impossible to possible. Electronics is the only field where today’s dream is tomorrow’s reality. Many times it has been observed that, many inventions look impossible for current science and technology. However those inventions take shape and come in to reality in future.
Few years back, people felt that 10x optical zoom camera is the highest inventions in camera one can achieve. But the reality is different. People are not even thinking buying camera below 1x optical zoom. Same is the case with megapixels. 8 megapixels was the limit but today camera with 8 Mega pixels is considered outdated.
More the Pixels, Worse the Image
The digital cameras means fixed lens digital cameras were facing unique problem. If you increase the megapixels limit then picture clarity gets diminished. Same difficulty was also observed in digital zoom and optical zoom. As optical and digital zoom increased, picture clarity was affected. Obviously before 5 years, doubling the megapixels capacity or doubling zoom capability for fixed lens digital camera was impossible. 
Why?
Well Gadgets are becoming more and more compact and camera is no exception to the compact taste of customers. So the compact cameras have to be small and reasonably priced. To cater this need, small image sensors were used in the cameras. Now if I want to increase the pixel count then I have to divide the sensor in smaller and smaller parts. This decreases sensitivity of camera and increases noise in the picture taken as amount of light collected by pixel is smaller.

Also if you plan to increase pixel, resolution gets increased. So fulfil this need, better lenses with higher resolution capability required which are bigger in size and hence cannot fit in small and compact cameras.

 Problem solved
Obviously, if you wanted to make fixed lens camera small pocketsize with high pixels, was next to impossible.

However, technology always keeps changing. Olympus SZ-30MR addresses these problems of lens size, pixels size and zooming.