Connecting to the SQL server on the Local Machine?

[itmasterw]

Trying ot connecting to the SQL server, which is in stalled on my computer. I ahve been able to do this if I leave out the server name aas follows:

Set adoConnect = New ADODB.Connection
adoConnect.ConnectionString = "Provider=SQLOLEDB;Data Source=;Initial Catalog=Sales;Integrated Security=SSPI;Persist Security Info=False;"
adoConnect.Open

* This works, but I was wondering why does it only work without the server name. If any one has an Idea I would apperaciate it.

 

[adroit]

Its obvious that its assuming the local machine as a default SQL Sever and thats why it does work without the
server name.

 

[itmasterw]

Thank you