Database engines? which one

[reubenb]

Hi there,
I have this database code (in a seperate file) for my login system that i downloaded and edited..
BUT...
it is

<%
level=""
SCRIPT_NAME = LCase(Request.ServerVariables("SCRIPT_NAME"))
if Instr(SCRIPT_NAME, "login")>0 then
level=""
else
level="login/"
end if

mpath= level & "db.mdb"
dsn = "DBQ=" & Server.Mappath(mpath) & ";Driver={Microsoft Access Driver (*.mdb)}; PWD=password"
%>


but it gives me this reallly weird

General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x6f8 Thread 0x684 DBC 0x2151ff4 Jet'.


so should i (how would i do this) change the engine somehow to Microsoft.Jet.OLEDB.4.0 ???

please respond ASAP as this is kinda URGENT :D
(by the way, what happend to [script] ?)

[Spudhead]

I believe that error is *usually* caused by incorrect permissions - check the file/folder isn't read only and that the Internet Guest Account (that IIS runs under) has permission to access it. You shouldn't have to change your database connection string but TBH it wouldn't hurt, I think the Jet ones are better aren't they?

(and [script] got replaced, I think, by [ CODE ])

[reubenb]

okay thanks fixed it