3

I read different way of writing of connection string in article

http://www.connectionstrings.com/sql-server-2012

Can you please explain me where to use Server and where to use Data Source ? Similarly where to use Database and where to use Initial Catalog. Please explain in detail. I am new in SQL Server.

Improve this question
2
  • 2
    can't you try few combinations of those parameters and verify if works or not? what did you try and has failed/worked so far? Commented Oct 31, 2012 at 9:19
  • 2
    I think this experiment will give him false understanding and may be he continue to think that as correct forever. Commented Oct 31, 2012 at 9:26

2 Answers 2

Reset to default
2

Those connection string keywords can be used interchangeably. When ADO.Net is parsing the connection string, it will create a SqlConnectionStringBuilder class (in case of Sql Server) and map the keywords withing the connection string to the SqlConnectionStringBuilder properties.

For example, "data Source", "server", "address", "addr", and "network address" all map to the DataSource property -- you can use either one of those to specify the data source. Similarly, "Initial Catalog" and "database" map to the InitialCatalog property.

Take a look at the SqlConnectionStringBuilder class and its properties on MSDN where you can find more information on their keyword mappings.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

You can compose a valid ADO.NET connection string using different keywords. There are a lot of aliases, for example: "Data Source" and "Server" means both the same thing. The same for "Database" and "Initial Catalog".

You can find a list of valid keywords and their aliases here: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.