Javascript check if the Windows user is registered in MS Access Database

Question

The need is to check if the Windows user is registered in the Ms Access database (network database), but is not working as it should. I think the problem is in the strUserName variable inside select.

I’ve tried several ways but still haven’t found the solution!

Someone knows how I fix it?

< html > < body >


  <!-- PEGA USUARIO LOGADO NO WINDOWS -->

< script type = "text/javascript" >
var objNet = new ActiveXObject("WScript.NetWork");
var strUserName = objNet.UserName;
var strDomain = objNet.UserDomain;


document.write("Usuário: ", strUserName);



function abreRelJC() {

  var adoConn = new ActiveXObject("ADODB.Connection");
  var adoRS = new ActiveXObject("ADODB.Recordset");

  adoConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='P:\\PCP\\GERENCIAL\\System\\GERENCIAL_be.mdb'");
  adoRS.Open("Select * From CadastroUser WHERE UsuarioRelatorioGerencial = strUserName", adoConn, 1, 3);

  var Userbanco = adoRS.fields("UsuarioRelatorioGerencial").value;



  if (Userbanco == strUserName) {

    document.write("Ok! usuário cadastrado");

    adoRS.Close();
    adoConn.Close();
  } else {

    document.write("Usuário pendente de cadastro!");

    adoRS.Close();
    adoConn.Close();
  }

}


< /script>


<br / > < br / >


< input type = "button"
onclick = "abreRelJC()"
value = "Testa usuáro"
style = "font-size:20px; color:SlateGray" / >


  < /body>< /html>

Answer 1

Have you tried:

adoRS.Open("Select * From CadastroUser WHERE UsuarioRelatorioGerencial = " + strUserName, adoConn, 1, 3, 1);

?

Similarly on Document.write:

document.write("Usuário: " +  strUserName);

If the network console or javascript returns an error, please post it

Correction: To try adoRS.Open("Select * From Cadastrouser WHERE Usuariorelatoriogerencial = " + strUserName, adoConn, 1, 3, 1);