Re: “The ConnectionString property is invalid.” when I know it is valid

After posting this, I had a theory. I was switching between browsers getting
things setup for a demo. I changed my method to:

public bool IsValidUser(string username, string password)
{
int count = 0;

// Get the data from the iSeries
using (iDB2Connection conn = new
iDB2Connection(ConfigurationManager.ConnectionStrings["IbmIConnectionString"].ConnectionString))
{
string sqlStatement = "SELECT COUNT(XXXXXX) FROM XXXXXX
WHERE UPPER(XXXXXX) = @1 AND XXXXXX = @2";

iDB2Command cmd = new iDB2Command(sqlStatement, conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@1", username.ToUpper());
cmd.Parameters.Add("@2", password);
conn.Open();
count = (Int32)cmd.ExecuteScalar();
conn.Close();
}

return ((count == 0) ? false : true);
}

It seems to be working now. I wonder if that was the problem.

--
Mike Wills
http://mikewills.me


On Tue, Nov 30, 2010 at 1:15 PM, Mike Wills <mike@xxxxxxxxxxxxxx> wrote:

I am cross-posting this to StackOverflow[1] to hit up both communities.

I have an ASP.NET MVC application where the database is on the IBM i. I
have the application development close to completion when I started to get
a The ConnectionString property is invalid. error popping up:

1. only at log on
2. after the first successful log on after rebuilding
3. anyone logged on can still work normally

Also, note that this problem only shows up for one project in my solution.
The other project uses the exact same connection string and doesn't have
this problem (copied and pasted to be 100% sure). I am in active development
on these projects, but have not touched the connections strings nor worked
with the AccountController and related model classes after getting the login
working.

I am using Visual Studio 2008 and .NET version 3.5.

Any ideas?

[1]:
http://stackoverflow.com/questions/4317514/the-connectionstring-property-is-invalid-when-i-know-it-is-valid
--
Mike Wills
http://mikewills.me