As a SharePoint consultant you may have to connect to line of business systems using the Business Data Catalog or Excel Services. The connection string web site has been around for many years and is an invaluable tool when determining formats used for connection strings.
http://www.connectionstrings.com/
