Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.80K
1 Posted Topic
cnsrvlist3.open "Provider=SQLOLEDB.1;Data Source="& strDrserver &";Integrated Security=SSPI" msgbox("ABC") msgbox(cnsrvlist3.state) cmdsrvlist3.activeconnection = cnsrvlist3 I am trying to check the state of connection, The code works fine if the connection is fine but when any Database server is down then in that case the state should come as 0 instead of that it …
The End.