Reference MDB but Heh it's not Mine.

Results 1 to 5 of 5

Thread: Reference MDB but Heh it's not Mine.

  1. #1
    Eric Brennan Guest

    Default Reference MDB but Heh it's not Mine.

    I have this small asp script were I use a dsn connection to link to a mdb call Tracking.mdb<BR><BR>When I run the script I get the error that it cannot find another mdb called wbtLookup.mdb I have used this mdb in the past but not on this page. The missing mdb is in the right location. <BR><BR>Does the ASP service have some settings somewhere were this file could be hard coded in? <BR><BR>Current asp script<BR><BR>strSSN = Request.Cookies("IDnum")<BR>response.write strSSN<BR>&#039;Create DSNLess connection<BR><BR>set cnnComplete=server.createobject("adodb.connection" )<BR>set rstComplete=Server.createobject("ADODB.recordset") <BR>strSource ="Driver={Microsoft Access Driver (*.mdb)}"<BR>strSource = strSource & "; DBQ=D:InetpubwwwrootmdbsTracking.mdb"<BR>cnnComple te.ConnectionString = strSource<BR>cnnComplete.Open <BR><BR>&#039;Build Insert statement<BR>SQLStatement = "Select * from qryWho" &#039; where SSN =" & strSSN<BR><BR>&#039;Execute<BR> SQLStatement, cnnComplete<BR>%&#062;<BR>&#060;title&#062;Pull Completed pages&#060;/title&#062;<BR><BR><BR>Pull completed date<BR><BR><BR>&#060;p&#062;&#060;% do While not rstComplete.EOF%&#062;<BR>&#060;% response.write rstComplete("Url")%&#062;<BR><BR> &#060;% rstComplete.MoveNext <BR>loop %&#062;&#060;/p&#062;<BR><BR>Error message:<BR><BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80004005&#039; <BR><BR>[Microsoft][ODBC Microsoft Access Driver] &#039;H:MDBsWBTlookup.mdb&#039; is not a valid path. Make sure that the path name is spelled correctly and that you are connected to<BR>the server on which the file resides. <BR><BR>/test.asp, line 21 <BR><BR>Thanks <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Reference MDB but Heh it's not Mine.

    so this is someone else&#039;s DB? why not ask them? did you grab it without permission&#062; ;-)

  3. #3
    Eddie Campbell Guest

    Default RE: Reference MDB but Heh it's not Mine.

    Try clearing out your internet cache. You may have an old cached version pointing at the wrong Mdb.

  4. #4
    Eric Brennan Guest

    Default How do I clear out the Cache

    How do I clear out the Cache?

  5. #5
    Eric Brennan Guest

    Default Clearing Cache

    This happens on multiply machines. I do not think it is local cache.

Posting Permissions

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