We just delivered our first VB6-SQL Server app. The client reports the following error when opening the connection:

[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified

We declare the following in the sub main():

Public MyConnection As New ADODB.Connection

Our connection code look like this:

Code:
    With MyConnection
        .ConnectionString = "  Driver={SQL Server};" _
                            & "server=" & sServername & ";" _
                            & "Database=" & sDatabase & ";" _
                            & "uid=" & sUserID & ";" _
                            & "pwd=" & sPasswd
        .Open
    End With
His email to me states:
"I have the DNS set up properly, I don't know if there is something in the code pointing somewhere?"

Can anyone help???

Thanks