title: how to connect and insert the ASP with sql server 2005?
body: <p>Am using the following program for insert the value in sql server 2005 using ASP.but i dont know how to connect the asp with sql server 2005.but i use the following program i got the error.how can i solve this?what is the other way to connect the aspo and sql server 2005 for insert the record?</p>
  
  <pre><code>&lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;
  &lt;head &gt;
      &lt;title&gt;Untitled Page&lt;/title&gt;
  &lt;/head&gt;
  &lt;body&gt;
  &lt;%
       dim con, sql_insert, data_source="XEONSERVER\\SQLEXPRESS;Initial Catalog=abcd; User Id=abcd;password=abcd;";   
       sql_insert = "Insert into register values ('" + TextBox1.Text + "')";
       set con = Server.CreateObject("ADODB.Connection");
       con.Open data_source;
       con.Execute sql_insert;
       con.Close;
       set conn = Nothing;
  %&gt;
  
  &lt;form action="Default.aspx" method="post"&gt;
  Your name:&lt;asp:TextBox ID="TextBox1" runat="server"&gt;&lt;/asp:TextBox&gt;
  &lt;input type="submit" value="Submit" /&gt;
  &lt;/form&gt;
  
  
  
  &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>