I want to insert an image to a column in SQL Server.<BR>I have 2 options :-<BR>1) Having the column datatype as varchar(255).<BR>Upload the file to the site and store the path in the field. <BR>But we are unable to upload the file to the site,the error we get is permission denied. We are using scripting.filesystemobject. The file upload takes place in our local web server. but once we upload the files to the site we get a permission denied error.<BR>2) Having the column datatype as image.<BR>How do i insert an image into the database.<BR>I am able to retrieve the values that are already stored in the pubs database, but am unable to add a add a new record to pub_info of pubs database. <BR><BR>Can anyone please help!!!!!!!!!!!