The only thing I could think of is if the homedir is null, causing some
problems. You could try modifying your VerifyFTPUser proc to wrap a
isnull around the homedir:
CREATE PROCEDURE VerifyFTPUser @username varchar(32) AS
DECLARE @globallimit INT
SELECT @globallimit = Value FROM Configs WHERE ConfigID = 60
Select AccountID,Login, Shell,
CASE WHEN (ma.OverLimit > 0 AND ma.OverLimit > ma.Balance) OR
DateAdd(Day, (ma.Extension+ma.OverDue+1), maExpireDate) < GetDate()
THEN RIGHT(CONVERT(VARCHAR(10),RAND()),4) +
RIGHT(CONVERT(VARCHAR(10),RAND()),4)
ELSE sa.Password END AS Password, ISNULL(HomeDir, 'noaccess') as
HomeDir, ISNULL(HomeDirLimit, @globallimit) AS HomeDirLimit
From MasterAccounts ma, SubAccounts sa
Where ma.CustomerID = sa.CustomerID
AND sa.CustomerID=ma.CustomerID
AND ma.Active=1
AND sa.Active=1
AND (Login = @username or Shell = @username or Email = @username)
GO
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart