Got an error on the search feature

[shammy2007]

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

[Monie]

Error codes in ASP can drive you crazy sometimes.

First, this in general means there is a PERMISSION problem getting to the DATABASE. Usually this happens when you do a security patch on your server, reboot your server, or install firewall software. All of these things can cause your web user to lose permission to access the critical files (like your database).

So first, check the basics. Make sure that IUSR has write permission to both the directory holding the database file and to any temp directories being used. Make sure that the DSN connection string is actually pointed at the directory you are working on! Check out my Connection String Here!

Even if you thought these were set properly, a reboot or a security upgrade might have unset them. Check them out!

Next, look into any other security blocks that may have been added. Have you added any anti virus or firewall software recently? Try turning it off and see if that helps. If it does, turn the software back on and then go into its configuration, and allow access to the directories in question.

Hope that's helps..
Cheers..