| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-11-14 : 07:49:49
|
Some common and not so common connection strings for the .NET SqlConnection object. The article includes .NET sample code and some tricks to increase the supportability of your application. Read SQL Server Connection String |
|
|
Horninger
Starting Member
1 Post |
Posted - 2007-11-14 : 08:36:48
|
| Pretty good article! I especially like the idea of setting the app name. Well done! |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-11-18 : 13:27:16
|
As an extension to this, I often utilize a Microsoft Data Link(UDL) file to simplify connection strings (or to make changing them not involve any changes to the actual code.Using with ADO UDL API
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-11-18 : 13:30:13
|
quote:
Originally posted by dataguru1971
As an extension to this(referenced at the connection string link above), I utilize the Microsoft Data Link(UDL) file to simplify connection strings (or to make changing them not involve any changes to the actual code.Using with ADO UDL API
Poor planning on your part does not constitute an emergency on my part.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-11-18 : 16:21:19
|
your links are broken. I think this is the page you meant:http://msdn2.microsoft.com/en-us/library/e38h511e(VS.71).aspx
elsasoft.org |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-11-18 : 16:31:18
|
Thanks, link is now fixed..
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
quangvo
Starting Member
1 Post |
|
|
private.casey
Starting Member
1 Post |
Posted - 2009-07-16 : 02:15:01
|
Yeah good article. Thanks for the links guys. I've been struggling a bit with SQL connection strings, and these are definitely helping.  The man who smiles when things go wrong has thought of someone to blame it on. -Robert Blochcsjones (www) |
|
|
|
thompjs
Starting Member
1 Post |
Posted - 2010-10-08 : 16:01:54
|
| Application Name= does not seem to work, it does not show up in Activity Monitor. I've also tried APP= and that doesn't work eitherJST |
|
|
|
james.crowley
Starting Member
2 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-03-11 : 04:22:20
|
Provider is missing the above Developer Fusion wizard.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
james.crowley
Starting Member
2 Posts |
Posted - 2011-03-16 : 19:34:09
|
quote:
Originally posted by Peso
Provider is missing the above Developer Fusion wizard.
hey Peso, what do you mean? It's assuming you're using the SqlConnection object (either directly or via Linq/NHibernate/Entity Framework) so you wouldn't ever need to specify the provider as such? (unless I'm missing something!)If there is a problem, do let me know and we'll get it fixed. Thanks |
|
|
|
|
Article: SQL Server Connection String