Forum Discussion
VasanthVijay
Contributor
Active mean given connection string is to be connected to database and query need to be execute.
TanyaYatskovska
10 years agoSmartBear Alumni (Retired)
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.
- VasanthVijay10 years agoContributor
Using UDL its possible to check the connection string?
- TanyaYatskovska10 years agoSmartBear Alumni (Retired)
I 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.
- scsvel10 years agoFrequent Contributor
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.
Related Content
- 10 years ago
Recent Discussions
- 2 hours ago