SqlConnection ..what Should I Expect ??

Hi all,

I'm trying to connect to my SQL SERVER 2000 database via Sqlconnection command with the code below,do I need to do something else to make sure the database is really opened ..I keep getting error at

conn.Open(); which I dont know what do about ..

any help will be really appreciated



using (SqlConnection conn = new SqlConnection("Server=" + dbServer+";Database="+dbDatabase+";"))

{

conn.Open();

SqlCommand cmd = conn.CreateCommand();

cmd.CommandText = "SELECT * FROM LOCATIONS";

cmd.ExecuteNonQuery();

conn.Close();

}





thanks

Alaa M