key word not supported "data source" ,what's the error i it?

Question

label1.Text=textBox1.Text;
string providerName = "System.Data.EntityClient";
string connection = "datasource=students.mssql.somee.com;port=4096;username=someusername;password=somepassword";
SqlConnection Conn=new SqlConnection(connection);
SqlDataAdapter DataAdapter=new SqlDataAdapter();
SqlCommandBuilder cb=new SqlCommandBuilder(DataAdapter);
Conn.Open();
MessageBox.Show("Connected!");
Conn.Close();

You may have posted your password. you should change that immediately. — DWright, May 13 '15 at 04:40
Besides everything else, you should also reference the `SqlClient` - not the `EntityClient` - in your provider name: `string providerName = "System.Data.SqlClient";` — marc_s, May 13 '15 at 05:02

score 3 · Answer 1 · answered May 13 '15 at 04:42

3

In your connection string datasource is a single word seperate with a space as below and try.

string connection = 
    "data source=students.mssql.somee.com;
    port=4096;username=*******;password=*******"

answered May 13 '15 at 04:42

Sachu

7,555
7
55
94

score 0 · Answer 2 · answered May 13 '15 at 04:47

Check your connection string

Remember to try catch

label1.Text=textBox1.Text;
string providerName = "System.Data.EntityClient";
string connection = "datasource=students.mssql.somee.com;port=4096;username=mhs_SQLLogin_1;password=gtwhp7td39";
try{
SqlConnection Conn=new SqlConnection(connection);
SqlDataAdapter DataAdapter=new SqlDataAdapter();
SqlCommandBuilder cb=new SqlCommandBuilder(DataAdapter);
Conn.Open();
MessageBox.Show("Connected!");
Conn.Close();
}catch(Exception ex){
}

key word not supported "data source" ,what's the error i it?

2 Answers2