Chewie71

Doh! That's probably it. I was running a slightly older version locally....and compiling with that one. I'm waiting for the Windows 8 user to test it out now that I've upgraded and recompiled. If that's NOT the problem I'll be back, but I'm figuring that will fix it. Thanks, Matt

I have a compiled AutoIT script that when run on Windows 8, does not work correctly. I tracked it down partly to the fact that @OSVersion returns the value UNKNOWN. If I run the AutoIT script prior to compiling it to EXE, It returns the correct value , "WIN_8". This script works fine, compiled or not, on Windows 7 and previous. What am I missing here? Thanks, Matt

Small update to the original code. We wanted to take advantage of the "ON DUPLICATE KEY UPDATE" feature... http://dev.mysql.com/doc/refman/5.1/en/ins...-duplicate.html So we modified the _AddRecord function (all the lines with the $update variable). Matt Func _AddRecord($oConnectionObj, $sTable, $vRow, $vValue = "") If IsObj($oConnectionObj) Then $query = "INSERT INTO " & $sTable & " (" If IsArray($vRow) Then For $i = 0 To UBound($vRow, 1) - 1 If $i > 0 And $i <> UBound($vRow, 1) - 1 Then $query = $query & "," & $vRow[$i] & "" ElseIf $i = UBound($vRow, 1) - 1 And $vRow[$i] <> "" Then $query = $query & "," & $vRow[$i] & ") VALUES(" ElseIf $i = 0 Then $query = $query & "" & $vRow[$i] & "" ElseIf $vRow[$i] = "" Then $query = $query & ") VALUES(" EndIf Next EndIf If Not IsArray($vRow) And Not IsArray($vValue) And Not IsInt($vValue) Then $oConnectionobj.execute ("INSERT INTO " & $sTable & " (" & $vRow & ") VALUES('" & $vValue & "')") return 1 ElseIf IsInt($vValue) And Not IsArray($vRow) And Not IsArray($vValue) Then $oconnectionobj.execute ("INSERT INTO " & $sTable & " (" & $vRow & ") VALUES(" & $vValue & ")") return 1 EndIf $update = " ON DUPLICATE KEY UPDATE" If IsArray($vValue) Then For $i = 0 To UBound($vValue, 1) - 1 If $i > 0 And $i <> UBound($vValue, 1) - 1 And Not IsInt($vValue[$i]) Then $query = $query & ",'" & $vValue[$i] & "'" $update = $update & "," & $vRow[$i] & "='" & $vValue[$i] & "'" ElseIf $i = UBound($vValue, 1) - 1 And $vValue[$i] <> "" And Not IsInt($vValue[$i]) Then $query = $query & ",'" & $vValue[$i] & "')" $update = $update & "," & $vRow[$i] & "='" & $vValue[$i] & "';" ElseIf $i = 0 And Not IsInt($vValue[$i]) Then $query = $query & "'" & $vValue[$i] & "'" $update = $update & " " & $vRow[$i] & "='" & $vValue[$i] & "'" ElseIf $vValue[$i] = "" Then $query = $query & ")" $update = $update & ";" ElseIf IsInt($vValue[$i]) And $vValue[$i] <> "" Then $query = $query & "," & $vValue[$i] $update = $update & "," $vRow[$i] & "=" & $vValue[$i] EndIf Next EndIf If StringRight($query, 1) <> ")" Then $query = $query & ")" EndIf $query = $query & $update $oconnectionobj.execute ($query) EndIf If Not IsObj($oConnectionObj) Then SetError(2) Return 0 EndIf If @error And IsObj($oConnectionObj) Then Return 0 SetError(1) Else Return 1 EndIf EndFunc ;==>_AddRecord

I have a script that does some logging. It has worked with Windows XP, but now we're doing some testing with Windows Vista and are getting "Invalid file handle used" errors on the first FileWriteLine. $filePClog = FileOpen(@logonserver & "\logs$\PC\" & @computername & ".log", 1) $fileUSERlog = FileOpen(@logonserver & "\logs$\USER\" & @UserName &".log",1) FileWriteLine($filePClog, "Log On :: " & @MON&"/"&@MDAY&"/"&@YEAR&" "&@HOUR&":"&@MIN&":"&@SEC & " :: " & @UserName) FileWriteLine($fileUSERlog, "Log On :: " & @MON&"/"&@MDAY&"/"&@YEAR&" "&@HOUR&":"&@MIN&":"&@SEC & " :: " & @ComputerName) FileClose($filePClog) FileClose($fileUSERlog) This script is called by another script (which does a RunAsSet so we can write to the log files...regular users don't have permissions to them), which is called from the logon script. Any ideas? Thanks, Matt

