Could not find Installable ISAM

[reubenb]

Hi, i know this has been asked before and i searched for it but it makes no sense and doesnt apply for what i am asking..

with this line of code for a database.asp (is included on everypage)

<%
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) & ";Provider=Microsoft.Jet.OLEDB.4.0; Data Source=; PWD=password"
%>


but it gives me this error;

Microsoft JET Database Engine error '80004005'

Could not find installable ISAM.

/login/login/join2.asp, line 17


how can i fix this?
ANYONE??? pleeeeeeeeaseee?

[A1ien51]

Google does wonders:

http://www.dotnet247.com/247reference/msgs/12/61447.aspx

[reubenb]

oooh okay, thanks i will tell my sysadmin.
but one more thing, if someone can help me...

how come that if i use this db connection (for the script in my first post):

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

it will give me error


[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x6f8 Thread 0x684 DBC 0x2108fd4 Jet'.

although, if i use this one:


dsn = "DBQ=" & Server.Mappath(mpath) & ";Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\db.mdb; PWD=password"

it will give me this error

Could not find installable ISAM.

??? it doesn't make any sense... one is looking for ISAM and the other one is telling me equivelent to like an auth. failure!!