Forum Discussion

VasanthVijay's avatar
VasanthVijay
Contributor
10 years ago

How to check the connection string is active or not?

Hello,           I have a conneciton string ="Provider=SQLOLEDB.1;Password=*****;Persist Security Info=True;User ID=**;Data Source='*****". How to Check the Above connection string is active or no?...
VasanthVijay's avatar
VasanthVijay
Contributor
10 years ago

Active mean given connection string is to be connected to database and query need to be execute.

TanyaYatskovska's avatar
TanyaYatskovska
Icon for Alumni rankAlumni
10 years ago

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.