Update - I made the code better here
Here is a code snippet I use to validate SQL connection strings:
/// <summary>
/// Checks a connection string for validity
/// </summary>
/// <param name="cn">SQL Connection string to validate</param>
/// <returns>True if connection is valid.</returns>
/// <history>
/// [Tim Hibbard] 12/03/2006 Created
/// </history>
public static bool IsValidSQLConnectionString(string cn)
{
bool RV = true;
try
{
if (!cn.Contains("Data Source"))
{
throw new MissingMemberException("Missing Data Source");
}
if (!cn.Contains("Initial Catalog"))
{
throw new MissingMemberException("Missing Initial Catalog");
}
if (!cn.Contains("User ID"))
{
throw new MissingMemberException("Missing User ID");
}
if (!cn.Contains("Password"))
{
throw new MissingMemberException("Missing Password");
}
string[] contents = cn.Split(char.Parse(";"));
if (!contents[0].StartsWith("Data Source"))
{
throw new MissingMemberException("Missing Data Source");
}
if (!contents[1].StartsWith("Initial Catalog"))
{
throw new MissingMemberException("Missing Initial Catalog");
}
if (!contents[2].StartsWith("User ID"))
{
throw new MissingMemberException("Missing User ID");
}
if (!contents[3].StartsWith("Password"))
{
throw new MissingMemberException("Missing Password");
}
}
catch (Exception)
{
RV = false;
}
return RV;
}