Forum Discussion

VasanthVijay's avatar
VasanthVijay
Contributor
11 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?...
TanyaYatskovska's avatar
TanyaYatskovska
Icon for Alumni rankAlumni
11 years ago

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.

scsvel's avatar
scsvel
Frequent Contributor
11 years ago

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.