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 Chris Miller 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: *

  • Users: slint
  • Order by date
  1. slint

    Running .bat files within .bat file

    Why dont you do like this.. A third bat file named batch3.bat start /min \\computername\searchstring\batch1.bat start /min \\computername\searchstring\batch2.bat You colud insted of /min use /max or /wait etx..
  2. slint

    Get uniqe ID to use in next table

    PHV you are entitled to do a typo! i'm the jackass that dosent se the typo. Once again thank you wery much! I have come this far with my script. The script run great it inserts values if the computername isnt there and it updates if it is. Super! A also added the same type of command for...
  3. slint

    Get uniqe ID to use in next table

    Now when i am running the script it updates the values, greate. But it dosent insert new values. The error i get is: Incorrect syntax near 'MyComputername' And the script stops at objconn.Execute strsql 'On Error Resume Next Set oShell = CreateObject("wscript.Shell") Set env =...
  4. slint

    Get uniqe ID to use in next table

    You mean something like this... The script dosent give me any errors but there is no data writen to the database. 'On Error Resume Next Set oShell = CreateObject("wscript.Shell") Set env = oShell.environment("Process") Set objNetwork = CreateObject("WScript.Network") strComputer =...
  5. slint

    Get uniqe ID to use in next table

    I have tryed to do it by learning and i have come up with this... i'm i on the right track.. any suggestions.. 'On Error Resume Next Set oShell = CreateObject("wscript.Shell") Set env = oShell.environment("Process") Set objNetwork = CreateObject("WScript.Network") strComputer =...
  6. slint

    Get uniqe ID to use in next table

    Super PHV! But.. there is always a but.. How do i update values in table inventTB and inventNIC rather then inserting new if i run the script two, tree or even more times. I dont want a new row in inventTB or inventNIC everytime i am running the script just updating the values when...
  7. slint

    Get uniqe ID to use in next table

    db consist of two tables, one table named inventTB, containing columns corresponding to the first objRS command. It also contain a primary key, compID (datatype = int). The second table is named inventNIC and containes columns corresponding to the second objRS command. It also contains a column...
  8. slint

    Get uniqe ID to use in next table

    I tryed your suggestion but i'm getting an error on line 76: error: Invalid column name 'My computername' code: 80040E14 Any ide?
  9. slint

    Get uniqe ID to use in next table

    I'm trying to get the hold of the uniqe IDnr compID from table inventTB to insert in the table inventNIC but i cant seam to get it right. Can anyone point me in the right direction... 'On Error Resume Next Set oShell = CreateObject("wscript.Shell") Set env = oShell.environment("Process")...
  10. slint

    Either BOF or EOF is True

    Thanks tsuji and dm4ever for all your valual posts.. The script is a cut and paste script so all tweaks you know of is valuable. My next problem is: ... I am running the script on my local pc that have 4 nic (1 cable nic, 1 wireless, 2 vmware nic) all the interfaces are inserted in to the...
  11. slint

    Either BOF or EOF is True

    I keep getting the Either BOF or EOF is True error on line 74 in the script. Background: i have a script that runs when loging in to the domain, the scripts runs an inventory of the computer with wmi. And i want these data from the wmi query to be added to a sql database. The first part in the...
  12. slint

    Get Mac and IP address from 98 client

    i found that the script didnt get the computername right for win 98 machines. So insted of this: strComputer = env.Item("Computername") i used this: Set objNetwork = CreateObject("WScript.Network") strComputer = objNetwork.ComputerName
  13. slint

    Overwrite textfile

    simple... but still, out of my lead.. Thanks tsuji!
  14. slint

    Get Mac and IP address from 98 client

    I have installed Windows Management Instrumentation (WMI) CORE 1.5 for 9x and can, with the script, get info about installed applications but not any info about ip address or mac addresses. I have used WMI Explorer to see the info from there and all the things i'm looking for is there with the...
  15. slint

    Get Mac and IP address from 98 client

    I have been trying with wmi and it works fine on win2k and xp but i suspect that wmi isent something that you can query in win 98. So how do you get the info from a win 98 machine. Set colAdapters = objWMIService.ExecQuery("SELECT * FROM Win32_NetworkAdapterConfiguration WHERE IPEnabled =...
  16. slint

    Overwrite textfile

    How can i overwrite a txt file if it exist and create the txt file if it dosent exist, i have tried the code below but with no luck. Set fso = CreateObject("Scripting.FileSystemObject") Set objFSO = CreateObject("Scripting.FileSystemObject") If objFSO.FolderExists("C:\Data\SCRIPTS\") Then...
  17. slint

    Display message, msgBox...

    I followed your link PHV and it solved my problem. Thanks!
  18. slint

    Display message, msgBox...

    How do i display a message, like the msgBox, that closes after 10 sec if thers no user interaction so that the rest of the script is processed. A vb/batch combo that maybe explain my needs Call MsgBox ("Hello world!") -timeout /T 10
  19. slint

    Copy file from cd to local folder

    humm, found a solution to the prob... Dim strAstart Const ALL_USERS_STARTUP = &H18& Set objShell = CreateObject("Shell.Application") Set objFolder = objShell.Namespace(ALL_USERS_STARTUP) Set objFolderItem = objFolder.Self strAstart = objFolderItem.Path Const OverwriteExisting = TRUE Set...
  20. slint

    Copy file from cd to local folder

    by the way, i'm getting "Can't find the path specified" or "There is a dublicate name on the network, go to the control panel and change your computer name" It's only one comp on my test network and there is no conflict...

Part and Inventory Search

Back
Top