asp.net connection issues
<p>This is my ASP.NET code: </p>

<pre><code>&lt;html&gt;
&lt;body&gt;

&lt;%
Dim Conn
Conn = "Provider=xxxxxx; Server=xxxxxx; Database=xxxxxx; Trusted_Connection=xxx; "


sql="INSERT INTO xxxx"
sql=sql &amp; " VALUES "
sql=sql &amp; "('" &amp; Request.Form("xxxx") &amp; "',"
sql=sql &amp; "'" &amp; Request.Form("xxxx") &amp; "',"
sql=sql &amp; "'" &amp; Request.Form("xxxx") &amp; "',"
sql=sql &amp; "'" &amp; Request.Form("xxxx") &amp; "',"
sql=sql &amp; "'" &amp; Request.Form("xxxx") &amp; "',"
sql=sql &amp; "'" &amp; Request.Form("xxxx") &amp; "',"
sql=sql &amp; "'" &amp; Request.Form("xxxx") &amp; "',"
sql=sql &amp; "'" &amp; Request.Form("xxxx") &amp; "',"
sql=sql &amp; "'" &amp; Request.Form("xxxx") &amp; "',"
sql=sql &amp; "'" &amp; Request.Form("xxxx") &amp; "',"
sql=sql &amp; "'" &amp; Request.Form("xxxx") &amp; "',"
sql=sql &amp; "'" &amp; Request.Form("xxxx") &amp; "',"
sql=sql &amp; "'" &amp; Request.Form("xxxx") &amp; "')"

on error resume next
Conn.Execute sql,recaffected
if err&lt;&gt;0 then
  Response.Write("Update Failed")
else
  Response.Write("&lt;h3&gt;"Record Added&lt;/h3&gt;")
end if

%&gt;

&lt;/body&gt;
&lt;/html&gt;
</code></pre>

<p>I always get a result of "Update Failed"... Can you see from the code why this is?</p>
