Hi Vasanth,
Connection string is just a description (metadata) of the parameters and their values required to establish the connection to the database and thus it (connection string) can be neither active nor inactive.
It is possible to apply the given connection string to some object that is supposed to connect to the database (ADO Connection, ADO Recordset, UDL file, etc.) and try to establish connection. If connection attempt succeeds, this means that the connection string is correct. If you already have an object with applied connection string (e.g. ADO Connection), the object usually has a property or a method (e.g. .Active) that may be used to determine if the connection to the database is open and active or closed.
Does this help?
