Rajesh,
Good morning! Glad to hear that you've solved your problem. However, I'm not sure if the MDAC 2.7 was your problem. I've been able to install the SQL Personal edition on WinXP using MDAC 2.5. But I guess it does not matter now. What is important is that it works!!!
Regards,
Martin
Shit happens!!!