Almost every time that I have to manually write a connection string, I have to search www.connectionStrings.com for the right one. It's a good site, they do have the references, but for what I need it's overly complicated.
Below are the connection strings that I use daily