hello, I have a asp code that updates a ms access database. It works great on a iis6 server as it should but on a .net server it gives me an error with no message of what the error might be. I was wondering if some one could help me to convert it to .net?
<!--#include file="conn.asp" -->
<%
if request("cat_id")<>"" then
dim cat_id
cat_id=request("cat_id")
UpdateSql="UPDATE CATEGORIES SET "
UpdateSql=UpdateSql & "cat_name='" & Replace(request("CAT_NAME"),"'","''") & "',"
UpdateSql=UpdateSql & "cat_desc='" & Replace(request("CAT_DESC"),"'","''") & "' "
UpdateSql=UpdateSql & " WHERE CAT_ID=" & cat_id
Set UpdateCmd = Server.CreateObject("ADODB.Command")
UpdateCmd.ActiveConnection = connStr
UpdateCmd.CommandText = UpdateSql
UpdateCmd.Execute
UpdateCmd.ActiveConnection.Close
response.Redirect ("categories.asp")
else
response.Redirect ("categories.asp")
end if
%>