I am just trying to connect to a SQL db in a C# application. I'm not sure if there's a problem with my connection string or how it should be set up (specifically "server=" or if you know why the following wouldn't work), can anyone help?


SqlConnection myConnection = new SqlConnection("user id=username;" +
"password=password;server=host278.hostmonster.com; " +
"Trusted_Connection=yes;" +
"database=MyDBName; " +
"connection timeout=30");