sql question

Using vb6 and ado 2.1 if I open a connection string like so:

Public Sub setup()

Dim cnn1 As ADODB.Connection
Dim rstEmployees As ADODB.Recordset
Dim strCnn As String
Dim varDate As Variant

' Open connection.
strCnn = "Provider=sqloledb;" & _
"Data Source=srv;Database=db; "
Set cnn1 = New ADODB.Connection
cnn1.Open strCnn

End Sub

Will this code still try to send the username (machine name) to the sql
server for authentication even though it is not explicitly sent here?

Also, If the Provider is not specified, does the system revert to an
odbc driver vs the ole driver?

Please email if possible:

rutledgj(at)earthlink(dot)net