porcinetfou
New Member
I REALLY need some help, and im a newbie with all of this ASP stuff so any help is very very very much appreciated! <BR>ok now the question..im trying to log into my databse on my comp that i have running with IIS (i have win xp) and heres the error i get.. <BR><BR>Error Type: <BR>Microsoft JET Database Engine (0x80004005) <BR>Could not find installable ISAM. <BR>/table.asp, line 12 <BR><BR><BR>and heres my source <BR><BR><BR><% <BR>Dim DB <BR>Set DB = Server.CreateObject("ADODB.Connection") <BR>DB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; DRIVER={Microsoft Access Driver (*.mdb)}; Data Source=C:Inetpubwwwrootjbase.mdb" <BR>DB.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ <--- THIS IS LINE 12 <BR> "Dbq=C:Inetpubwwwrootjbase.mdb;" & _ <BR> "Uid=jake;" & _ <BR> "Pwd=blah;" <BR>writethis="SELECT fname FROM maintable WHERE ID=1" <BR>response.write "writethis" <BR>%> <BR><BR></body> <BR></html> <BR><%<BR>Dim Conn, dbase<BR>Dbase = "C:Inetpubwwwrootjbase.mdb"<BR>Set Conn = Server.CreateObject("ADODB.Connection")<BR>Conn.Open "PROVIDER=MICROSOFT.JET.<BR> SOURCE=" & dbase<BR><BR>Response.Write "Connected"<BR>Conn.Close<BR>Set Conn = Nothing<BR>%>it says provider cannot be found,<BR>what provider do I use?i tried this..<BR><% <BR>Dim Conn, dbase <BR>Dbase = "C:Inetpubwwwrootjbase.mdb" <BR>Set Conn = Server.CreateObject("ADODB.Connection") <BR>Conn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0" & dbase <BR><BR>Response.Write "Connected" <BR>Conn.Close <BR>Set Conn = Nothing <BR>%> <BR><BR><BR>with "PROVIDER=Microsoft.Jet.OLEDB.4.0" in it, and i stil lgot this error..<BR><BR>Error Type:<BR>ADODB.Connection (0x800A0E7A)<BR>Provider cannot be found. It may not be properly installed.<BR>Sorry I got the connection string wrong;<BR>this should work<BR><%<BR>dim objcon, Dbase<BR>Dbase = "C:Inetpubwwwrootjbase.mdb" <BR>set objcon = Server.createobject("Adodb.Connection")<BR>objcon.connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Dbase<BR><BR>objcon.open<BR>response.write("open")<BR><BR>objcon.close<BR>set objcon = nothing<BR>%><BR><BR>