Thread: 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@earthlink.net