connection string

Question

Post reply

connection string

sthenmozhi14

Valued Member

Points: 61
More actions
October 20, 2011 at 12:06 am

#72288

Hi,
i am new in developer.i need to conect database connection string. can u help me.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Revenant SSC-Forever Points: 42467 More actions · Answer 1

sthenmozhi14 (10/20/2011)
Hi,
i am new in developer.i need to conect database connection string. can u help me.

Can you be any more specific?

For starters, do you want to use Windows authentication or password authentication, ... ?

sthenmozhi14 Valued Member Points: 61 More actions · Answer 2

Hi Revenant,

Thank you for reply..i am using windows authentication.

Thanks

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

http://www.connectionstrings.com/[/url]

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

SQLALX SSC Eights! Points: 956 More actions · Answer 4

Right, connectionstrings.com/sql-server-2008 is a good resource.

Just FYI. Here is an example:

string strConn = "Data Source=(local);Initial Catalog=pubs;Integrated Security=SSPI;";

SqlConnection conn = new SqlConnection(strConn);

conn.Open();

// Do something here

conn.Close();

// Data Source=serverName

// Initial Catalog=dbName

Revenant SSC-Forever Points: 42467 More actions · Answer 5

Oops... I dropped the ball on this one.

My apology, but it was just before Thanksgiving...

Divine Flame SSCoach Points: 15943 More actions · Answer 6

Above provided links are more than sufficient. If you are connecting to a production server & that production server is mirrored on some secondary server for DR purpose (with a witness in mirroring topology) then you should add

"Failover Partner=PartnerServerName" also in the connection string.

Sujeet Singh