I try to make my own SessionStoreProvider
I understand that I can inherit from SessionStateStoreProviderB
I need to set a custom store (custom tables and SP)
But when I run the site, I get the error that the ASP.NET regsql needs to be installed.
Do I need to run any scripts?
What should be the configuration?
Thanks
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
That's exactly what I need... But I haven't succeed to make it work
It seems that I need to tell regsql that I'm gonna use my provider.
Do you see what I mean?
Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above.]
As per MSDN Documentation - Aspnet_regsql is used for
"Installing or removing the database elements for the membership, role management, profile, Web Parts personalization, health monitoring features, SQL session state and SQL cache dependency "
As you have your own custom session state store you should not need aspnet_regsql unless you use any of the above. If yes you *must* run aspnet_regsql with no command line switches so it starts wizard
Can you please check on following things:
1) What connectionstring you use to connect to custom Session state DB? Does user have access to your custom session DB? Try to fetch some rows from it by firing dummy queries.
3)
What web.config settings you use to indicate your web app is using custom session state data store instead of built-in?
Example web.config setting from MSDN article.
<system.web>
<sessionState
cookieless="true"
regenerateExpiredSessionId
mode="Custom"
customProvider="OdbcSessio
<providers>
<add name="OdbcSessionProvider"
type="Samples.AspNet.Sessi
connectionStringName="Odbc
writeExceptionsToEventLog=
</providers>
</sessionState>
</system.web>
Lets see how it goes
It seems that I had a problem with my config ...
I made it!!
I will put my version soon:
http://breezback.blogspot.
Business Accounts
Answer for Membership
by: maulikCEPosted on 2007-07-01 at 05:31:32ID: 19398564
Checkout MSDN article,
http://msdn2.microsoft.com