var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Adding New File Record Problem
Hey guys, I get this error when I try to add a new file record to my database.I'm working with SQL server 2000.
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
The line giving this problem is below:
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open "Files", "DSN=MyDSN;UID=sa;PWD=pass", 2, 2
RS.AddNew ' create a new record
RS("FileName") = File.FileName <------ Problem
RS("FileSize") = File.FileSize
RS("ContentType") = File.ContentType
' Save the file to the database
' Commit the changes and close
You didn't create any object called File so you can't use File.BlahBlahBlah.
Hi thanks for your response.
I still cant get it to work for the database part.
It works fine when I save it to the harddisk though.
Anyone can give me some advice?
I solved the problem above~ but now I have another error.
Hm, I'm kinda new at this and am doing a project.
The error is below:
Operation is not allowed in this context.
rs("File Data").AppendChunk fileData <----This line is giving the error.
Anyone know why?
I dont know exact problem but you can try this.: