What do I need to know about converting vbs to work in the kix world. I have the following script and can shell out and call it but what it I want to include it as kix code? Can this be done?
code:
Set oConnection = CreateObject("ADODB.Connection")
If WScript.Arguments.Count <> 4 Then
WScript.Echo "Usage: Change.vbs <Server> <SQLLogin> <OldPassword> <NewPassword>"
WScript.Quit 1
End If
oConnection.Open "Provider=SQLOLEDB" & _
";Server=" & WScript.Arguments(0) & _
";User ID=" & WScript.Arguments(1) & _
";Password=" & WScript.Arguments(2)
oConnection.Execute "EXEC sp_password '" & _
WScript.Arguments(2) & "', '" & _
WScript.Arguments(3) & "', '" & _
WScript.Arguments(1) & "'"
For Each oError In oConnection.Errors
strMessage = strMessage & oError.Description & vbCrLf
Next
WScript.Echo strMessage
oConnection.Close
WScript.Quit 0
Thanks
_________________________
Austin Henderson