Problem with provider
Problem with provider
Im getting the foll. error:
column "locked" is of type bit but expression is of type integer
and why is it that for login name i get Administrators\ instead of actual username
is the provider really reliable?
Please guide
Mayank
column "locked" is of type bit but expression is of type integer
and why is it that for login name i get Administrators\ instead of actual username
is the provider really reliable?
Please guide
Mayank
Please specify these problems in details: what is the expression of type integer, when do you get Administrators\?
You can send us small test project if possible to reproduce the problem; it is desirable to use 'test' schema objects, otherwise include definition of
your own database objects. Do not use third party components.
If it is impossible for you to create test project please send us a piece of
your code which causes said errors.
You can send us small test project if possible to reproduce the problem; it is desirable to use 'test' schema objects, otherwise include definition of
your own database objects. Do not use third party components.
If it is impossible for you to create test project please send us a piece of
your code which causes said errors.
Issue Solved
Im sorry for posting the previous message without doing proper research myself..
The integer problem got solved by changing the data type of aspnet_sessions.locked to smallint from bit
The username problem got solved by changing the authentication type in web.config from windows to forms
However I do have another question ... why has the bit data type been used for userid columns instead of int or bigint? I need to capture the user id in my code
thanks
The integer problem got solved by changing the data type of aspnet_sessions.locked to smallint from bit
The username problem got solved by changing the authentication type in web.config from windows to forms
However I do have another question ... why has the bit data type been used for userid columns instead of int or bigint? I need to capture the user id in my code
thanks
Is there any alternative
But what I know about GUIDs is that they require more storage space and it takes more time to analyze when used in a WHERE clause compared to integer values
Is it possible for me to add one more column to the membership table (bigintserial) and use it in my code and other tables instead of using GUID columns in all the tables??
Please suggest
Is it possible for me to add one more column to the membership table (bigintserial) and use it in my code and other tables instead of using GUID columns in all the tables??
Please suggest
Session.Abandon() causes error
On logout I call session.abandon() method which gives the foll. error ... why?
syntax error at or near "*"
stack trace
[PgSqlException (0x80004005): syntax error at or near "*"]
CoreLab.Common.Web.Providers.DbSessionStateStore.RemoveItem(HttpContext context, String id, Object lockId, SessionStateStoreData item) +394
System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +371
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +138
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +65
syntax error at or near "*"
stack trace
[PgSqlException (0x80004005): syntax error at or near "*"]
CoreLab.Common.Web.Providers.DbSessionStateStore.RemoveItem(HttpContext context, String id, Object lockId, SessionStateStoreData item) +394
System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +371
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +138
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +65
Please send us small test project if possible to reproduce this problem; it is desirable to use 'test' schema objects, otherwise include definition of
your own database objects. Do not use third party components.
If it is impossible for you to create test project please send us a piece of
your code where the error occurs.
your own database objects. Do not use third party components.
If it is impossible for you to create test project please send us a piece of
your code where the error occurs.
the problem is simple to recreate...
Add a login control on one page A and login status on another B. the user is redirected to B. in the LoggingOut event say Session.Abandon() and there u go with the error mentioned above.
Ive simply added the same content to web.config as given in CoreLab help.
And I just realised that there is no personalisation support .. is it going to be added in later versions?
Add a login control on one page A and login status on another B. the user is redirected to B. in the LoggingOut event say Session.Abandon() and there u go with the error mentioned above.
Ive simply added the same content to web.config as given in CoreLab help.
And I just realised that there is no personalisation support .. is it going to be added in later versions?
Sorry again.. personalization is supported
Sorry didn't do proper research again... provider does support personalization. But in which table is the personalization data stored?
No doesn't support personalization
I thought it supports but my project was actually using the sql server express ..