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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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.. -
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... -
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 =... -
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 =... -
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 =... -
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... -
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... -
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? -
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")... -
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... -
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... -
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 -
Overwrite textfile
simple... but still, out of my lead.. Thanks tsuji! -
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... -
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 =... -
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... -
Display message, msgBox...
I followed your link PHV and it solved my problem. Thanks! -
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 -
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... -
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...
