Hai everyone
In my web site,in login page i have to capture the ms access db path in session variable,in log in button i get the db path and store in session variable.but if i use in main pages ,sometime session value not pass to main pages and it gives error like "No error message available, result code: DB_SEC_E_AUTH_FAILED(0x80040E4D)."
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: No error message available, result code: DB_SEC_E_AUTH_FAILED(0x80040E4D).
Source Error:
Line 1956: cmd = New OleDbDataAdapter(New OleDbCommand(strcmd))
Line 1957: cmd.SelectCommand.Connection = cn
Line 1958: cn.Open()------->with red color font
Line 1959: cmd.Fill(dt)
Line 1960: cn.Close()
if i use break point in connection string db path (session("dbpath")) is empty.
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Session("dbpath") & "; Jet OLEDB:Database Password= password;")
Pls reply asap
Note:Sometimes it work,if not work again need to debug the web site.
Regards
Aravind