Editing Network Adapters using VBScript

Posted on 2008-10-28
Last Modified: 2013-11-10
I am fairly new to vbs.  I am trying to write a script for my servers, so that I can edit thier network adapter easier on builds and rebuilds.  I have pieced together the following script from snippets on the web, and edited it so that I would prompt for input instead of statically assigning the variables, however it now gives me a type mismatch on line 26...Any ideas?  Also I would like to modify it so that it edits and prompts for the primary and secondary dns.

strConnection = "Local Area Connection"
strComputer = InputBox( "What is the name of the Server?" ) 
strIP = InputBox( "What is the new IP?:" )
strMask = InputBox( "What is the Subnet Mask for this IP?" )
strGatewayIP = InputBox( "What is the default gateway?" )
MsgBox("You entered Server" & " " & strComputer & " "  & "and the IP" & " " & strIP)
set objWMI = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
set colNA = objWMI.ExecQuery("select * " & _
                            " from Win32_NetworkAdapter " & _
                            " where NetConnectionID = '" & strConnection & "'" ) 
for each objNA in colNA
   set colNAConfig = objWMI.ExecQuery _
      ("ASSOCIATORS OF {Win32_NetworkAdapter.DeviceID='" & _
        objNA.DeviceID & "'} " & _
      " WHERE resultClass = win32_NetworkAdapterConfiguration ")
   for each objNAConfig in colNAConfig
      intRC = objNAConfig.EnableStatic(strIP,strMask)
      intRC2 = objNAConfig.SetGateways(strGatewayIP)
      if intRC = 0 and intRC2 = 0 then
         WScript.Echo "IP address configured for " & strConnection
      elseif intRC = 1 or intRC2 = 1 then
         WScript.Echo "You must reboot for the changes to take effect for " & _
         WScript.Echo "There was an error configuring IP for " & _
                      strconnection & ": " & intRC & " and " & intRC2
      end if

Open in new window

Question by:corphealth
  • 4
  • 4

Author Comment

ID: 22823332
make that line 18 =)

Expert Comment

ID: 22829062
This script is just working fine for me. At least no errors a line 18
What version of server are you running ?

Author Comment

ID: 22832740
i changed the script now im getting the error in the screen shot below... Are you saying you used this script and it actually changed the network details for the selected box?

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 22832754
Im running it from an XP machine

Expert Comment

ID: 22833843
Usually a type mismatch is because your are trying to input or test a using a string or another type against an int or something to that effect. Are you sure you don't have to parse out the ip address or something so that it is an int and not a string? I will look more closely when I get a chance, but try looking over your code to make sure that everything should be a string against string check/enter. If that's not it, maybe look at your strings and check into the escape characters for your "path\path\". sometimes you have to add an extra escape character so that it reads the path line properly, and that can cause issues as well. I will look at your code closer when I get off work and can check it out.

Expert Comment

ID: 22833900
Sorry, I also noticed on your line 26. You are trying to make an int variable = to your enable static with string input params. Are you at any point changing the input to int type? Maybe try accepting the ip addy as an int instead and just parse or convert the input coming in from the input box from string to int.

Expert Comment

ID: 22833986
One last thing for now. I also noticed that you are inside your foreach statement while doing some of this. I think that inside there, and much as your code says with the objNAconfig..etc, you are dealing with objects and trying to assign and object to an int. I know, at least in some cases, you have to parse or convert the object from an object type to an int if you are trying to assign it to an int variable. Again, i'll check back later. Sorry for all the posts. I'll stop now for awhile. Hope all this helps.

Accepted Solution

corphealth earned 0 total points
ID: 22834543
changed lines 26 and 27 to the below and it now works.

intRC = objNAConfig.EnableStatic(Array(strIP), Array(strMask))   
      intRC2 = objNAConfig.SetGateways(Array(strGatewayIP))

Open in new window


Expert Comment

ID: 22834701
So it was looking for a collection.. that explains it. Nice work. Congrats :)

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn different types of Android Layout and some basics of an Android App.
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question