¡¼ODBC 
 
¡¼Standard Security 
  
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; 
 
¡¼Trusted connection 
  
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=Yes; 
 
¡¼Prompt for username and password 
This one is a bit tricky. First you need to set the connection object's Prompt property to adPromptAlways. Then use the connection string to connect to the database.   
oConn.Properties("Prompt") = adPromptAlways

Driver={SQL Server};Server=myServerAddress;Database=myDataBase; 
 


¡¼¡³¡µ¡º¡·¡ó¤jºõ²Å¸¹