Is it possible to obtain the windows login?

sswingle · April 6th, 2006, 07:54 AM

I have a database with access and asp. We dont necesarily need a login for these pages, but there are a couple places where we would like to know who filled out a form automatically without them typing in their name and/or username.

Everyone has a unique windows username.
Is there a way for asp to see the users windows username?

Thanks

mat41 · April 6th, 2006, 06:59 PM

Yes. use server variables - Request.ServerVariables("LOGON_USER")

A full list:
http://www.w3schools.com/asp/coll_servervariables.asp

Wind is your friend
Matt

sswingle · April 6th, 2006, 10:51 PM

I tried that. It returns nothing.

sswingle · April 7th, 2006, 11:26 AM

Upon reading about the login user variable, that only applies if anonymous access is turned off, and users have to login to see the page. I DO have anonymous turned on, and I do not want to force users to login. I just want to be able to see their WINDOWS login. I dont even know if its possible or not, I cant find much when searching for it.

mat41 · April 9th, 2006, 07:15 PM

I have just reliaed we use a .ocx file for this, sorry...

Wind is your friend
Matt

sswingle · April 9th, 2006, 10:06 PM

What is an ocx?

mat41 · April 9th, 2006, 10:49 PM

An active X Control, usging JS - Some back ground:

1. Place this OCX (30kb) and the HTML file on the server. Codebase defines the path to the ocx so if they are not in the same directory then change accordingly
2. The OCX does NOT have to be registered on the server using regsvr32
3. Success in running OCXs (ActiveX objects) from within a browser will depend on the Browser security settings.

Then run the following page:

<HTML>
<HEAD>
<OBJECT Name="FindUser"
      classid="clsid:xxxxxxxxxxxxx-00FC-484C-ACE0-xxxxxxxxxxxxxxxx"
      codebase="xxxxxxxxxxxxxxxxxxxxx.ocx#version=1,0,0, 0"
>
</OBJECT>
</HEAD>
<BODY>
<H1> ActiveX Test Page </H1><p>
<p>
  <span id="user">Logged on user: </span>
</p>
<form>
  <input type="hidden" id="formVar">
</form>
<SCRIPT language="JavaScript">
  document.all.user.innerHTML = 'Logged on user: ' + FindUser.UserLogon();
  document.all.formVar.value = FindUser.UserLogon();
</script>
</BODY>
</HTML>

Works like a charm however is our propriety software.

Sorry that doesnt help you however it gives you an idea of how I do it

Wind is your friend
Matt

drminge · April 24th, 2006, 10:19 AM

Matt, your solution is exactly what I am looking for. Please excuse my lack of knowledge in this area. Is the code you posted all that is needed to obtain the logged in User Id? Or is there a separate OCX file that is needed to make this work? Thank you....

mat41 · April 24th, 2006, 10:01 PM

;;;Or is there a separate OCX file that is needed to make this work?

Yes there is. As I said above this is propriety software, it would not be ethical of me to give it away.

Wind is your friend
Matt