Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Unanswered: ASP 'n Access Issues

    Well,

    Here is yet another ASP/Access error 80004005 and thanks for the time. If you are going to respond please read the whole post though.

    Error:

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.

    /q.asp, line 15

    Now, of the myriad and more obvious reasons this occurs when more than one recordset(RS) is created in ASP.

    When this script is executed, it alternates between failing at the SECOND RS declaration, a reload fails at the FIRST RS and continues to alternate.

    I have a feeling that new MS patches are causing some kinf of tightened security or other. The DSN checks out with proper rights and there is not an error in the connection string.

    Anyone seeing this phenom?



    See the code below:

    Code:
    <%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
    <!--#include file="Connections/connNonProd.asp" -->
    <%
    var rsStates = Server.CreateObject("ADODB.Recordset");
    rsStates.ActiveConnection = MM_connNonProd_STRING;
    rsStates.Source = "SELECT * FROM tblStates";
    rsStates.CursorType = 0;
    rsStates.CursorLocation = 2;
    rsStates.LockType = 3;
    rsStates.Open();
    var rsStates_numRows = 0;
    %>
    <%
    var rsTypes = Server.CreateObject("ADODB.Recordset");
    rsTypes.ActiveConnection = MM_connNonProd_STRING;
    rsTypes.Source = "SELECT * FROM tblCreditCardTypes";
    rsTypes.CursorType = 0;
    rsTypes.CursorLocation = 2;
    rsTypes.LockType = 3;
    rsTypes.Open();
    var rsTypes_numRows = 0;
    %>
    <%
    var Repeat1__numRows = -1;
    var Repeat1__index = 0;
    rsStates_numRows += Repeat1__numRows;
    %>
    <%
    var Repeat2__numRows = -1;
    var Repeat2__index = 0;
    rsStates_numRows += Repeat2__numRows;
    %>
    <html>
    <head>

  2. #2
    Join Date
    Sep 2003
    Posts
    4

    BTW

    I have also attempted to use different cursor type, but the problem seems to lie elsewhere. A single RS works totally fine.

    DB type is Access // IIS w/o .net

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    I think there might be something wrong in Connections/connNonProd.asp since the database file couldn't be found.
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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