Updating ORACLE BLOB using ASP 3.0/IIS5.0

<u>Updating ORACLE BLOB using ASP 3.0/IIS5.0</u><br><br>Dear All, <br> <br>I have an ORACLE database server (8.1.6) with database and a WEB Server that using IIS5.0/ASP 3.0. <br><br>I am trying to update a BLOB Column, using ASP having successfully uploaded an image file (sample.jpg) to the Web Server and saved it to the file system. I have used 0040 - Oracle Objects for OLE (which by the way is very fast and very stable – great stuff) to connect to and to write tabular information to the database. Having written my tabular information I update the BLOB field first setting it to EMPTY_BLOB():<br><br><div class="msgQuoteWrap"><div class="msgCode">MySQL = "UPDATE PHOTOS SET IMGTHUMBNAIL = EMPTY_BLOB() where ID = " & TheRowID<br>Response.Write ( "<p>MySQL = " & MySQL )<br>rowcount = OraDatabase.ExecuteSQL(MySQL)</div></div><br><br>I then attempt to load my image file using the following method <br><br><div class="msgQuoteWrap"><div class="msgCode">MySQL = "SELECT * FROM photos where ID = " & TheRowID <br>Set OraDynaset = OraDatabase.DbCreateDynaset(MySQL, cint(0)) <br>set ThumbNailImage = OraDynaset.Fields("IMGTHUMBNAIL").Value <br>OraDynaset.Edit <br>ThumbNailImage.CopyFromFile “c: emp8thumb.jpg”<br>OraDynaset.Update</div></div><br><br>This results in the error, I have looked up the error code but there is no more information: <br><br>Oracle Automation error '800a01b8' <br>OIP-04906: LOB operation failed. Unable to open specified file. <br>/DfAPhotos/uploadphoto.asp, line 631 <br><br><br>Has any one got any suggestion what might be going on here?<br>I assume that “c: emp8thumb.jpg” should be on the WEB server and not the DB Server?<br>Has any one get a better example of doing this in ASP? Perhaps using the “Multiple Piece Write Operation”?<br><br>Thanx in advance<br>Regards Adrian