Webmaster Forum / ASP / Database Access / September 2007

Hello, would anyone tell me what's wrong with the following or if there's a
better way/practice in trying to get the current windows authenticated user
and seeing if it exists in a sql2k user table?:

     Dim conn, rsAdminCheck
     Set conn= CreateObject("ADODB.Connection")
     Set rsAdminCheck = CreateObject("ADODB.Recordset")
     conn.Open db
     Set rsAdminCheck= conn.Execute("exec uspAdminCheck '" &
Request.ServerVariables("AUTH_USER") & "'")
     If rsAdminCheck(0) = 1 Then  '1=Yes 0=No
       response.write "Yes, this user is an admin"
     Else
       response.write "No, this user is not an admin"
     End If

It gives me the following error:

Microsoft VBScript runtime (0x800A000D)
Type mismatch: '[string: "DomainName\TestUserName"]'

Thanks in advance.