Hi Vasanth,
What do you mean by connection string is active?
Active mean given connection string is to be connected to database and query need to be execute.
If you just want to check if this connection string works, you can try to create a test DBTable checkpoint and put your connection string there. Other way is to do this from script. Please read the Working With Databases Using ADO and BDE Objects ( http://smartbear.com/viewarticle/67763/ ) article for details.
Using UDL its possible to check the connection string?
