Ashish
It is very likely that your application will need to reconnect to the SQL Server. When the machine goes down and then fails over your connections will be killed.
This is my experience with VFP (and other apps as well) and SQL Server clustering
Rodman
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.