# Recordset addnew fails in ASP page with SQL Server 2005

**URL:** https://forum.kirupa.com/t/recordset-addnew-fails-in-asp-page-with-sql-server-2005/274563
**Category:** programming
**Created:** [October 31, 2008, 4:01pm UTC](https://forum.kirupa.com/t/recordset-addnew-fails-in-asp-page-with-sql-server-2005/274563 "2008-10-31T16:01:19Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![fepeacock](https://avatars.discourse-cdn.com/v4/letter/f/9f8e36/32.png) [@fepeacock](https://forum.kirupa.com/u/fepeacock)
#### Post date: [October 31, 2008, 4:01pm UTC](https://forum.kirupa.com/t/recordset-addnew-fails-in-asp-page-with-sql-server-2005/274563/1 "2008-10-31T16:01:19Z")

</div>

Hello

I acquired ASP code for SQL Server 2000 which functioned properly. I migrated to SQL Server 2005 and now the code fails on the AddNew command.

The code is:  
set rs = server.CreateObject(“ADODB.Recordset”)  
sql = “SELECT \* FROM News;”  
rs.open sql,conn,2,2  
rs.Addnew  
rs.Fields(“intNewsID”)= intID  
rs.Fields(“strTitle”) = urlnameencode(Title)  
rs.Fields(“dteDate”) = dteDate  
rs.Fields(“strDesc”) = strdesc  
rs.Fields(“strURL”) = strURL  
rs.Fields(“boolNewWindow”) = boolNewWin  
rs.Fields(“intNewsCategory”) = intNewsCategory  
rs.Fields(“ImageExt”) = strImageExt  
rs.Fields(“DocumentExt”) = strDocumentExt  
rs.Update  
AddNews = “true”  
rs.Close  
set rs = nothing

I have tested the connection strings and table News and all is correct according to other code. I receive an error page 500 - Internal Server Error but unfortunately no details of the error.