SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    HELP!! Can't work this out!

    I'm getting this error:
    Microsoft OLE DB Provider for ODBC Drivers error '8007000e'
    [Microsoft][ODBC Microsoft Access Driver] System resource exceeded.

    /westend/final/news.asp, line 115
    For this peice of code:
    [vbs]
    <%
    connectDB()
    Set RS = objDBCon.Execute("SELECT dateT, newsHeadLine, newsContent FROM tblsNews ORDER BY ID DESC")
    DO UNTIL RS.EOF
    response.write("<tr valign=""top""><td><p><span class=""head3"">" & RS("newsHeadLine") & "</span><br><span class=""para1"">" & replace(RS("newsContent"), chr(13), "<br>") & "</p><p class=""para1""><b>Date: </b>" & formatdatetime(RS("dateT"),1) & "<hr color=""#e1e1e1""></p></td></tr>")
    IDxx = IDxx + 1
    RS.MoveNext
    Loop
    Set RS = nothing
    connectDB()
    %>
    [/vbs]
    Line 115 is:
    [vbs]
    Set RS = objDBCon.Execute("SELECT dateT, newsHeadLine, newsContent FROM tblsNews ORDER BY ID DESC")
    [/vbs]
    Ad the connectDB function is:
    [vbs]
    Public Function connectDB()
    On Error Resume Next
    If not isObject(objDBCon) OR cStr(typeName(objDBCon)) = "Nothing" then
    Set objDBCon = Server.CreateObject("ADODB.Connection") : strConnect = "westend" : objDBCon.open strConnect
    else
    objDBCon.close : Set objDBCon = nothing
    end if
    End Function
    [/vbs]
    Does anyone have any idea?! I need to get this finshed 10 minutes ago!



    Pwease!

  2. #2
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,121
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    1. What database engine?
    2. How big is the database (if it's access)?
    3. I don't see any recursive looping, but is there any?
    4. Is IIS's script limitations on?
    5. Is it a network error (if you're on a LAN)?
    6. Are you getting timeouts as well, or just this?
    7. What is the processing time befoer you get this message?

    I don't really know, but I'm trying to root out the problem here...
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  3. #3
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1. DSN, have to
    2. 569,344
    3. Yes, RS.MoveNext
    4. No
    5. No
    6. Just that error
    7. Less than a second

  4. #4
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,121
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Is it a SQL Server or Access db?

    It sounds like this is a weird arsed Server error... Can you restart it and then put Task Manager on to see what's happening and what processes are overflowing?
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  5. #5
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Access...

    Ok... started working now...

  6. #6
    SitePoint Wizard big_al's Avatar
    Join Date
    May 2000
    Location
    Victoria, Australia
    Posts
    1,661
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    A bit late with this but you might find that for some reason IIs didn't clean up well enough, if you look in the task manager you usualy find that one of the DLLHost instances is taking up a fair bit of memory.. other wise all I could think of is that it was just one of those quirky errors.
    .NET Code Monkey


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
  •