This exact code is working when inserting into SQL 2000
I duplicated the table script and ran it on SQL2005 with success and trying to get the code to now write to SQL2005 I have only change the connection string...
suggestions?
001.PDF File successfully written to disk.
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/policyManagement/formPost.asp, line 11
code =
Expand|Select|Wrap|Line Numbers
- If uploadObj.SaveToWeb("fileInput", uploadString) Then
- Response.Write("File successfully written to disk.")
- %><!--#include file="../Connections/policyMngDB.asp"--><%
- formName = replace(formName,"'","''")
- sql = "insert into formList "
- sql = sql & "(formName, formNumber, uploadDate, userid, formStatus, fileName) "
- sql = sql & "values('"& formName &"', '" & formNumber &"', '"& now &"', '"& session("loggedInUserid") &"', '1', '"& newFileName &"') "
- set recordset = Server.Createobject("ADODB.RecordSet")
- recordset.open sql, conn, 3, 3
- response.redirect("formView.asp")
- Else
- Response.Write("There was an error saving the file to disk.")
- End If
- End If