Reputation: 10723

DataSource parameter in connection string yields "Keyword not supported"

My code:

SqlConnection conn = new SqlConnection("DataSource=a;InitialCatalog=b;User ID=c;Password=d");

And I get error:

Keyword not supported: 'datasource'.

What to do?

Upvotes: 5

Answers (5)

Reputation: 339

There is a space in between data and source "Data Source=a;"

Upvotes: 2

Reputation: 2696

The usage is:

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

Upvotes: 6

Reputation: 49320

The keyword is "Data Source", with a blank.

Upvotes: 2

Reputation: 13057

It should be in this form:

Data Source=

Upvotes: 2

Reputation: 888293

Data Source is two words.

Upvotes: 7