SQL Server Performance Forum – Threads Archive

How to handle Database Connection to SQL Server?

I’m new to .net and need to know how to handle database connection to SQL Server 2000/2005 so an application can be deployed to clients. Thanks.

http://www.sqlstrings.com/SQL-Server-connection-strings.htm
http://msdn2.microsoft.com/en-us/library/ms998300.aspx
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

http://www.dotnetspider.com/tutorials/
http://www.sql-server-vb-asp.net/ ..also take you through the tutorials. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Also referhttp://connectionstrings.com/ Madhivanan Failing to plan is Planning to fail

Hi, I think my question is not specific enough. I’m looking for different .NET 2.0 techniques (also .NET 3.0 if differnt) in both storing connection string and building connection string in runtime. I think the most common way in storing connection string is in app.exec.config. But I want to know other alternatives and their pros and cons.

I think you need to post in .NET forums Madhivanan Failing to plan is Planning to fail

True, may refer to the MSDN related forums. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

]]>