Session state in sql server not working Problem in Appname
I am using sitefinity 6.3 application with .net 4.0 and sql server 2008
I am trying to configure application with sql server. I have setup ASPState db on my database server and in my connection string i have put following connection string
<sessionState mode="SQLServer" cookieless="false" timeout="20" sqlConnectionString="data source=myserverlocation;user id=YYYYYY;password=XXXXXX;" />
But when Trying to browse my site i am geting error
**Conversion failed when converting the varchar value '9105e526' to data type int.**
When digged out problem in ASpState db via profile i check @appName is passing as 9105e526
DECLARE @return_value int,
@appId int
EXEC @return_value = [dbo].[TempGetAppID]
@appName = 9105e526,
@appId = @appId OUTPUT
SELECT @appId as N'@appId'
SELECT 'Return Value' = @return_value
If i remove character e from @appName the procedure executes
Can any body guide how can i make my application work
Hello Kamran,
By default we do not do anything with session state withing Sitefinity.
Maybe you can find more information about <sessionState> configuration and troubleshooting here: ASP.NET Session State.
Regards,
Boyko Nistorov
Telerik
Thanks Boyko
My this post http://forums.asp.net/t/1994402.aspx?Asp+net+Session+in+sql+server+resulting+in+error at asp.net forum helps in resolving the issue