I am using a standard connection like this for DSNless connection is SQL Server. I am still always prompted for Username and password. When I look at the table and connection string - it does reference ODBC; driver....etc. I believe if I took ODBC off of the string I received a diferent type of error.
Right now I am getting a 2800 error - I believe...
oConn.Open "Driver={SQL Server};" & _
"Server=MyServerName;" & _
"Database=myDatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"