SQL Server 2005 error while importing images using ASP page: “ASP Error ‘ASP 0104: 80004005′”
One of the web application user complained about the above error during the upload process of images to SQL Server database!
Most of the web
applications have a lot of images used in it. Its not a best practice to store the Image/BLOB type data on the SQL Server database and better that these images are usually stored in
a web server folder and they are accessed by giving the relative path to the
file with respect to the root folder of the website. But this is changing slowly with the new programming languages such as .NET and that is being the
platform for distributed application now, ASP.Net can be used to store images
that are small to be stored in a database like SQL Server 2000 and later
versions. For this purpose the SQL Server database provides a data type called
“image” which is used to store images in the database.
To access these
images stored in the database we will be using the ADO.Net classes. To find out
how to insert and retrieve an image in to the SQL Server database, you can
create a .aspx page which can have a HTMLInputFile control which is used to
select the image file that is to be saved in the database.
Then coming to the real problem the user has to upload the images to the database that was designed to access from database than the filer path, while uploading the images where the web page was designed to allowed the user to upload files (images and so forth) to the
server and manage the files. The error below was intermittent:
Request object error 'ASP 0104 : 80004005'
It was mentioned to check the permissions/privileges for the web user on the specified folder where these images are being accessed and the number 800004005 represents that it was caused by invalid
permissions on the file system where the files where being written to. As a test we have enabled the permission on the Development platform to see whether it server the purpose with such directory permissions been changed to allow the
IIS user writing permissions to that directory, it works!
Also further discussion to this problem refer to this Blogpost that was found during web search.