PDA

View Full Version : Session variable lost.


Earth Boy
Dec 20, 2006, 12:02 PM
Hi All,
The problem I am getting is strange.

Actually I am using a session variable in a SQL query string that is used on all of the page load methods of my web pages.

for Ex: abc_Liberary_proc 1234,'OH','MC'

in this query string, 1234 is a unique id associated with each session of the site.

But sometimes... yes sometimes the query comes like abc_Liberary_proc ,'OH','MC'

the unique id is lost or something and not available in the session. This only happen in the production environment not in the development environment... so I think its because of the load on server but I am not sure. And one more thing... we have 2 web servers with load balancing enabled on them. For session handling we are using ASPState in SQL server.

Well guys if anyone of you can give me a solution or hint of the reason behind this... I'll be really glad.

I hope I am asking in the correct manner cause I am new to this website...

peace
Earth Boy