I am using SQL Server 2008 R2 Express Edition with ASP.NET applcation. The application has 5-10 concurrent connections at any given time.
When the application's home page is opened, it displays few DropDown controls with options for users to select and log in. Sometimes these DropDowns start displaying random serial numbers of other column's, cached passwords etc. Anything related to database
access starts malfunctioning.
To correct this issue, we need to restart background SQL Service running on Windows Server.
I want to know what is the reason of this problem and why the service starts malfunctioning. Is there anything special I need to configure in IIS?
hi..please try to use single connection ...when u need a data open db and get data then ucan store session or datatable then close the connection
check this ..weather u are give a data to user via server variable.
A.Venkatesan
Microsoft Certified Professional
Please mark the replies as answers if they help or unmark if not.
If you have any feedback about my replies, please contact venkatmca008@gmail.com
hi...please do 5 or 6 times debugging code by code using F9 or F10.please see the flow and check each line of code and check output..sure u will find .else post ur code i will let u know..
A.Venkatesan
Microsoft Certified Professional
Please mark the replies as answers if they help or unmark if not.
If you have any feedback about my replies, please contact venkatmca008@gmail.com
A.Venkatesan
Microsoft Certified Professional
Please mark the replies as answers if they help or unmark if not.
If you have any feedback about my replies, please contact venkatmca008@gmail.com
rpk2006
Member
631 Points
629 Posts
Application starts displaying wrong data but corrects when SQL Server service restarts.
Feb 22, 2012 03:45 AM|LINK
I am using SQL Server 2008 R2 Express Edition with ASP.NET applcation. The application has 5-10 concurrent connections at any given time.
When the application's home page is opened, it displays few DropDown controls with options for users to select and log in. Sometimes these DropDowns start displaying random serial numbers of other column's, cached passwords etc. Anything related to database access starts malfunctioning.
To correct this issue, we need to restart background SQL Service running on Windows Server.
I want to know what is the reason of this problem and why the service starts malfunctioning. Is there anything special I need to configure in IIS?
</div>venkatmca008
Participant
1810 Points
341 Posts
Re: Application starts displaying wrong data but corrects when SQL Server service restarts.
Feb 22, 2012 03:53 AM|LINK
hi..please try to use single connection ...when u need a data open db and get data then ucan store session or datatable then close the connection
check this ..weather u are give a data to user via server variable.
Microsoft Certified Professional
Please mark the replies as answers if they help or unmark if not.
If you have any feedback about my replies, please contact venkatmca008@gmail.com
rpk2006
Member
631 Points
629 Posts
Re: Application starts displaying wrong data but corrects when SQL Server service restarts.
Feb 22, 2012 04:04 AM|LINK
I am doing the same and there is no way that the application may use another connection string.
I am also closing the connection after each execution.
venkatmca008
Participant
1810 Points
341 Posts
Re: Application starts displaying wrong data but corrects when SQL Server service restarts.
Feb 22, 2012 04:11 AM|LINK
hi...please do 5 or 6 times debugging code by code using F9 or F10.please see the flow and check each line of code and check output..sure u will find .else post ur code i will let u know..
Microsoft Certified Professional
Please mark the replies as answers if they help or unmark if not.
If you have any feedback about my replies, please contact venkatmca008@gmail.com
rpk2006
Member
631 Points
629 Posts
Re: Application starts displaying wrong data but corrects when SQL Server service restarts.
Feb 22, 2012 05:09 AM|LINK
On right-clicking the database and selecting Properties, SQL Server is showing 4 users connected whereas there are only two connections.
venkatmca008
Participant
1810 Points
341 Posts
Re: Application starts displaying wrong data but corrects when SQL Server service restarts.
Feb 22, 2012 05:32 AM|LINK
please post ur code let me check..
Microsoft Certified Professional
Please mark the replies as answers if they help or unmark if not.
If you have any feedback about my replies, please contact venkatmca008@gmail.com
rpk2006
Member
631 Points
629 Posts
Re: Application starts displaying wrong data but corrects when SQL Server service restarts.
Feb 22, 2012 06:28 AM|LINK
There are too many files. Which code to post?
Chen Yu - MS...
All-Star
21600 Points
2493 Posts
Microsoft
Re: Application starts displaying wrong data but corrects when SQL Server service restarts.
Feb 27, 2012 09:03 AM|LINK
Hi,
Please post your debugging code which you use F9 or F10 to check your output.
Thanks.
Feedback to us
Develop and promote your apps in Windows Store