When I try that code for the pubs database the connection fails, get the message

Not associated with a trusted SQL server connection.

This is very confusing as I am using my admin username and password in the ODBC wizard. I even changed my default database to the one I wanted and it isn't even displayed in the list.