Specifying Connection Properties

You can supply much of the information specified by a connection string by setting properties of the Connection object before opening the connection. For example, you could achieve the same effect as the connection string discussed in Creating a Connection String by using the following code.

With objConn  
.Provider = "SQLOLEDB"  
.Properties("Data Source") = "MySqlServer"  
   .Properties("Integrated Security") = "SSPI"  
.Open  
.DefaultDatabase = "Northwind"  
End With  

DefaultDatabase is set only after you open the connection.