There is an excellent web site for all of us who can not possibly memorise and remember all the different settings for connection strings. This web site includes pretty much every type of connection string you might need to generate from SQL Server 2005 to Oracle, Paradox even IBM DB2! Really cool, easy and free to use.
Bookmark it now!!!!
http://www.connectionstrings.com