Last post Feb 27, 2012 10:03 AM by Chen Yu - MSFT
Feb 22, 2012 04:45 AM|rpk2006|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?
Feb 22, 2012 04:53 AM|venkatmca008|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.
Feb 22, 2012 05:04 AM|rpk2006|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.
Feb 22, 2012 05:11 AM|venkatmca008|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..
Feb 22, 2012 06:09 AM|rpk2006|LINK
On right-clicking the database and selecting Properties, SQL Server is showing 4 users connected whereas there are only two connections.
Feb 22, 2012 06:32 AM|venkatmca008|LINK
please post ur code let me check..
Feb 22, 2012 07:28 AM|rpk2006|LINK
There are too many files. Which code to post?
Feb 27, 2012 10:03 AM|Chen Yu - MSFT|LINK
Which code to post?
Please post your debugging code which you use F9 or F10 to check your output.