Active mean given connection string is to be connected to database and query need to be execute.
AlumniIf 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?
AlumniI don’t know what exactly you mean by UDL. However, to check a connection string, you can use any tool/script/software that can connect to DBs.
If I got you correctly, You can check the connection status using
connObject.State
If its 0, not active; 1 means active and you can go and Query.
