connection to SQL

yingting low

18y6.3k

how do i connect to the SQL server? this is the codes I have and no matter what I do, I still cannot connect.. SqlConnection sqlConnection; sqlConnection = new SqlConnection(); sqlConnection.ConnectionString = "Data Source=YINGTING\SQLEXPRESS;Initial Catalog=SMS;Integrated Security=True"; sqlConnection.Open(); please advise!

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vijaya Kadiyala18y ago
Hi,

Check out the below link

http://msdn.microsoft.com/en-us/library/ms998300.aspx

Thanks -- Vj

http://dotnetvj.blogspot.com
Niradhip Chakraborty18y ago
Check out the following two articles. It will help you out to understand the concept of sql server with
.net2.0

1.http://searchsoa.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid26_gci928116,00.html
2.http://asptutorials.net/SQL-Server/accessing-sql-server-2005-from-asp-net-2/
Chongo18y ago
            SqlConnection SqlCon = new SqlConnection(
               "data source="+ip or name+";"+
               "initial catalog="+databasename+";"+
               "integrated security=SSPI;"+
               "persist security info=False;"+
               "workstation id="+ip or name+";"+
               "packet size=4096");

           try
           {
               SqlCon.Open();
           }
           catch (Exception e)
           {
                  //do something here like a messagebox
           }