« Previous Next »

Thread: Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

Last post 09-23-2009 11:15 AM by omer_tunac. 18 replies.

Average Rating Rate It (5)

RSS

Page 1 of 2 (19 items) 1 2 Next >

Sort Posts:

  • 02-19-2009, 1:59 PM

    Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

    This is the strangest thing... I have a group of asp files that allow a user to upload a file to our server. I normally process an upload file every other week. Well I went to process the file this morning and I recieved this error code;

     ADODB.Stream error '800a0bbc'  Write to file failed.

     At first I thought the folder on the IIS server had it's write access changed, so i checked. And it is all fine. So then just on a hunch I tried loading files from another PC here at work and sure enough the files uploaded fine with no error. So for somereason the error only happens when I try to upload the file from my PC to the Server.

    Okay so then I went outside of all logic and tried 3 different browsers on my pc, I.E.8 Beta, Firefox and Google Chrome, ALL WITH THE SAME ERROR. 

    I am at a total loss at this point. I am out of creative ideas. I thought maybe my virtual local ISS maybe the issue or my VPN connection to the server I have running however they all worked upto 2 weeks ago. I turned off my VPN and still recieved the same error.

    I will be willing to try anything anyone here can suggest. Thank you!!

    System Details

    Server Details
    Windows 2000 Server
    SQL Server

     Shawn Bordeaux 

    ***UPDATE*****

    By the way the file that is causing the error is;

    ../includes/functions/clsField.asp, line 171

    That line in that file is;
    Call lobjStream.SaveToFile(pstrFileName, adSaveCreateOverWrite)

    The clsField.asp page is called from the clsUpload.asp page which is included into my upload_process page. It is accessing that command once it tries to save the binary file to the server and that line in the upload_process.asp page is;

    objUpload("File1").SaveAs strPath

    File1 is the name for the file selected from the form input. The strPath variable is defined above that line as;
    strPath = Server.MapPath("../../hours/files") & "\" & strFileName

    and strFileName is defined by the file name selected from the form. And like I said it works fine on other PC's....



     

  • 02-19-2009, 3:03 PM In reply to

    • tomkmvp
    • Top 10 Contributor
    • Joined on 03-20-2003, 6:27 AM
    • Central NJ
    • Posts 6,174
    • IIS MVPs

    Re: Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

  • 02-19-2009, 3:12 PM In reply to

    Re: Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

    I appreciate the quick response!

     I found that same article during my research for a solution. However the issue can not be just related to the server since when I use the webuser login on any other machine it works just fine. When i try to run the page on my desktop it has the issue. I am pretty sure it has something to do with some setting or something on my side but don't have the slightest idea on what.

     Thank you for the link!

  • 02-19-2009, 4:27 PM In reply to

    • tomkmvp
    • Top 10 Contributor
    • Joined on 03-20-2003, 6:27 AM
    • Central NJ
    • Posts 6,174
    • IIS MVPs

    Re: Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

  • 02-19-2009, 4:34 PM In reply to

    Re: Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

    It is under anonymous - webuser access... Works fine on other machines as well even connected to the same network I am on. Very strange...

  • 02-20-2009, 7:24 AM In reply to

    • tomkmvp
    • Top 10 Contributor
    • Joined on 03-20-2003, 6:27 AM
    • Central NJ
    • Posts 6,174
    • IIS MVPs

    Re: Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

    Yeah that's very strange.  Not sure what else to tell you.  All clients should work the same.  Can you show more code?  Maybe there's something we're issing there.

  • 02-20-2009, 9:08 AM In reply to

    Re: Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

    Okay, no problem. I will paste the code below starting with the page that the user selects the file from.

     

    Below is upload.asp
    ====================================================================

    <html> 

    <!--#include file="../../includes/style/header.asp"-->

    <H3>Upload New File</H3>
    <p>
    Browse to find the document you want to upload.
    </p>

    <FORM method="post" name="Upload" encType="multipart/form-data" action="upload_process.asp">
     <INPUT type="File" name="File1">
    <br>
     <INPUT type="submit" value="Upload">
        <input type="hidden" name="fileupload" value="True" />
    </FORM>
    </html>

    ============================================================ 

    Below is upload_process.asp

    ============================================================

    <!--#INCLUDE FILE="../../includes/functions/clsUpload.asp"-->
    <!--#include file="../../includes/style/header.asp"-->

    <%
    'Response.Expires = -1000 'Makes the browser not cache this page
    'Response.Buffer = True 'Buffers the content so our Response.Redirect will work

    If Session("UserLoggedIn") <> "true" Then
        Response.Redirect("default.asp")
    End If
    %>


    <%

    'Response.Write("path: " & pstrFileName)

    Dim objUpload
    Dim strFileName
    Dim strPath
    Dim intDocument_ID

    ' Instantiate Upload Class

    Set objUpload = New clsUpload


    ' Grab the file name
    strFileName = objUpload.Fields("File1").FileName
    strFileName = replace(strFileName,"'","_")
    ' Compile path to save file to
    strPath = Server.MapPath("../../hours/files") & "\" & strFileName

    dim fs
    Set fs=Server.CreateObject("Scripting.FileSystemObject")
    if fs.FileExists(strPath) then
      fs.DeleteFile(strPath)
    end if
    set fs=nothing


    ' Save the binary data to the file system
    objUpload("File1").SaveAs strPath ' TURN BACK ON

    ' Release upload object from memory
    Set objUpload = Nothing ' TURN BACK ON

    session("upload_status")="True"
    'Response.Write("path: " & pstrFileName)
    %>


    <h3>File Uploaded</h3>

    <P>
    The  file listed below has been uploaded. If you would  like to load the employee file into the Hours System just click &quot;Continue&quot; below.
    <br>
    Document Title<: <b><%=strFileName%></b><br>
    </P>

    <FORM method="post" name="confirm_upload" action="../upload/upload_emp_file.asp">
     <INPUT type="hidden" name="path" Value="<%=strPath%>">
     <INPUT type="hidden" name="filename" Value="<%=strFileName%>">
      
     <INPUT type="Submit" value="Continue">
    </FORM>

    </html>

    ====================================================================
    Below is the line on clsField.asp file which is an included file of clsUpload.asp - The whole page is over 300 lines of code so I will just include the part where I am recieving the error from.
    ====================================================================
    ' Save the binary data to file system
      ' Overwrites file if previously exists!
      Call lobjStream.SaveToFile(pstrFileName, adSaveCreateOverWrite)

    =====================================================================
    The error being displayed in my browser is below
    =====================================================================

    ADODB.Stream error '800a0bbc'

    Write to file failed.

    D:\INETPUB\WWWROOT\INTRANET\HOURS\ADMIN\../../includes/functions/clsField.asp, line 171

    =====================================================================
    That's it. Let me know if you can think of anything at all. Strangest thing... Thanks!

  • 02-20-2009, 10:10 AM In reply to

    Re: Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

    shawn.bordeaux:

    ADODB.Stream error '800a0bbc'

    Write to file failed.

    D:\INETPUB\WWWROOT\INTRANET\HOURS\ADMIN\../../includes/functions/clsField.asp, line 171

     

    Have you tried running any monitoring whilst this process is failing ? I'd suggest running Process Monitor to see if it catches any permissions related issues :

    http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

    Regards,

    Paul Lynch | www.iisadmin.co.uk
  • 02-20-2009, 12:06 PM In reply to

    Re: Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

    Thanks for the advice. I just tried and I don't see anything related to permissions... Strange thing is I am logging in as normal webuser the same if I use another PC. Yet when I login on my PC it gives me this error and every other one works fine. I think the only way permissions would cause that would be if the connection determined my unique pc name or ID. I doubt it is an IP since I am on a public IP with my network and when I login using other comps on the network it works fine. My computer went through some windows updates a few days ago and since it was working 2 weeks ago I am thinking maybe that had something to do with it. Not sure how but I am going to find what was updated and research into that. 

  • 02-20-2009, 2:28 PM In reply to

    • tomkmvp
    • Top 10 Contributor
    • Joined on 03-20-2003, 6:27 AM
    • Central NJ
    • Posts 6,174
    • IIS MVPs

    Re: Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

    The key though is you said as far as the web site goes it's all anonymous.  It shouldn't matter where you access it from and all the code is running on the server.

  • 02-20-2009, 2:41 PM In reply to

    Re: Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

    Well I am glad that I'm not the only one stumped on this one. Do you think it may have something to do with me running a local IIS on my PC as a localhost for debuging code? I connecting to the webserver while running that file so I don't see how that is possible but who knows...

  • 02-20-2009, 3:07 PM In reply to

    • tomkmvp
    • Top 10 Contributor
    • Joined on 03-20-2003, 6:27 AM
    • Central NJ
    • Posts 6,174
    • IIS MVPs

    Re: Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

    That shouldn't matter.

    The code is running on the web server independent of the client (or anything on your machine for that matter), and you're doing this through anonymous access.  If it works in one place it should work everywhere.

    Could it have anything to do with the file you're uploading?  Have you tried the same file from other PC's?  Have you tried different files on your PC?

  • 02-20-2009, 3:36 PM In reply to

    Re: Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

    I have tried numerous other files with the same result. No matter the size or the format. I am going to try one of those files on another PC. I would just send various files on the PC I was at testing it and they all worked fine no matter the file or extention accept on my PC no files work...

  • 02-26-2009, 10:27 AM In reply to

    Re: Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

    It is working now! I am not sure in the logic of why this worked but here is what I did;

    I rolled back I.E. 8 to I.E.7 and then deleted all history, cookies, temp data and forms. Restarted and tried and it worked like it should on my PC. I don't have a clue why my Client was causing the problem but apparently it was and now everything is fine.

     

    Thank you for your help through this!

    Shawn

  • 07-22-2009, 6:03 AM In reply to

    • jmunji
    • Not Ranked
    • Joined on 07-22-2009, 9:59 AM
    • Posts 2

    Re: Error only on my PC - ADODB.Stream error '800a0bbc' Write to file failed.

     Shawn

     

    Sorry for a late reply, I was having the same problem to do with this error on a basic ms db  and discovered that the error appears to be to do with the version of Javascript that your browser is running.

     

    The line that was causing me the problem was 

    lobjStream.Open()

     

    I have since discovered that IE 7 & 8, chrome  Safari 4 and Firefox 3.5 all error with the

    ADODB.Stream error '800a0bbc' Write to file failed.

     error but IE 6 (earlier version of java runs the files fine.  Hope that this helps in discovery of the problem.

     

    http://social.msdn.microsoft.com/Forums/en-US/netfxjscript/thread/ffcb840c-0d81-41be-9192-11284b175ca0 this is how i discovered the problem

     

Page 1 of 2 (19 items) 1 2 Next >
Microsoft Communities