Connecting the database without specifying server?

Question

Database=xxx;User ID=xxx;Password=xxx;

Why this connection string works without specifying server /data source. This connected MS SQL SERVER (running in local) from windows app

private static string connectionstr = "Database=xxx; User ID=xxx; Password=xxx;"; 
public void connect()
{ 
    scon = new SqlConnection(connectionstr);
    scon.Open();
}

private static string connectionstr = "Database=xxx;User ID=xxx;Password=xxx;"; public void connect(){ scon = new SqlConnection(connectionstr);scon.Open();} — Asish Pv
– Asish Pv, Commented Jan 28, 2014 at 12:56
it works fine and connected the database without give server/data source, the sql server in local.why? — Asish Pv
– Asish Pv, Commented Jan 28, 2014 at 12:57
See my answer, note its a better to explicitly declare server / datasource as on different platforms you might have issues related to loop-back and more. — Ofiris
– Ofiris, Commented Jan 28, 2014 at 13:10

Ofiris · Accepted Answer · 2014-01-28 13:01:36Z

4

Creating SqlConnection with a connection string which has no DataSource results in a default value which is an empty string ("").

empty string ("") will be translated later to localhost, try ping "" from cmd and see you actually pinging localhost.

See MSDN SqlConnection, Remarks section - DataSource initial value is empty string ("")

answered Jan 28, 2014 at 13:01

Ofiris

6,1716 gold badges38 silver badges59 bronze badges

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

Comments

Nagaraj S · Accepted Answer · 2014-01-28 13:04:08Z

0

The default host name is your localhost.So it will connect your localhost without specifying servername MSDN

answered Jan 28, 2014 at 13:04

Nagaraj S

13.5k6 gold badges35 silver badges53 bronze badges

1 Comment

Nagaraj S Over a year ago

@AsishPv If my answer is useful make upvote or mark as useful

Collectives™ on Stack Overflow

Connecting the database without specifying server?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related