Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DougHK

    Login Script not inserting data into DB

    I sort of see your point, but the second half on the script does an update (Section "Writing login information to the database). The way I envisioned this, there are two tables, one caintains the UserID and Full name, the second contains all the other login information, preceeded by the...
  2. DougHK

    Login Script not inserting data into DB

    I think I found my problem, and tsuji pointed me in the right direction. Although I did not get an error, I think my first loop was causing my problem. So instead of using a While / Wend, I changed the statement to an If / End If. The function now looks like this. Function...
  3. DougHK

    Login Script not inserting data into DB

    Thanks tsuji and PHV for your input. Tsuji, I will be very happy to test, but my issue, why does it work in test, that is I run it from a DOS prompt with cscript logon.vbs, and the script runs as I expect it would run. Writes the data I gather into the database. But when I run it from the...
  4. DougHK

    Login Script not inserting data into DB

    I apologize for the confusion. I was doing some testing, and wrote the procedure to write to the database not as a function, but part of the previous section. I have changed it back using the Function call. The script works fine if I run it when either from cscript ot wscript, fully logged...
  5. DougHK

    Login Script not inserting data into DB

    Below is the full script. I have MsgBox in there for debug purposes. For the script to run, the user must log into the Domain and be authenticated before the the login script is run. Meaning the domain is aware of the user and the authentication level of the user. option explicit Dim...
  6. DougHK

    Login Script not inserting data into DB

    Good point. I'll try it and see what happens. And no you are not rubbing me the wrong way. I appreciate your help. Doug
  7. DougHK

    Login Script not inserting data into DB

    At this point I am only using Microsoft Access till I know it works. When I move the DB to different locations I make sure I have sufficient privilages to the share / directory and database. I am a member of the Domain Admins group. When I am sure the script works, I will migrate the database...
  8. DougHK

    Login Script not inserting data into DB

    David, That is a thought I also had, so what I did; - put the database on the C: drive and coded the Provider to the directory. - Setup the database on a server and configured ODBC with a DNS with a UNC path. - Mapped a drive to the database on the server at the beginning of the script and then...
  9. DougHK

    Login Script not inserting data into DB

    I have written a login script to gather information about the user and PC. It uses WMI and ADSI to get PC model Number, Serial Number, Memory, Operating system, Service Pack, User Login name, Full name, etc, and then writes it out to a database. This works great when running from cscript or...

Part and Inventory Search

Back
Top