<% Option Explicit Dim oCmd, oParam, oRst, intAreaID set oCmd = server.createObject("ADODB.Command") oCmd.ActiveConnection = "MMSDB" oCmd.CommandText = "Qry-Get_Block" oCmd.CommandType = adCmdStoredProc intAreaID = CInt(cstr(request.querystring("areaID"))) set oParam = oCmd.CreateParameter("The_Area", adInteger, adParamInput, , intAreaID) 'name of para, type, direction, size, value oCmd.Parameters.Append oParam set oRst = oCmd.Execute > <% > Option Explicit > > Dim oCmd, oParam, oRst, intAreaID > > set oCmd = server.createObject("ADODB.Command") > oCmd.ActiveConnection = "MMSDB" > oCmd.CommandText = "Qry-Get_Block" > oCmd.CommandType = adCmdStoredProc > > intAreaID = CInt(cstr(request.querystring("areaID"))) > > set oParam = oCmd.CreateParameter("The_Area", adInteger, > adParamInput, , intAreaID) > 'name of para, type, direction, size, value > oCmd.Parameters.Append oParam > set oRst = oCmd.Execute Help!! Microsoft OLE DB Provider for ODBC Drivers error '80040e37' - ASP Components
Professional Web Applications Themes

Help!! Microsoft OLE DB Provider for ODBC Drivers error '80040e37' - ASP Components

