I'm hoping that this is in the right forum, but this is a bit of a weird question, I think.
I've got an asp .net website with a working membership system, using the sqlMembership provider. This is working properly without a hitch, but I am working on changing the system so that user membership information can be updated from an iSeries. This basically leaves me using Java and JDBC to call stored procedures to manage user data. This seems to work fine, in a general sense. I can modify data for existing users, and everything is hunky-dorey. The problem is that creating new users is a bit strange. It does work, and I can see the users on teh SQL server when I run the aspnet_Membership_GetAllUsers stored procedure, but I can not get users created this way to validate and log in to the website. I'm thinking the problem is in the way I'm calling the aspnet_Membership_CreateUser stored procedure. I've included what believe to be the relevant code below. I'm guessing the problem is related to the password salt and the password format.
I do understand that this stuff is technically supposed to be more back-end and not ran directly, but since writing C# on the iSeries is not an option, this is what I'm left with. It seems like it should work, and in fact, nearly does.
Thanks in advance for any assistance,
Daniel
<membership defaultProvider="myProvider">
<providers>
<add name="myProvider"
type="System.Web.Security.SqlMembershipProvider"
connectionStringName="myConnectionString"
applicationName="myApplication"
minRequiredPasswordLength="8"
minRequiredNonalphanumericCharacters="0"
requiresQuestionAndAnswer="false"
enablePasswordReset="false" />
</providers>
DECLARE @currentDateTime datetime;
DECLARE @results int;
SET @currentDateTime = GetDate();
EXEC @results = membershipDB.[dbo].[aspnet_Membership_CreateUser]
@ApplicationName = N'myApplication', @UserName = @parmUserName,
@Password = @parmPassword, @PasswordSalt = '',
@Email = @parmEmail, @PasswordQuestion = NULL,
@PasswordAnswer = NULL, @IsApproved = 1,
@CurrentTimeUtc = @currentDateTime,
@CreateDate = @currentDateTime,
@UniqueEmail = 1, @PasswordFormat = 1, @UserId = @UserId OUTPUT