The connection string specifies information about how to initialize a connection to a data store.
It contains keyword/value pairs. the first pair is always the Provider or Driver. The following pairs will correspond with the data required to initialize the provide / driver.
Some Example Keywords:
SQL ODBC: Server, Database, Uid (user), Pwd (password), Trusted_Connection, MARS_Connection (multiple active record sets), Encrypt, AttachDbFilename,
SQLOLEDB: Data Source, Initial Catalog (database to connect to), UserId, Password, Integrated Security, Failover Partner (for mirroring).
Some example connection strings:
SqlConnection (.NET) standard Security:
"Data Source=ServerAddress;Initial Catalog=DataBase;User Id=username;Password=password;"
ODBC - PostgreSQL driver:
"Driver={PostgreSQL};Server=IP address;Port=5432;Database=DataBase;Uid=username;Pwd=password;"
More example connection string:
http://www.connectionstrings.com/
Revision number 4, Tuesday, May 05, 2009 9:50:27 PM by rtpHarry
You must Login to comment.
|
Thu, Dec 18, 2008 1:46 AM
by sirdneo
|
It is great resource for my junior team members, i like to share it with them. Nice job.
|
|
Sat, Apr 25, 2009 8:25 PM
by prabirchoudhury
|
very good
|
|
Wed, May 6, 2009 9:47 AM
by idgetman05
|
Another good prcatice would be to encrypt the connection string when you go live with the website
|
|
Thu, May 7, 2009 11:28 PM
by Sayre
|
Nice Job.
|
|
Mon, May 11, 2009 8:14 AM
by amol.sonawane
|
great
|
|
Tue, May 12, 2009 12:32 AM
by ahmish
|
Good! It can be help out to the new developers.
|
|
Tue, May 12, 2009 4:42 PM
by Grady Christie
|
Good reference listing!
|
|
Sat, May 23, 2009 5:38 AM
by ahsanm.m
|
its nice one.
|
|
Mon, Jun 15, 2009 7:05 AM
by asim afzal
|
Always define connection string inside the Web.Config file.
|
|
Fri, Aug 14, 2009 8:44 AM
by csharppointer
|
http://www.connectionstrings.com/ is really great site. you point the database it will give you connection string
|
Revision #2
Tue, Feb 26, 2008 12:59 AM
by
|
accessdatasource
The AccessDataSource class is a data source control that works with Microsoft Access databases. Like its base class, SqlDataSource, the AccessDataSource control uses SQL queries to perform data retrieval. One of the unique characteristics of the AccessDataSource
|
Revision #5
Wed, Mar 4, 2009 9:48 PM
by
|
Bind ListControl's DataValueField/TextField to multiple columns
Concept A very common question asked on the ASP.NET Forums is how to bind a ListControl's DataTextField or DataValueField to multiple Columns. The classic solutionto do thatis to make your field(s) in the "Select" like : "select 'n°'
|
Revision #2
Mon, Feb 18, 2008 12:07 PM
by
|
How to Postback Asynchronously from inside a GridView
Concept With the rise of ASP.NET 2.0 AJAX Extensions 1.0, developers were fascinated by the great AJAX Server controls, but they missed that some of them might be harmful if they didn't really know how to usethem ina proper way. One example is when there
|