Three of my Snitz-running sites are experiencing the same error which is:
Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'my_Conn.Execute'
/portal/inc_func_common.asp, line 1176
The code in that part of inc_func_common.asp is
'##############################################
'## Private Forums ##
'##############################################
function chkUser(fName, fPassword, fAuthor)
dim rsCheck
dim strSql
'## Forum_SQL
strSql = "SELECT MEMBER_ID, M_LEVEL, M_NAME, M_PASSWORD "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(fName, "SQLString") & "' "
if strAuthType="db" then
strSql = strSql & " AND M_PASSWORD = '" & ChkString(fPassword, "SQLString") &"'"
End If
strSql = strSql & " AND M_STATUS = " & 1
Set rsCheck = my_Conn.Execute(strSql)
Line 1176 is the last line above.
My host says theres something wrong with the code, but I can't believe that as another of my Snitz running sites (also hosted with them) is working perfectly and, in fact, uses the exact same code as one of the problem sites (that is, the same MODs, etc.)
Anyone have any ideas that I can go back to my host with? Thanks.
Topic Locked
Posted - 16 June 2004 : 10:12:32
