I have recetly migrated from SQL 2000 to SQL 2005 and certain .asp-code that was working before, is no longer working.
Retrieving, inserting, deleting recordsets are no problem, but when I try to update I run into problems.
The following code works:
Expand|Select|Wrap|Line Numbers
- "UPDATE tblsomething SET column_name = 'something' "
Expand|Select|Wrap|Line Numbers
- rs.Open "SELECT * FROM tblSomething WHERE column_name=" & RequestSomething, connection, 1,3
Expand|Select|Wrap|Line Numbers
- rs.Fields("column_name") = Request.Form("form_name")
- -
- -
- rs.Update
Since the error message is in Swedish I can't just post it but is says something about not finding the sql server in sysservers and tells me to run sp_addlinkedserver to add servers into sysservers?
Does this make any sence to anyone?
Any help appreciated.
//Jesper