I have a small problem, when i CTRL+F5 in Visual studio everything work, and i can login with my account i have made. But when i try on the webserver where i uploaded the same code, then i can't login? I can see that it should work, because if I choose a
wrong password, it says that it was wrong, but when i choose the right one, I just get an empty page.
I'm a newbie to this ASP.NET stuff. Want to learn and have downloaded Victor's version of the starter site using VB and Access. I seem to have two issues (be gentle, I'm a newbie) BTW, both of these worked when I had the original version of the asp.net
starter site.
First, after installing the site, I click CTRL - F5 and get this error:
Unknown
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Line 94: lookupCommand.Parameters.Add(new OleDbParameter("@AppName", applicationName));
Line 95:
Line 96: object lookupResult = lookupCommand.ExecuteScalar();
Line 97: if ((lookupResult != null) && (lookupResult is int)) {
Line 98: return (int)lookupResult;
Secondly, I cannot set up an administrator account for the site. I go to "website" -> ASP.NET Configuration -> Security and I get this error message:
"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to
a page where you can choose a new data store."
If I then go to "Choose Data Store" and then to "Select a single provider for all site management data" it says "no providers created" how do I create it... is it talking about an ODBC driver?
Dude this post saved my life today...Argh! It's so hard to work with SQLExpress on a development machine...I thought it was just gonna be a plug and play kind of thing...but it was hell =)
So thanks again for posting that.
Based on my usage of it it took a little tweaking to get it to run in my SurveyCenter application (for instance I had to modify the Application name table, and clear out the old entries. Then I had to fiddle with the Configuration Manager tool site for a bit...at
first it didn't work but after a few restarts it worked...the rest was modifying web.config.
Then I uploaded and Whammo! It didn't work :)
Then I did some more surfing, and sacrificing to the gods...then finally I found out that you have to tell your host to give the database folder, and all databases in it read/write/modify permissions...
I'm a newbie to this ASP.NET stuff. Want to learn and have downloaded Victor's version of the starter site using VB and Access. I seem to have two issues (be gentle, I'm a newbie) BTW, both of these worked when I had the original version of the asp.net
starter site.
First, after installing the site, I click CTRL - F5 and get this error:
Unknown
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Line 94: lookupCommand.Parameters.Add(new OleDbParameter("@AppName", applicationName));
Line 95:
Line 96: object lookupResult = lookupCommand.ExecuteScalar();
Line 97: if ((lookupResult != null) && (lookupResult is int)) {
Line 98: return (int)lookupResult;
Secondly, I cannot set up an administrator account for the site. I go to "website" -> ASP.NET Configuration -> Security and I get this error message:
"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to
a page where you can choose a new data store."
If I then go to "Choose Data Store" and then to "Select a single provider for all site management data" it says "no providers created" how do I create it... is it talking about an ODBC driver?
Not sure what was different, but I whiped the O/S and had to install all of this on another machine and now that I try it, it all works. Not sure what was different.
Got it working, i talked to the company that host my side, and they change the rights on the server, so now everything is working.
Again, thanx for a great job on this project.
Right now im trying to make a page that i can use as contol of members and roles.
Can i use the "AccessMembershipProvider.cs" and "AccessRoleProvider.cs" for this?
I have tryed ObjectDataSource, but i get an error, so i probaly did something wrong. But i have to use the "AccessMembershipProvider.cs" or am i wrong?
Yes, you should be able to use the Access Providers. There are some limitations to the providers that are referenced in the readme. See below:
All providers
-------------
None of the providers support the "commandTimeout" attribute. The providers issue OleDb commands using
the default timeout for OleDbCommand(s) which is 30 seconds.
The providers all carry out read and write operations against the $safeprojectname$ database using the security
credentials associated with the current request. Unlike the built-in providers, the sample providers do
not suspend impersonation when client impersonation is in effect. This means one of the following
identities requires Read/Write access to the App_Data directory:
1. The worker process identity if no impersonation is used.
2. The application impersonation identity if <identity impersonate="true" user="userid" password="pwd" /> is used.
3. Each client identity if <identity impersonate="true" /> is used.
Parameter validation and syntax checking of parameters is current as of ASP.NET 2.0 Beta 1. As a result
the parameter validations used in Beta 2 and RTM providers will differ slightly from the validations
enforced by the $safeprojectname$ providers.
Membership
----------
Password strength requirements are not enforced in the CreateUser and ChangePassword methods. The settings are
read from configuration, but at are not used by the provider.
Account lockouts are not implemented in the provider. The UnlockUser method has no effect, and the provider
does not count bad password or bad password answer attempts.
The $safeprojectname$ provider does not support creating a new user with an explicit UserId (i.e. providerUserKey).
The $safeprojectname$ provider does not support retrieving a user based on UserId (i.e. providerUserKey).
Role Manager
------------
No known limitations.
Profile
-------
Marking Profile properties with "serializeAs=binary" will not work in partial trust web applications. Since
the sample provider does not assert any serialization permission (it can't since the sample provider is not
inside of System.Web.dll), the demand for serialization permission will fail in High trust or lower.
Web Parts Personalization
-------------------------
No known limitations.
BravoOsca
Member
15 Points
3 Posts
Re: Personal Starter Kit for MS Access
May 19, 2006 10:28 PM|LINK
Thx, for a great template.
I have a small problem, when i CTRL+F5 in Visual studio everything work, and i can login with my account i have made. But when i try on the webserver where i uploaded the same code, then i can't login? I can see that it should work, because if I choose a wrong password, it says that it was wrong, but when i choose the right one, I just get an empty page.
Any thing i need to do?
Regards Bo
remvalenzuel...
Member
15 Points
3 Posts
Re: Personal Starter Kit for MS Access
May 27, 2006 05:30 PM|LINK
Hey all,
I'm a newbie to this ASP.NET stuff. Want to learn and have downloaded Victor's version of the starter site using VB and Access. I seem to have two issues (be gentle, I'm a newbie) BTW, both of these worked when I had the original version of the asp.net starter site.
First, after installing the site, I click CTRL - F5 and get this error:
Unknown
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Unknown
Source Error:
Secondly, I cannot set up an administrator account for the site. I go to "website" -> ASP.NET Configuration -> Security and I get this error message:
"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store."
If I then go to "Choose Data Store" and then to "Select a single provider for all site management data" it says "no providers created" how do I create it... is it talking about an ODBC driver?
Your help to my dumb question(s) is appreciated.
lairstream
Member
10 Points
2 Posts
Re: Personal Starter Kit for MS Access
Jun 07, 2006 04:17 AM|LINK
Dude this post saved my life today...Argh! It's so hard to work with SQLExpress on a development machine...I thought it was just gonna be a plug and play kind of thing...but it was hell =)
So thanks again for posting that.
Based on my usage of it it took a little tweaking to get it to run in my SurveyCenter application (for instance I had to modify the Application name table, and clear out the old entries. Then I had to fiddle with the Configuration Manager tool site for a bit...at first it didn't work but after a few restarts it worked...the rest was modifying web.config.
Then I uploaded and Whammo! It didn't work :)
Then I did some more surfing, and sacrificing to the gods...then finally I found out that you have to tell your host to give the database folder, and all databases in it read/write/modify permissions...
That did it...ok,
Thanks a billion...
lairstream
Member
10 Points
2 Posts
Re: Personal Starter Kit for MS Access
Jun 07, 2006 04:18 AM|LINK
victorcorey
Member
332 Points
104 Posts
Re: Personal Starter Kit for MS Access
Jun 07, 2006 01:40 PM|LINK
Hmmm...Not sure. I just uploaded the files to my host and everything worked.
Have you checked the rights for the database directory?
victorcorey
Member
332 Points
104 Posts
Re: Personal Starter Kit for MS Access
Jun 07, 2006 01:40 PM|LINK
Opps..This was a reply to Bravo
victorcorey
Member
332 Points
104 Posts
Re: Personal Starter Kit for MS Access
Jun 07, 2006 01:41 PM|LINK
Are you running this under 2.0?
remvalenzuel...
Member
15 Points
3 Posts
Re: Personal Starter Kit for MS Access
Jun 12, 2006 01:46 AM|LINK
Victor -
Not sure what was different, but I whiped the O/S and had to install all of this on another machine and now that I try it, it all works. Not sure what was different.
Thanks for the help though.
BravoOsca
Member
15 Points
3 Posts
Re: Personal Starter Kit for MS Access
Jun 16, 2006 09:27 AM|LINK
Got it working, i talked to the company that host my side, and they change the rights on the server, so now everything is working.
Again, thanx for a great job on this project.
Right now im trying to make a page that i can use as contol of members and roles.
Can i use the "AccessMembershipProvider.cs" and "AccessRoleProvider.cs" for this?
I have tryed ObjectDataSource, but i get an error, so i probaly did something wrong. But i have to use the "AccessMembershipProvider.cs" or am i wrong?
Regards BravoOsca
victorcorey
Member
332 Points
104 Posts
Re: Personal Starter Kit for MS Access
Jun 16, 2006 02:46 PM|LINK
Yes, you should be able to use the Access Providers. There are some limitations to the providers that are referenced in the readme. See below:
All providers
-------------
None of the providers support the "commandTimeout" attribute. The providers issue OleDb commands using
the default timeout for OleDbCommand(s) which is 30 seconds.
The providers all carry out read and write operations against the $safeprojectname$ database using the security
credentials associated with the current request. Unlike the built-in providers, the sample providers do
not suspend impersonation when client impersonation is in effect. This means one of the following
identities requires Read/Write access to the App_Data directory:
1. The worker process identity if no impersonation is used.
2. The application impersonation identity if <identity impersonate="true" user="userid" password="pwd" /> is used.
3. Each client identity if <identity impersonate="true" /> is used.
Parameter validation and syntax checking of parameters is current as of ASP.NET 2.0 Beta 1. As a result
the parameter validations used in Beta 2 and RTM providers will differ slightly from the validations
enforced by the $safeprojectname$ providers.
Membership
----------
Password strength requirements are not enforced in the CreateUser and ChangePassword methods. The settings are
read from configuration, but at are not used by the provider.
Account lockouts are not implemented in the provider. The UnlockUser method has no effect, and the provider
does not count bad password or bad password answer attempts.
The $safeprojectname$ provider does not support creating a new user with an explicit UserId (i.e. providerUserKey).
The $safeprojectname$ provider does not support retrieving a user based on UserId (i.e. providerUserKey).
Role Manager
------------
No known limitations.
Profile
-------
Marking Profile properties with "serializeAs=binary" will not work in partial trust web applications. Since
the sample provider does not assert any serialization permission (it can't since the sample provider is not
inside of System.Web.dll), the demand for serialization permission will fail in High trust or lower.
Web Parts Personalization
-------------------------
No known limitations.