Remembering the exact syntax of a connection string is a pain.
The following are links to my favourite articles on making a connection string.
- Connection Strings.Com
- Another great site for developers is The Code Project: ADO Connection Strings & of course
- RTFM is also a great idea, don’t forget SQL 2008 Books Online page OLE DB Providers Tested with SQL Server
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 ).