SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: SQL Server Connection String
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 11/14/2007 :  07:49:49  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote

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 Posts

Posted - 11/14/2007 :  08:36:48  Show Profile  Reply with Quote
Pretty good article! I especially like the idea of setting the app name. Well done!
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 11/14/2007 :  08:40:32  Show Profile  Visit jezemine's Homepage  Reply with Quote
no discussion of connection strings is complete without a shoutout to this site:

http://www.connectionstrings.com



elsasoft.org
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 11/14/2007 :  08:42:54  Show Profile  Visit SwePeso's Homepage  Reply with Quote
And this http://www.carlprothman.net/Default.aspx?tabid=81



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

dataguru1971
Flowing Fount of Yak Knowledge

USA
1464 Posts

Posted - 11/18/2007 :  13:27:16  Show Profile  Send dataguru1971 an AOL message  Send dataguru1971 a Yahoo! Message  Reply with Quote
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.


Edited by - dataguru1971 on 11/18/2007 13:28:57
Go to Top of Page

dataguru1971
Flowing Fount of Yak Knowledge

USA
1464 Posts

Posted - 11/18/2007 :  13:30:13  Show Profile  Send dataguru1971 an AOL message  Send dataguru1971 a Yahoo! Message  Reply with Quote
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.


Edited by - dataguru1971 on 11/18/2007 16:31:00
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 11/18/2007 :  16:21:19  Show Profile  Visit jezemine's Homepage  Reply with Quote
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
Go to Top of Page

dataguru1971
Flowing Fount of Yak Knowledge

USA
1464 Posts

Posted - 11/18/2007 :  16:31:18  Show Profile  Send dataguru1971 an AOL message  Send dataguru1971 a Yahoo! Message  Reply with Quote
Thanks, link is now fixed..



Poor planning on your part does not constitute an emergency on my part.

Go to Top of Page

quangvo
Starting Member

1 Posts

Posted - 01/07/2009 :  02:15:03  Show Profile  Visit quangvo's Homepage  Reply with Quote
excellent site for connection strings and example and all .net programming http://www.connectionstringexamples.com

spirit1: <deleted spammy links>

Edited by - spirit1 on 01/07/2009 04:43:00
Go to Top of Page

private.casey
Starting Member

1 Posts

Posted - 07/16/2009 :  02:15:01  Show Profile  Reply with Quote
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 Bloch

csjones (www)
Go to Top of Page

thompjs
Starting Member

USA
1 Posts

Posted - 10/08/2010 :  16:01:54  Show Profile  Reply with Quote
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 either

JST
Go to Top of Page

james.crowley
Starting Member

United Kingdom
2 Posts

Posted - 03/10/2011 :  14:32:20  Show Profile  Reply with Quote
Just thought you might be interested in this online sql connection string generator that lets you select the options you want: http://www.developerfusion.com/tools/sql-connection-string/ (only for SQL Server at the moment)
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30282 Posts

Posted - 03/11/2011 :  04:22:20  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Provider is missing the above Developer Fusion wizard.


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

james.crowley
Starting Member

United Kingdom
2 Posts

Posted - 03/16/2011 :  19:34:09  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000