Problem in access database login
-
i am getting error .... the error is as under ----------------------- Exception Details: System.Data.OleDb.OleDbException: No error information available: REGDB_E_CLASSNOTREG(0x80040154). ------------------------- this error is on this line ----------------------- oledbCon.Open(); ------------------------ and my all code is as under --------------------------- <%@ Page Language="C#" Debug="True" %> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.OleDb" %> // Insert page code here OleDbConnection oledbCon; void Page_Load(Object sender, EventArgs e) { OleDbConnection oledbCon = new OleDbConnection("Provider = Microsoft.Jec.OleDb.4.0; DataSource = d:\\access1.mdb"); } void login_check(Object sender, EventArgs e) { string uid = txtuser.Text; string upass = txtpass.Text; OleDbConnection oledbCon = new OleDbConnection("Provider = Microsoft.Jec.OleDb.4.0; DataSource = d:\\access1.mdb"); OleDbCommand oledbCom = new OleDbCommand("Select fname from users where username = '"+uid+"' and upassword = '"+upass+"' ", oledbCon); oledbCon.Open(); OleDbDataReader dr = oledbCom.ExecuteReader(); if(dr.Read()) { Response.Write("You are logged in"); string url = Request.QueryString["ReturnUrl"]; if(url==null) url = "main.aspx"; Response.Redirect(url); } else { Response.Write("Your Login Faild Try to Register and then login"); } }
Access Login
Username:
Password:
-
i am getting error .... the error is as under ----------------------- Exception Details: System.Data.OleDb.OleDbException: No error information available: REGDB_E_CLASSNOTREG(0x80040154). ------------------------- this error is on this line ----------------------- oledbCon.Open(); ------------------------ and my all code is as under --------------------------- <%@ Page Language="C#" Debug="True" %> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.OleDb" %> // Insert page code here OleDbConnection oledbCon; void Page_Load(Object sender, EventArgs e) { OleDbConnection oledbCon = new OleDbConnection("Provider = Microsoft.Jec.OleDb.4.0; DataSource = d:\\access1.mdb"); } void login_check(Object sender, EventArgs e) { string uid = txtuser.Text; string upass = txtpass.Text; OleDbConnection oledbCon = new OleDbConnection("Provider = Microsoft.Jec.OleDb.4.0; DataSource = d:\\access1.mdb"); OleDbCommand oledbCom = new OleDbCommand("Select fname from users where username = '"+uid+"' and upassword = '"+upass+"' ", oledbCon); oledbCon.Open(); OleDbDataReader dr = oledbCom.ExecuteReader(); if(dr.Read()) { Response.Write("You are logged in"); string url = Request.QueryString["ReturnUrl"]; if(url==null) url = "main.aspx"; Response.Redirect(url); } else { Response.Write("Your Login Faild Try to Register and then login"); } }
Access Login
Username:
Password:
Hi there. You're using
Provider = Microsoft.Jec.OleDb.4.0
as a provider string... should it be
Provider = Microsoft.Jet.OleDb.4.0
instead? ("Jet" instead of "Jec"?)
-
Hi there. You're using
Provider = Microsoft.Jec.OleDb.4.0
as a provider string... should it be
Provider = Microsoft.Jet.OleDb.4.0
instead? ("Jet" instead of "Jec"?)
-
Gentlemen, the error is still there after changing the connection. plz suggest some other solution or if possible check it again. Thanks in Advance, Mazhar Hussain
Is it possible you don't have the Jet provider installed and registered on your machine?