Anyone have an example for me for how they do their connection strings? (best practices?) Do you store them in a file? Are you sending the Application Name=MyApp to help on the sql side of things. Do you prefer OLE DB versus ODBC?
I use a config .xls file with environments (servernames, document paths, connection strings etc) and all my QVWs have a config tab which loads from this spreadsheet into multiple variables. I can't post an example here just yet but will try to do so either tonight or tomorrow for you.