How to have the semicolon character in a password for a SQL connection string?
Have you considered using SqlConnectionStringBuilder
?
var sqlBuilder = new SqlConnectionStringBuilder{ DataSource = "localhost", InitialCatalog = "mainDB", Password = "Y;9r.5JQ6cwy@)V_", UserID = "sqluser"};con = new SqlConnection(sqlBuilder.ToString());
Simply use like this.
con = new SqlConnection("Server=localhost;Database=mainDB;User Id=sqluser;Password='Y;9r.5JQ6cwy@)V_'");
Try using
Password='Y;9r.5JQ6cwy@)V_'
or
Password={Y;9r.5JQ6cwy@)V_}
See https://msdn.microsoft.com/en-us/library/windows/desktop/ms722656(v=vs.85).aspx