Archive for October, 2010


Ninja Lite Database for free – coupon code

 

Ninja-Database-Lite

Ninja Database Lite is a light and nimble database for Windows Phone 7, Silverlight 3, Silverlight 4, .NET 3.5, and .NET 4.x

you can download the full feature list here.

You can get Ninja Database Lite Single Developer License for free until midnight October 31st, 2010; a $49.99 value.

Use coupon code :  twitterninja

Steps :

  1. Go to http://www.kellermansoftware.com/c-9-windows-phone-7.aspx
  2. Select Add To Cart for  Ninja-Database-Lite -Single Developer License2010-10-30_1515 
  3. Enter Coupon code twitterninja in coupon code and click Checkout Now2010-10-30_1517
  4. Go register and checkout
  5. Complete the registration form.
  6. Click Create account and checkout.
  7. It will not ask you for making payment or credit card information since your effective amount to be paid is zero.
  8. Done…

Spread the word and enjoy.


Excel do not allow number more than 15 digits

images

Excel is excellent. No doubt about that. But excellence does not mean that, it will not have glitches. So Excel also have few !!!

Recently, We wrote a small data migration utility for our clients which reads data from Word file and store it in excel. The entries included Credit Card numbers which has 16 digits.

In all surprises, Excel was doing magic. When you enter a number greater than 15 digits, Excel rounds it off and you get zeros padding the end of your number.

Example :

Enter the number

234587654567123456 in Excel

and you get this

234587654567123000

 

answer          Solution:

Excel supports 15 digits of precision in its cells. Credit card numbers are usually 16 digits.For identifying numbers, you should enter them as text. To enter a number as text, precede the entry with an dash (-) or format the cell as Text (Format>Cells>Number) before you enter the number.

Note : Tested and replicated in Excel 2007, Excel 2010


Access is denied. (Exception from HRESULT: 0x80070005(E_ACCESSDENIED)) – Parallels PLESK 9.3 – Solved

Godaddy Virtual Dedicated machine, Windows server 2008, PLESK 9.3, New Web application setup and I was greeted with below YSOD.

 

2010-10-27_1403

Problem :

As the error message said, Access is denied. It means that the user account under which asp.net is running is trying to access resource without having sufficient permissions on that resource.

Solution :

1. Login to your Virtual Machine using Remote Desktop ( mstsc )

2. Go to “C:\plesk\etc\DiskSecurity” folder

3. Edit disksecurity.xml file. Add following entry at the end ( before </Entries> )

<Entry AccounType="1" Account="Psacln" Path="C:\Windows\assembly" AceFlags="FilesOnly" AccessMask="Read" EntryFlags="0x0" />

4. Save.

And you are done… Enjoy…


GMail – Run Out of Space

2010-10-26_1606 GMail is arguably the most effective email solution existing today on the planet. They are damn good and rolling interesting features every day. But what makes them unique is the core line

“Among crowded features they always remember, people use Gmail for email services and they always make it priority when designing new features.”

I use Gmail as my document repository, my chat history ( gTalk is awesome, when it comes to chat ), my scheduler and oxygen ( Yes, No doubt, I can not live without it until I will find better oxygen).

I have started using Gmail from 2005 and now its friendship of more than 5 years, and truly, Gmail is a great friend. It gives you ample space to use as mail repository in free edition, but free is not always enough when you are using it like oxygen. Currently they are giving away more than 8 Gigs of space for free usage which includes GMail, Picasa, Google Docs and other Google services  you use which requires storage.

Recently my Gmail started to show me warning that I am almost out of space ( 95% usage )

AlmostOutOfSpace

I deleted few emails permanently from my Life ( it is bad ) but in  just two more days ( in that period my clients used to send me video attachment of 15 MB ), I got this message from gMail

RunoutGMAil

and as they have indicated in the warning, I was not able to send or RECEIVE emails, so I have decided to purchase additional storage rather than deleting few more emails. So I went through the process of purchasing additional email storage.

The Process :

1. Click on purchase additional storage

2. You will be given choice of plans available and their prices.

20 Gigs additional storage for 5 USD per year is not bad deal at all  ( It means now you will have 20 Gigs new purchased storage + the more than 7 Gigs of Basic storage that comes for free with every account = more than 27 Gigs of storage )

2010-10-26_1600

3. Click on Buy 20 Gb for $5.00 per year.

4. Proceed through Google  CheckOut

5. Done… But it will take 24 hours to get that space added to your account.

Now enjoy GMail.