SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Feb 2012
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ADODB.Connection error '800a0e7a' Provider can't be foundIt may not be properly insta

    I am getting ADODB.Connection error '800a0e7a' Provider can't be foundIt may not be properly installed. at line 26 PLease advise me on this issue.

    <%@ Language=VBScript %>

    <%
    Response.Expires = 0
    Response.Buffer = TRUE
    Response.Clear

    'Load a file from disk
    Dim FilePath
    Dim ActionID
    Dim strCheck
    dim conn
    dim rs1
    dim counter
    dim equal
    Dim FileExt, FileSize

    Response.ContentType = "image\gif"
    response.ContentType ="image\pdf"
    response.ContentType ="image\tif"
    'Response.ContentType = "application/octet-stream"
    ActionID= Request.QueryString("URL")
    counter = Request.QueryString("Counter")

    Set conn = Server.CreateObject("ADODB.Connection")
    conn.Open "UID=SBFileStream;PWD=cat$web123;DSN=catsWebdataSource_FileStream" -- getting error
    strSQL = "select fileattachmentsid,blob,filename,filelength from FILEATTACHMENTS_MEDIUM where LOGNUMBER = "&ActionID& " and COUNTER="&counter
    ' response.Write(strSQL)
    set rs1 = conn.execute(strSQL)
    Do while not rs1.eof
    equal = rs1(1)
    filename =rs1(2)
    filelength =rs1(3)
    rs1.movenext
    FileExt = mid(FileExt, instrrev(FileName,".") + 1)
    Response.AddHeader "Connection", "keep-alive"
    ' Response.AddHeader "Content-Length", filelength
    If IsInline = True then
    'Allow the browser to render the file inside a browser window (if it can)
    Response.AddHeader "Content-Disposition","inline; filename=" & FileName
    Else
    'Force browser to save file
    Response.AddHeader "Content-Disposition","attachment; filename=""" & FileName & """"
    End If

    response.BinaryWrite(equal)

    Loop


    %>

  2. #2
    SitePoint Addict
    Join Date
    Apr 2009
    Posts
    356
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    The error seems to say your catsWebdataSource_FileStream DSN isn't set up correctly on the server. Verify the DSN is working then try your code again.
    Doug G
    =====
    "If you ain't the lead dog, the view is always the same - Anon

  3. #3
    SitePoint Member
    Join Date
    Feb 2012
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I can able to download images for some it is showing ADODB.Connection error '800a0e7a' Provider can't be foundIt may not be properly installed with line number where i highlighted with red color in my code. If i refresh the page after some time i can able to download the same image. Please advise me on this.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •