Results 1 to 13 of 13
  1. #1
    Join Date
    Jan 2002
    Location
    Libya
    Posts
    50

    Unhappy Unanswered: Microsoft OLE DB Provider for ODBC Drivers error '8007000e'

    Microsoft OLE DB Provider for ODBC Drivers error '8007000e'
    [Microsoft][ODBC Microsoft Access Driver] System resource exceeded

    I recieve this error every time I execute SQL statement form ASP page on an Access database.
    Could any one help me diagnosing this problem and how to avoid seeing such error messages.

    Thanks
    Khalid Yousef

  2. #2
    Join Date
    Jan 2002
    Location
    Libya
    Posts
    50
    I FOUND IT!
    I FOUND THE SOLUTION.

    If there is any one interested in this subject or suffering from it, contact me and I will tell him about the million dollar problem solution.

    Khalid Yousef

  3. #3
    Join Date
    Mar 2002
    Location
    Mexico D.F.
    Posts
    1
    Originally posted by Khalid
    I FOUND IT!
    I FOUND THE SOLUTION.

    If there is any one interested in this subject or suffering from it, contact me and I will tell him about the million dollar problem solution.

    I have this problem (about access database sending "Resources Exceeded Error") my largest table has 350,000+ Registers. Might this be causing the problem? I tried deleteing 10,000 registers aout of the table but it didn't work.

    It just happened after more than 1 year of mu application running perfectly fine.

    You can see the error in: http://www.citaris.com/checarplayer.jhtml

    Please let me know if you need any other information.

    Best regards and thank you very much,.

    Alexis.
    acastanares@yahoo.com

  4. #4
    Join Date
    Mar 2002
    Posts
    1
    Originally posted by Khalid
    I FOUND IT!
    I FOUND THE SOLUTION.

    If there is any one interested in this subject or suffering from it, contact me and I will tell him about the million dollar problem solution.

    Khalid, can you help me out? I've been getting this error for a few weeks now. Thanks

  5. #5
    Join Date
    Mar 2002
    Posts
    1
    Khalid,
    It would be most helpful if you'd post the solution here, rather than make everyone who has this problem email you for it.


    VRWL



    Originally posted by Khalid
    I FOUND IT!
    I FOUND THE SOLUTION.

    If there is any one interested in this subject or suffering from it, contact me and I will tell him about the million dollar problem solution.


  6. #6
    Join Date
    Jan 2002
    Location
    Libya
    Posts
    50
    I received lately a lot of emails asking about this famous error problem.
    this is my solution I have discovered:

    ASP is full of bugs, as I discovered lately, but these bugs can be solved by writing code.

    My problem was due to Database connections, it seem to me I was doing the perfect thing, opening connections, recordsets, executing queries and finally I destroy every object I create.

    THE PROBLEM
    ===========
    If you open only one connection (as I used to do), and run more than one query or recordsets at the same time, what is happening? ASP does not allow you to run more than one query through the same connection at the same time, (though it seems that it is working) so how come? Since ASP does not allow that, it creates its own connections to run the further queries you are executing, and after you are done with them, ASP is not destroying the connections it creates. If you are not destroying your connection objects as well, so you are helping the problem to come up.

    WHAT IS HAPPENING
    ==================
    unclosed objects will create a resource leak in memory, and as the times goes, more objects are not closed, and more memory resources are consumed until it reaches to the maximum. And guess what, the famous message will show up!

    SOLUTION
    =========
    -Define a connection for every query by its own.
    -Create you connection object and destroy them your self, don't let ASP do any thing by its self.

    Hope this information be helpful for every body.

    Cheers

    Khalid Yousef

  7. #7
    Join Date
    Nov 2002
    Posts
    1
    Yes but.... Why if i have two servers, one with a single PIII 500 Mhz and 256 Mb Ram and other with Dual PIII 1 ghz an 1 Gb Ram... with the same web page and with the same Operatin System, I got the problem in the Dual PIII and not in the oldest server?

  8. #8
    Join Date
    May 2004
    Posts
    2

    JDBC ODBC system resource exceeded problem

    Hi,
    after reading an article, I am using a jdbcdbc bridge with an excel file setup as a user dsn. This is to import and export from our java applciation and jdbc database to excel. On XP and 2003 server machines, there is no problem. However, on 2000 server machines, they all get 'system resources exceeded' message and fail to do anything.

    Can anyone help with identifying the underlying problem and recommend a solution ??? Is there a a buggy MS component or something that needs updating? HELP!!!

    thanks in advance,
    Neil

  9. #9
    Join Date
    Jan 2002
    Location
    Libya
    Posts
    50

    Cool

    iamneil
    As I have described previously, you are getting this message because your application is causing memory leak. This happens due to many causes, I have discovered that in my ASP application, IIS is opening more connections when I try to run more than SQL statement at the same time on one connections, so IIS is creating its own connections and it is not closing those connections when done with them.
    If the application is working on heavy traffic those unclosed connections will be consuming the resource of the system untill it reaches the maxium.

    So try to find out where is your bug that causes a memory leak.

    Check out your application and tell me more about it.

    Good luck
    Khalid Yousef

  10. #10
    Join Date
    Jan 2006
    Posts
    2
    Need Help with this issue.

    Pretty Sure that the Problem is that there is a Memory Leak within the Page. It randomly just started Popping Up Non-Stop about Temporary Disk Space.

    But here's where I need help - I'm a new webmaster at one of AAA Auto Clubs Divisions, and the Previous webmaster loved ASP Scripting. I personally favor PHP, because I have more experience with it.

    But The Employees Here need to get this working up and running ASAP -

    It's Pretty Obvious that The Script Used is from ASP Calendar -- But I can't just simply Download another Version of ASP Calendar and Overwrite the File because the Files Have Been Modified to Work Better for the Employees Uses.



    Here Is the Exact Error Message I Am Receiving

    Microsoft OLE DB Provider for ODBC Drivers error '8007000e'
    [Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk.
    /Calendar/calendar.asp, line 222





    Here is the Coding For calendar.asp









    ------
    6 hours trying to find what this error code was from, how it was happening, and trying to find the resource to fix it was Extremely Frustrating.

    So if you can help in anyway, it will be greatly appreciated. Plus if you throw in some Educational snippits (comments in the code) of What this part of the script does and what this part of the script does. It would help tremondously!

  11. #11
    Join Date
    Jan 2006
    Posts
    2
    <!-- #include file ="dsn.asp" -->
    <!-- #include file="adovbs.inc" -->
    <%
    ' Name: ASP Calendar
    ' Author: Manohar Kamath
    ' Version: 1.0
    ' Copyright Manohar Kamath. Original calendar copyright Wrox Press
    %>
    <%
    ' catch department and status name from login page
    Dim Dept, intStat, strEvents
    Dept=Request("Dept")
    intStat=Request("intStat")
    strEvents=""
    %>
    <%
    '------------------------------------------------------------
    ' This function finds the last date of the given month
    '------------------------------------------------------------
    Function GetLastDay(intMonthNum, intYearNum)
    Dim dNextStart
    If CInt(intMonthNum) = 12 Then
    dNextStart = CDate( "1/1/" & intYearNum)
    Else
    dNextStart = CDate(intMonthNum + 1 & "/1/" & intYearNum)
    End If
    GetLastDay = Day(dNextStart - 1)
    End Function

    '-------------------------------------------------------------------------
    ' This routine prints the individual table divisions for days of the month
    '-------------------------------------------------------------------------
    Sub Write_TD(sValue, sClass)
    Response.Write " <TD ALIGN='RIGHT' WIDTH=14% HEIGHT=80 VALIGN='top' CLASS='" & sClass & "'> " & sValue & "</TD>" & vbCrLf
    End Sub


    ' Constants for the days of the week
    Const cSUN = 1, cMON = 2, cTUE = 3, cWED = 4, cTHU = 5, cFRI = 6, cSAT = 7

    ' Get the name of this file
    sScript = Request.ServerVariables("SCRIPT_NAME")

    ' Check for valid month input
    If IsEmpty(Request("MONTH")) OR NOT IsNumeric(Request("MONTH")) Then
    datToday = Date()
    intThisMonth = Month(datToday)
    ElseIf CInt(Request("MONTH")) < 1 OR CInt(Request("MONTH")) > 12 Then
    datToday = Date()
    intThisMonth = Month(datToday)
    Else
    intThisMonth = CInt(Request("MONTH"))
    End If

    ' Check for valid year input
    If IsEmpty(Request("YEAR")) OR NOT IsNumeric(Request("YEAR")) Then
    datToday = Date()
    intThisYear = Year(datToday)
    Else
    intThisYear = CInt(Request("YEAR"))
    End If

    strMonthName = MonthName(intThisMonth)
    datFirstDay = DateSerial(intThisYear, intThisMonth, 1)
    intFirstWeekDay = WeekDay(datFirstDay, vbSunday)
    intLastDay = GetLastDay(intThisMonth, intThisYear)

    ' Get the previous month and year
    intPrevMonth = intThisMonth - 1
    If intPrevMonth = 0 Then
    intPrevMonth = 12
    intPrevYear = intThisYear - 1
    Else
    intPrevYear = intThisYear
    End If

    ' Get the next month and year
    intNextMonth = intThisMonth + 1
    If intNextMonth > 12 Then
    intNextMonth = 1
    intNextYear = intThisYear + 1
    Else
    intNextYear = intThisYear
    End If

    ' Get the last day of previous month. Using this, find the sunday of
    ' last week of last month
    LastMonthDate = GetLastDay(intLastMonth, intPrevYear) - intFirstWeekDay + 2
    NextMonthDate = 1

    ' Initialize the print day to 1
    intPrintDay = 1


    %>

    <html>
    <head>
    <meta HTTP-EQUIV="Content-Type" content="text/html; charset=ISO-8859-1">
    <title>Vacation Schedule</title>
    <style TYPE="text/css">
    TD.NON {font-family :Tahoma, Verdana, Arial; font-size :12px; color :#C0C0C0; font-weight :normal;}
    TD.TOP {font-family :Tahoma, Verdana, Arial; font-size :12px; color :#0000FF; font-weight :bold;}
    TD.Some {font-family :Tahoma, Verdana, Arial; font-size :12px; color :#000000; font-weight :normal;}

    A.NOEVENT:Link {font-family :Tahoma, Verdana, Arial; font-size :12px; color :#000000; font-weight :normal; text-decoration: none;}
    A.NOEVENT:Visited {font-family :Tahoma, Verdana, Arial; font-size :12px; color :#000000; font-weight :normal; text-decoration: none;}

    A.EVENT:Link {font-family :Tahoma, Verdana, Arial; font-size :12px; color :#000000; font-weight :bold; text-decoration: none;}
    A.EVENT:Visited {font-family :Tahoma, Verdana, Arial; font-size :12px; color :#000000; font-weight :bold; text-decoration: none;}

    A.NORMAL:Link {font-family :Verdana, Arial; font-size :12px; color :#0000FF; font-weight :normal; text-decoration: none;}
    A.NORMAL:Visited {font-family :Verdana, Arial; font-size :12px; color :#0000FF; font-weight :normal; text-decoration: none;}
    </style>
    </head>

    <body LEFTMARGIN="3" BGCOLOR="#FFFFFF" TEXT="#000000">
    <p>&nbsp;</p>
    <h2 align="center">Vacation Schedule Calendar</h2>
    <h3 align="center"><%=Dept %></h3>
    <p align=center><a href="default.asp">Choose a different department/branch</a></p>
    <FORM ACTION="<% =sScript%>?Dept=<% =Dept %>&intStat=<% =intStat %>" METHOD=GET >
    <font face="Verdana, Arial" size="2">

    <div align="center">Select month and year:
    <SELECT NAME=MONTH>
    <OPTION VALUE=1 SELECTED>Jan
    <OPTION VALUE=2>Feb
    <OPTION VALUE=3>Mar
    <OPTION VALUE=4>Apr
    <OPTION VALUE=5>May
    <OPTION VALUE=6>Jun
    <OPTION VALUE=7>Jul
    <OPTION VALUE=8>Aug
    <OPTION VALUE=9>Sep
    <OPTION VALUE=10>Oct
    <OPTION VALUE=11>Nov
    <OPTION VALUE=12>Dec
    </SELECT>
    <SELECT NAME=YEAR>
    <option value="2006" selected>2006</option>
    </SELECT>
    <input type="hidden" name="Dept" value=<% =Dept %>>
    <input type="hidden" name="intStat" value=<% =intStat %>>
    <input type="submit" name="Submit" value="Go!">
    <! INPUT TYPE="Image" NAME="" SRC="images/go.gif" BORDER="0" WIDTH="35" HEIGHT="20">
    </div>
    </font>
    </FORM>
    <table ALIGN="CENTER" BORDER="1" CELLSPACING="0" CELLPADDING="2" BGCOLOR="White" BORDERCOLOR="Gray" width="75%">
    <tr><td>
    <table BORDER="1" CELLPADDING="1" CELLSPACING="0" BGCOLOR="#FFFFFF" width="100%">
    <tr HEIGHT="18" BGCOLOR="Silver">
    <td WIDTH="14%" HEIGHT="18" ALIGN="LEFT" VALIGN="MIDDLE">
    <div align="center"><a HREF="<% =sScript%>?month=<% =IntPrevMonth %>&amp;year=<% =IntPrevYear %>&Dept=<% =Dept %>&intStat=<% =intStat %>"><img SRC="images/prev.gif" WIDTH="14" HEIGHT="14" BORDER="0" ALT="Previous Month"></a></div>
    </td>
    <td WIDTH="*" COLSPAN="5" ALIGN="CENTER" VALIGN="MIDDLE" CLASS="SOME"><font size=+1><b>
    <% = strMonthName & " " & intThisYear %>
    </b> </font></td>
    <td WIDTH="14%" HEIGHT="18" ALIGN="RIGHT" VALIGN="MIDDLE">
    <div align="center"><a HREF="<% =sScript %>?month=<% =IntNextMonth %>&amp;year=<% =IntNextYear %>&Dept=<% =Dept %>&intStat=<% =intStat %>"><img SRC="images/next.gif" WIDTH="14" HEIGHT="14" BORDER="0" ALT="Next Month"></a></div>
    </td>
    </tr>
    <tr>
    <td ALIGN="center" CLASS="SOME" WIDTH="14%" HEIGHT="15" VALIGN="BOTTOM">Sunday</td>
    <td ALIGN="center" CLASS="SOME" WIDTH="14%" HEIGHT="15" VALIGN="BOTTOM">Monday</td>
    <td ALIGN="center" CLASS="SOME" WIDTH="14%" HEIGHT="15" VALIGN="BOTTOM">Tuesday</td>
    <td ALIGN="center" CLASS="SOME" WIDTH="14%" HEIGHT="15" VALIGN="BOTTOM">Wednesday</td>
    <td ALIGN="center" CLASS="SOME" WIDTH="14%" HEIGHT="15" VALIGN="BOTTOM">Thursday</td>
    <td ALIGN="center" CLASS="SOME" WIDTH="14%" HEIGHT="15" VALIGN="BOTTOM">Friday</td>
    <td ALIGN="center" CLASS="SOME" WIDTH="14%" HEIGHT="15" VALIGN="BOTTOM">Saturday</td>
    </tr>

    <%



    ' Initialize the end of rows flag to false
    EndRows = False
    Response.Write vbCrLf

    ' Loop until all the rows are exhausted
    Do While EndRows = False

    ' Start a table row
    Response.Write " <TR>" & vbCrLf
    ' This is the loop for the days in the week
    For intLoopDay = cSUN To cSAT
    ' If the first day is not sunday then print the last days of previous month in grayed font
    If intFirstWeekDay > cSUN Then
    Write_TD LastMonthDate, "NON"
    LastMonthDate = LastMonthDate + 1
    intFirstWeekDay = intFirstWeekDay - 1
    ' The month starts on a sunday
    Else
    ' If the dates for the month are exhausted, start printing next month's dates
    ' in grayed font
    If intPrintDay > intLastDay Then
    Write_TD NextMonthDate, "NON"
    NextMonthDate = NextMonthDate + 1
    EndRows = True
    Else
    ' If last day of the month, flag the end of the row
    If intPrintDay = intLastDay Then
    EndRows = True
    End If

    dToday = CDate(intThisMonth & "/" & intPrintDay & "/" & intThisYear)

    ' Open a record set of schedules
    Set Rs = Server.CreateObject("ADODB.RecordSet")

    sSQL = "SELECT * FROM tEvents WHERE " & _
    "Start_Date =#" & dToday & "# " & _
    "AND (Dept='" & Dept & _
    "' OR Dept='all')" & _
    " ORDER BY Start_Date"



    ' Open the RecordSet with a static cursor. This cursor provides bi-directional navigation
    Rs.Open sSQL, sDSN, adOpenStatic, adLockReadOnly, adCmdText

    If NOT Rs.EOF Then

    bEvents = True
    Do While NOT Rs.EOF

    ' build list of events for day
    'If logged in as manager or during initial entry period, include delete option, else display only names
    If intStat = 2 AND Rs("Dept") <> "all" Then
    strEvents = strEvents & Rs("Event_Title") & "<a href='delete.asp?Event_ID=" & Rs("Event_ID") & "&Dept=" & Dept & "&intStat=" & intStat & "'><font size=-2 color=red>DEL</font></a><br>"
    Else
    strEvents = strEvents & Rs("Event_Title") & "<br>"
    End If

    Rs.MoveNext

    Loop


    Else

    bEvents = False

    End If

    Rs.Close
    Set Rs = Nothing

    ' If the event flag is not raise for that day, print it in a plain font
    If bEvents = False Then
    Write_TD intPrintDay, "SOME"
    Else
    Write_TD intPrintDay & "<br>" & strEvents, "SOME"
    strEvents = ""


    End If

    End If


    ' Increment the date. Done once in the loop.

    intPrintDay = intPrintDay + 1
    'clear list of events
    strEvents = ""
    End If

    ' Move to the next day in the week

    Next
    Response.Write " </TR>" & vbCrLf

    Loop

    %>
    </table>
    </td></tr>
    </table>

  12. #12
    Join Date
    Aug 2007
    Posts
    1

    I need the solution

    Quote Originally Posted by Khalid
    I FOUND IT!
    I FOUND THE SOLUTION.

    If there is any one interested in this subject or suffering from it, contact me and I will tell him about the million dollar problem solution.

    I experiencing the same problem I can not find the solution. Please let me know how to solve

  13. #13
    Join Date
    Jan 2008
    Posts
    1

    database error

    I'm getting this error on my asp website, it was working good but not now

    Microsoft OLE DB Provider for ODBC Drivers error '8007000e'

    [Microsoft][ODBC Microsoft Access Driver] System resource exceeded

    Any help Thanks

Posting Permissions

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