Page 1 of 1
5.35.57 bug in Membership provinder
Posted: Tue 15 Dec 2009 09:22
The membership query:
Code: Select all
MembershipUserCollection users = prv.FindUsersByName(filter, 0, int.MaxValue, out count);
filter is username, and the sql is (from monitor)
Code: Select all
SELECT username, password, u.userid, email, passwordquestion, passwordanswer, comments, isapproved, islockedout, creationdate, lastlogindate, lastactivitydate, lastpasswordchangeddate, lastlockoutdate FROM aspnet_membership m, aspnet_users u WHERE u.userid = m.userid AND LOWER(u.applicationname) = :applicationname order by username AND LOWER(username) LIKE :username
Please fix it!
Posted: Thu 17 Dec 2009 11:34
We have put the ORDER BY clause in the right place and sent you the fixed Devart.Data.Oracle.Web.dll assembly by e-mail.
Posted: Mon 28 Dec 2009 11:25
Shalex wrote:We have put the ORDER BY clause in the right place and sent you the fixed Devart.Data.Oracle.Web.dll assembly by e-mail.
Sorry, today I check the assembly that you sent, and do as your guide, but the error in the web.config (before replace your assembly, no problem):
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Exception has been thrown by the target of an invocation.
Posted: Mon 28 Dec 2009 14:31
We had checked the assembly before sending it to you. It worked in our environment. Probably, something is wrong with your application settings:
1) please compare your web.config entry with the one from our sample (\Program Files\Devart\dotConnect\Oracle\Samples\Web\CS\WebProviders\web.config);
2) fill the applicationName attribute with the name of your application;
3) try to obtain a more detailed description of the problem.
If this doesn't help, please send us
a small test project. We will try to reproduce the issue in our environment.
Posted: Tue 29 Dec 2009 08:08
I've checked again, and it work. Thanks.