I need a free and quick to download program that can test a connection string.
State == ConnectionState. Closed) { //Connection is closed } else { //Connection is open in some way } ? This way if the connection is null it's also "closed".
You can make one yourself in 20sec. For example in C#
- Create a new WinForms application
- Create a new SqlConnection(connectionString)
- Exception => Bad connection string
- All ok => Good connection string
SqlConnection conn = null;
try {
conn = new SqlConnection("connection string here");
conn.Open();
// Good connection string
} catch (SqlException sqlE) {
// Bad connection string
} finally {
if (conn != null) conn.Dispose();
}
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With