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
Sat, Oct 30, 2010 1:57 PM
by
|
To Connecting the Database to Gridview Using Ado.net example
In Aspx.cs page------------------------------string connectionString = ConfigurationManager.ConnectionStrings["DropDownListConnectionString"].ConnectionString; protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection
|
Revision #2
Wed, Aug 22, 2012 2:41 PM
by
|
Encrypt & Decrypt ConnectionString Section
Encrypt & Decrypt ConnectionString Section Sometimes we need to secure ConnectionString to prevent anyone can knows it. whatever your purpose from securing ConnectionString, there is a way to Encrypt and Decrypt ConnectionString by special codes as we
|
New
Sat, Oct 30, 2010 1:49 PM
by
|
Upload an Image and an Audio file using C#
In my case, I use a FileUpload Control(Id:->FileUpload1), an ImageButton(ImageButton1) or you can use the Image, a Button Control(Id:->Updatebttn) to upload my Image, Button Control(Id:->Addbttn) to add my Image in database, an image(which I want
|
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
|