Hello,
I have been connecting to an access db and its been working fine but all of a sudden I am getting this error -
the error points to the dsn name -- connect.Open("DSN=hhhba");
I have googled this error and checked the permissions in IIS and still no luck.
Thanks for helping
I have been connecting to an access db and its been working fine but all of a sudden I am getting this error -
Code:
Provider error '80004005'
Unspecified error
/loginVerify.asp, line 15the error points to the dsn name -- connect.Open("DSN=hhhba");
Code:
<%@ language=JScript %>
<!-- #include file="adojavas.inc" -->
<html>
<head>
</head>
<body>
<%
var umail = Request.Form("uemail")
var userPass=Request.Form("upass")
Session("Umail") = umail.Item;
Session("upass") = userPass.Item;
var connect = Server.CreateObject("ADODB.Connection");
var record = Server.CreateObject("ADODB.RecordSet");
connect.Open("DSN=hhhba");
record.Open("select * from GenralInformation where EmailAddress ='"+ umail+"' And userPass ='"+ userPass+"'", connect, adOpenKeyset,adLockOptimistic);
if(record.EOF)
{
Response.Redirect("login1FAIL.asp")
}
else
{
Response.Redirect("formChoice.asp")
}
connect.close();
connect=null;
%>
</body>
</html>I have googled this error and checked the permissions in IIS and still no luck.
Thanks for helping