Also, if you plan on putting the database outside your www folder, you will have to state where it is using relative path structure (..\..\path\file.mdb) as it will NOT accept a Full Path statement (C:\path\file.mdb) For example, if you put your database here: C:\inetpub\data\referer.mdb and your www folder is C:\inetpub\forum\ then you would have to specify the following line (line 16 in inc_ref_log.asp):
accessdb="..\data\referer.mdb"
I'm trying to make it: accessdb="db\referer.mdb" - as my db is in this folder.
The ..\ move it up from where you are, so if your forum is wwwroot\forum and your database is wwwroot\db then you need to use accessdb="..\db\referer.mdb"
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x6ac Thread 0xddc DBC 0x23feff4 Jet'.
/forum/inc_ref_log.asp, line 27
if request.servervariables("http_referer") = "" or instr(lcase(request.servervariables("http_referer")), lcase(mydomain)) >=1 then refstatus="INVALID REFERER DETECTED! Is either BLANK or LOCAL" else refstatus="VALID REFERER DETECTED" set refrs = server.createobject("ADODB.Recordset") refcn="DRIVER={Microsoft Access Driver (*.mdb)};" refcn=refcn & "DBQ=" & server.mappath(accessdb) refsql = "insert into referer (ip,referer,request,query,agent) " refsql= refsql & "values('"& refip &"','"& referer &"','"& replace(p_info,"referer;","") &"','"& q_string &"','"& refagent &"')"
[line 27]refrs.open refsql, refcn
end if
set refrs=nothing set refcn=nothing
This is what i have [accessdb="..\db\referer.mdb"] - maybe need more: Do i need my users name? [accessdb="..\username\db\referer.mdb"] Maybe more dots?
Topic Locked
Posted - 16 June 2003 : 17:26:59
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 