why session value not get in another page in asp.net ?

Question

0.00/5 (No votes)

See more:

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.

VB

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

Posted 31-Jul-13 17:51pm

Aravindba

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thanks7872 · Answer 1 · 2013-07-31T18:15:00

Solution 1

There is nothing like a confusion here. You have already checked and found that sometimes session("dbpath") doesnt have value and thats why you are getting error.

First of all,I dont know why you are assiging your datasource like this. Try applying the datasource directly. Or before the statement try to check if session is empty(null) or not.

Regards..:laugh:

Posted 31-Jul-13 18:15pm

Thanks7872

Comments

Aravindba 1-Aug-13 0:44am

Thank for ur reply,if we take this way,based on user i have to change the database,so in log in page i have get the database path from table and pass in session variable.
And why i give connection string in each and every page,bcz in logout button i clear the session ,so only it not go back after log out otherwise it go previous page after logout