View Single Post
  #1 (permalink)  
Old Jan 6th, 2008, 18:40
shammy2007 shammy2007 is offline
Junior Member
Join Date: Dec 2007
Location: Minnesota
Age: 25
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Got an error on the search feature

Hi.

Our website is not searching for anything. The search box use to work but now users just get an error.
I followed the error to see what was happening and well i cant see what is wrong. Its bringing up this error when users try to search.



Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1e8 Thread 0x234 DBC 0x995ef64 Jet'.
/Research_Library_backend.asp, line 85




I opened up the research libary asp file and looked at line 85,, cant see anything out of the ordinary.


here is a link to the website so you can see for yourself. Search engine is located in the research libary section.


http://browncountyhistorymnusa.org/

Below i have copied and pasted the part of the research libary file.


strconn="DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("browncounty.mdb")
SET objConn=Server.CreateObject("ADODB.Connection")
objConn.Open strconn
Set objRec = Server.CreateObject("ADODB.Recordset")

response.write "<table border=1>"

That is from line 82-88.
Im defo confused at this and we sure aint ASP experts.
thanks for your help
Reply With Quote