Since I've been working on connecting to various database with various connection mechanisms - here are a couple of very useful links that show common connection strings for most different kinds of servers:

http://www.able-consulting.com/ADO_Conn.htm

http://www.connectionstrings.com