1

Why are some connection strings Data Source = address; Initial Catalog = dbname;.... while others are Server=address;database=dbname;...? What is the difference between using "Data Source" and "Server"?

Shantanu Gupta
  • 20,688
  • 54
  • 182
  • 286
user22119
  • 717
  • 1
  • 4
  • 18

2 Answers2

0

Please see below link, hope you will easily get answer to your question.

https://www.connectionstrings.com/sql-server/

"Server" vs "Data Source" in connection string

http://msdn.microsoft.com/en-gb/library/system.data.sqlclient.sqlconnection.connectionstring.aspx

Community
  • 1
  • 1
Siddique Mahsud
  • 1,453
  • 11
  • 21
0
there is no difference between Server and Data Source as they represent 
the same thing for SQL Server : the full name of the SQL Server instance with 
the syntax "MyComputerName\MyShortInstanceName" , potentially including the 
port used by the SQL Server instance to communicate.

Data Source
-or-
Server
-or-
Address
-or-
Addr
-or-
Network Address

the are synonymous

what is the difference between using data source = and using server = in connection string

“Server” vs “Data Source” in connection string

SqlConnection.ConnectionString Property

Community
  • 1
  • 1
Nagaraj S
  • 13,316
  • 6
  • 32
  • 53
  • How about any other provider like Oracle or TeraData. Which was is standard or which one will work for most of the DB providers? Any references will be greatly appreciated – Shantanu Gupta Feb 15 '14 at 06:09
  • https://www.connectionstrings.com/oracle/ – Nagaraj S Feb 15 '14 at 06:12
  • http://msdn.microsoft.com/en-us/library/system.data.oracleclient.oracleconnection.connectionstring(v=vs.110).aspx @ShantanuGupta – Nagaraj S Feb 15 '14 at 06:13
  • @Nagraj: I know connectionStrings site. I am particularly interested in knowing if there is some standard defined or some sort of guidelines defined which is commonly used between different providers. – Shantanu Gupta Feb 15 '14 at 06:28