Remembering the exact syntax of a connection string is a pain.
The following are links to my favourite articles on making a connection string.
I find these handy in both writing my own code but more so when creating Linked Servers in in SQL server, Creating connections in many of the SSIS Tasks, Creating Data Source connections in SQL Reporting Services &/or SQL Report Builder
In a day or three I'll write up my thoughts on SQLConnectionStringBuilder. Now that this seems to work ok.
(This was originally a test to see if I could post something using LiveWriter. I'd planned on deleting it, but as so many people are hitting it, it can stay. I will write up a better article once I've finished the Spatial & other series I have planned ).