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