开发者

ADO.NET SqlClient connection string - Data Source syntax

开发者 https://www.devze.com 2022-12-15 16:09 出处:网络
Is there any official write-up what forms can Data Source field take in sql server connection string? I\'m aware of following forms:

Is there any official write-up what forms can Data Source field take in sql server connection string? I'm aware of following forms:

SERVER
SERVER\Instance
tcp:SERVER,port
nb:SERVER
nb:SERVER\Instance

are there more forms?

EDIT: The essence of this exercise is not to construct a connection string. I am trying to parse existing connection string, and I want to know all the forms it could take. I appreciate everybody who pointed me to www.connectionstrings.com, and this site is useful enough, but it clearly does not have all the information. For example, it will not specif开发者_开发知识库y that it is possible to use construct like "Data Source=tcp:SERVER,10000" to specify that TCP must be used for this datasource on port 10000.


check this website for all connection string questions: http://www.connectionstrings.com


This website has more than you could possibly ever want to know about connection strings for SQL Server and many other databases:

Connection strings for SQL Server 2005

0

精彩评论

暂无评论...
验证码 换一张
取 消