if strAuthType ="nt" THEN NTGroupSTR = Split(Session(strCookieURL & "strNTGroupsSTR"), ", ") for j = 0 to ubound(NTGroupSTR) 130 --> NTGroupDBSTR = Split(fFPasswordNew, ", ") for i = 0 to ubound(NTGroupDBSTR) if NTGroupDBSTR(i) = NTGroupSTR(j) then chkDisplayForum = true exit function end if next next end if
Any ideas, as far as I know no changes have been made in IIS. One user has recently changed her Network Password the Other has not. Site works fine for myself and the other administrator.
There were some differences in data type definitions but I suspect that is due to the allowed data types in MySQL. I found many occurances where no default was set and the allow null was turned on when it should not have been. BTW This DB was a clean install for MSsql using the tools provided with snitz.
I have auto login, NT Authentication and NT groups turned on. While editing some of the forum properties I had deleted the space in the text box for "Password or Global Groups", This appears to have created or allowed the Null in the fFPasswordNew field.
The pisser here is that I could not find what was causing the problem until I had the solutiuon to the problem.
Be warned.. The single space in the forum properties text boxes are not just there because of how IE renders the form.