Oh duh...I forgot to put the & between my @CR and @LF. Thanks... :"> Matt

Is there a way to insert a blank line into a MsgBox? I tried using the @CR but got an error. Thanks, Matt

Got it...had to add '2' to the end of the RunAsSet line...then it worked. Don't have to map the drive either...straight UNC. Can you explain why it works with the '2'? Was it trying to find and use a local account called 'loggeruser' instead of the domain account? RunAsSet("loggeruser", @LogonDomain, "loggeruserpassword", 2) Thanks, Matt

Is there another way to do this? All I want to be able to do is write to a log file that the user doesn't have rights to. If there's an easier way I'm definately open to it. Thanks, Matt

Looks like I get the same error, and on the second line my "MsgBox" returns error 5. When I run it locally on my PC it seems to be working fine. Put it on the server and call it from the logon script though and I get the errors. Well, enough for tonight, I'll try again tomorrow...thanks. New LogonLOG.exe ************ DriveMapAdd("S:", @logonserver & "\logs$") MsgBox(0,"ERROR",@error) $filePClog = FileOpen("S:\PC\" & @computername & ".log", 1) $fileUSERlog = FileOpen("S:\USER\" & @UserName &".log",1) ;$filePClog = FileOpen(@logonserver & "\logs$\PC\" & @computername & ".log", 1) ;$fileUSERlog = FileOpen(@logonserver & "\logs$\USER\" & @UserName &".log",1) FileWriteLine($filePClog, "Log In :: " & @MON&"/"&@MDAY&"/"&@YEAR&" "&@HOUR&":"&@MIN&":"&@SEC & " :: " & @UserName) FileWriteLine($fileUSERlog, "Log In :: " & @MON&"/"&@MDAY&"/"&@YEAR&" "&@HOUR&":"&@MIN&":"&@SEC & " :: " & @ComputerName) FileClose($filePClog) FileClose($fileUSERlog) DriveMapDel("S:")

Here's the actual error I get, but I don't know if it will help... Line 0 (File "\\servername\netlogon\vbsfiles\LogonLog.exe"): FileWriteLine($filePClog, "Log In :: " & @MON&"/"&@MDAY&"/"&@YEAR&" "&@HOUR&":"&@MIN&":"&@SEC & " :: " & @UserName) Error: Invalid file handle used.

Nope...checked that already. If I MsgBox out that Run line it comes out with the \\ already in front. Just to be sure I edited in the "\\"& like you show and ended up with \\\\logonserver\etc... Thanks though... Matt

Hiya, I've written a couple scripts with AutoIT. The first is a logger script(LogonLOG.exe) that appends some data onto a log file on the server. The log files cannot be read or written to by normal users...so...I created a logger user with permissions to the log file and wrote a second AutoIT script (called from a VB logon script) that does a RunAsSet on the first logger script. Both scripts are compiled into EXEs. Does not seem to work though. Any suggestions??? Should I be doing this another way? LogonLOG.exe Script ***** $filePClog = FileOpen(@logonserver & "\logs$\PC\" & @computername & ".log", 1) $fileUSERlog = FileOpen(@logonserver & "\logs$\USER\" & @UserName &".log",1) FileWriteLine($filePClog, "Log In :: " & @MON&"/"&@MDAY&"/"&@YEAR&" "&@HOUR&":"&@MIN&":"&@SEC & " :: " & @UserName) FileWriteLine($fileUSERlog, "Log In :: " & @MON&"/"&@MDAY&"/"&@YEAR&" "&@HOUR&":"&@MIN&":"&@SEC & " :: " & @ComputerName) FileClose($filePClog) FileClose($fileUSERlog) RunLoggers.exe Script ***** ; Set the RunAs parameters to use logger account RunAsSet("loggeruser", @LogonDomain, "loggeruserpassword") If $CmdLine[1] = "LOGON" Then Run(@logonserver & "\NETLOGON\VBSFiles\LogonLOG.exe") ElseIf $CmdLine[1] = "LOGOFF" Then Run(@logonserver & "\NETLOGON\VBSFiles\LogoffLOG.exe") EndIf ; Reset user's permissions RunAsSet()