Hello All, I've recently migrated servers (NT 4.0 sp6) to Win2k3 Standard, and I now have this error message on a webpage. The problem only occured after the server change. I dont' see where it is refering to the table/query 'Qry'. I'm not very well versed in ASP, so any help is greatly appreciated. Thanks Carlitosway -ERROR MESSAGE- Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'Qry'. Make sure it exists and that its name is spelled correctly. /mmsdata/get_block.asp, line 17 -ASP Script- ...

  1. #1

    Default Help!! Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

    Hello All,

    I've recently migrated servers (NT 4.0 sp6) to Win2k3
    Standard, and I now have this error message on a webpage.
    The problem only occured after the server change. I dont'
    see where it is refering to the table/query 'Qry'. I'm
    not very well versed in ASP, so any help is greatly
    appreciated.
    Thanks

    Carlitosway


    -ERROR MESSAGE-
    Microsoft OLE DB Provider for ODBC Drivers
    error '80040e37'

    [Microsoft][ODBC Microsoft Access Driver] The Microsoft
    Jet database engine cannot find the input table or
    query 'Qry'. Make sure it exists and that its name is
    spelled correctly.

    /mmsdata/get_block.asp, line 17


    -ASP Script-
    <!--METADATA TYPE="typelib" FILE="c:\program files\common
    files\system\ado\msado15.dll"-->
    <%
    Option Explicit

    Dim oCmd, oParam, oRst, intAreaID

    set oCmd = server.createObject("ADODB.Command")
    oCmd.ActiveConnection = "MMSDB"
    oCmd.CommandText = "Qry-Get_Block"
    oCmd.CommandType = adCmdStoredProc

    intAreaID = CInt(cstr(request.querystring("areaID")))

    set oParam = oCmd.CreateParameter("The_Area", adInteger,
    adParamInput, , intAreaID)
    'name of para, type, direction, size, value
    oCmd.Parameters.Append oParam
    set oRst = oCmd.Execute <!---THIS IS LINE 17

    %>

    <HTML>
    <HEAD>
    <SCRIPT language ="javascript">

    function GetStructureName(obj) {
    i = obj.selectedIndex;
    var strURL = new String;
    if (i>1) {
    parent.structure.ShowLoading();
    strURL = "" + parent.pltdata.location;
    strURL.toLowerCase();
    if (strURL.indexOf("dc.asp", 1) <1) {
    parent.pltdata.location = "pltdata.asp";
    parent.structure.location = 'Get_Name.asp?UID=<%
    =request.querystring("UID")%>&BlockID=' + obj.options
    [i].value;
    }
    else
    parent.structure.location = 'Get_Name2.asp?UID=<%
    =request.querystring("UID")%>&BlockID=' + obj.options
    [i].value;
    }
    }

    function ShowLoading() {
    doent.blockform.block.selectedIndex = 0;
    }
    </script>
    <TITLE>Twachtman Snyder &amp; Byrd, Inc.</TITLE></HEAD>
    <BODY TOPMARGIN="5" leftmargin="2" BGCOLOR="FFFFFF">
    <center>
    <form name="blockform">
    <SELECT NAME="block" SIZE="1" onChange=GetStructureName
    (block) Style="font-size:8pt; width:80px">
    <option value='-1' >Loading...</option>
    <option value='0' selected>[BLOCK]</option>
    <%
    do while not oRst.eof
    response.write "<option value='" & oRst.fields("Block
    ID") & "'>" & _
    oRst.fields("Block") & "</option>"
    oRst.movenext
    Loop
    %>

    </select>
    </form>
    </center>
    </BODY>
    </HTML>
    Help!! Microsoft OLE DB Provider for ODBC Drivers error '80040e37' Guest

  2. #2

    Default Re: Help!! Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

    I'd suggest the following articles over at [url]http://www.aspfaq.com[/url].

    [url]http://www.aspfaq.com/show.asp?id=2126[/url]
    [url]http://www.aspfaq.com/show.asp?id=2164[/url]
    [url]http://www.aspfaq.com/show.asp?id=2195[/url]

    One last thing stop using ODBC as it has been Deprecated as of ADO 2.8.
    It is slow & hard to manage etc...

    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/ado_deprecated_components.asp[/url]


    Help!! Microsoft OLE DB Provider for ODBC Drivers error '80040e37' wrote:
    > Hello All,
    >
    > I've recently migrated servers (NT 4.0 sp6) to Win2k3
    > Standard, and I now have this error message on a webpage.
    > The problem only occured after the server change. I dont'
    > see where it is refering to the table/query 'Qry'. I'm
    > not very well versed in ASP, so any help is greatly
    > appreciated.
    > Thanks
    >
    > Carlitosway
    >
    >
    > -ERROR MESSAGE-
    > Microsoft OLE DB Provider for ODBC Drivers
    > error '80040e37'
    >
    > [Microsoft][ODBC Microsoft Access Driver] The Microsoft
    > Jet database engine cannot find the input table or
    > query 'Qry'. Make sure it exists and that its name is
    > spelled correctly.
    >
    > /mmsdata/get_block.asp, line 17
    >
    >
    > -ASP Script-
    > <!--METADATA TYPE="typelib" FILE="c:\program files\common
    > files\system\ado\msado15.dll"-->
    > <%
    > Option Explicit
    >
    > Dim oCmd, oParam, oRst, intAreaID
    >
    > set oCmd = server.createObject("ADODB.Command")
    > oCmd.ActiveConnection = "MMSDB"
    > oCmd.CommandText = "Qry-Get_Block"
    > oCmd.CommandType = adCmdStoredProc
    >
    > intAreaID = CInt(cstr(request.querystring("areaID")))
    >
    > set oParam = oCmd.CreateParameter("The_Area", adInteger,
    > adParamInput, , intAreaID)
    > 'name of para, type, direction, size, value
    > oCmd.Parameters.Append oParam
    > set oRst = oCmd.Execute <!---THIS IS LINE 17
    >
    > %>
    >
    > <HTML>
    > <HEAD>
    > <SCRIPT language ="javascript">
    >
    > function GetStructureName(obj) {
    > i = obj.selectedIndex;
    > var strURL = new String;
    > if (i>1) {
    > parent.structure.ShowLoading();
    > strURL = "" + parent.pltdata.location;
    > strURL.toLowerCase();
    > if (strURL.indexOf("dc.asp", 1) <1) {
    > parent.pltdata.location = "pltdata.asp";
    > parent.structure.location = 'Get_Name.asp?UID=<%
    > =request.querystring("UID")%>&BlockID=' + obj.options
    > [i].value;
    > }
    > else
    > parent.structure.location = 'Get_Name2.asp?UID=<%
    > =request.querystring("UID")%>&BlockID=' + obj.options
    > [i].value;
    > }
    > }
    >
    > function ShowLoading() {
    > doent.blockform.block.selectedIndex = 0;
    > }
    > </script>
    > <TITLE>Twachtman Snyder &amp; Byrd, Inc.</TITLE></HEAD>
    > <BODY TOPMARGIN="5" leftmargin="2" BGCOLOR="FFFFFF">
    > <center>
    > <form name="blockform">
    > <SELECT NAME="block" SIZE="1" onChange=GetStructureName
    > (block) Style="font-size:8pt; width:80px">
    > <option value='-1' >Loading...</option>
    > <option value='0' selected>[BLOCK]</option>
    > <%
    > do while not oRst.eof
    > response.write "<option value='" & oRst.fields("Block
    > ID") & "'>" & _
    > oRst.fields("Block") & "</option>"
    > oRst.movenext
    > Loop
    > %>
    >
    > </select>
    > </form>
    > </center>
    > </BODY>
    > </HTML>
    joker Guest

Similar Threads

  1. Question Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
    By Unregistered in forum Brainstorming Area
    Replies: 0
    Last Post: February 17th, 08:15 AM
  2. Microsoft OLE DB Provider for ODBC Drivers error'80040e14'
    By jkeeler in forum Dreamweaver AppDev
    Replies: 1
    Last Post: February 17th, 02:12 AM
  3. Replies: 1
    Last Post: August 18th, 12:32 AM
  4. Replies: 1
    Last Post: August 26th, 03:49 PM
  5. Replies: 2
    Last Post: July 1st, 02:14 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139