Setting up the Zoom 4501 3G Router with an o2 Huawei E173 Dongle

I recently worked on a project required network access where no Network Connection was available on site.

I opted for the Zoom 4501 3G router…

http://www.zoomtel.com/products/4501.html

I paired this with an O2 Huawei E173 Dongle, using a 2GB allowance Pay as you go SIM.

http://www.o2.co.uk/broadband/mobile-broadband/o2-dongle

The Zoom 4501 supports a wide range of Mobile Broadband Dongles, including the O2 E173 I chose;

http://www.zoomtel.com/products/4501-4506_device-comp.html

For some reason, my Dongle and Router wouldn’t automatically setup, so I needed to discover the correct settings.

After some trial and error, and referring to the PC Huawei Connection Manager, I was able to find some settings which worked;

APN: m-bb.o2.co.uk
PIN Code: Leave Empty
Dialed Number: *99#
Username: o2bb
Password: password
Authentication: Auto
Primary DNS: 193.113.200.200
Secondary DNS: 193.113.200.201

Step by Step Instructions:

Setting the router up with the above settings can be achieved as follows;

1. Connect the Router to the mains using the Supplied PSU
2. Connect the Router to your network socket using the supplied Network Cable
3. Connect the Dongle to the Routers’ USB Socket which is found on the rear of the Router between the “POWER” and “LAN” Sockets
4. Once the Router has powered up, open your browser and head for
   http://192.168.1.1
5. At this point  will be shown one of two screens, depending upon whether your Router has automatically setup the Dongle or not. It’s worthwhile waiting for at least 30secs to a minute at this screen, as it takes the router a little while to set the Dongle up if it’s going to.
   
   Figure 1: Router Attempting / Failed to Setup Dongle:
   
   
   
   Figure 2: Dongle Setup successfully;
   
   
6. If you see the screen as shown in Figure 2, then everything has been setup automatically, and you should be able to browse the internet!
   
   However, If the screen continues to show Connecting, as shown in Figure 1, for over a minute, it’s safe to assume that the Router has given up and we need to manually configure the Router.
   
7. Where the Interface is prompting for the System Password, enter “admin” and hit the “Logon” button
8. You will be presented with the choice to either use the “Wizard”, or go with an “Advanced Setup”;
   
   Figure 3: Wizard / Advanced Setup Choice
   
   
9. We will be using the “Wizard” option, so you can simply press the “Enter” button to continue
10. The Wizard will give you a run down of the Steps which will be taken to set the Router up;
    
    Figure 4: Wizard Steps
    
    
11. Hit next to proceed to the Password Setup step. Here you can feel free to setup your own admin password, or simply leave it all blank to stick with the default “admin” password;
    
    Figure 5: Password Setup
    
    
12. Once your happy, hit next to move onto the Time Setup step. Select your timezone and press next;
    
    Figure 6: Time Zone Setup
    
    
13. Once again, press Next to move onto the WAN Setup. For the purpose I purchased the router and Dongle for, I will be using the last option “You want to use your cellular modem to connect to the internet”;
    
    Figure 7: WAN Setup
    
    
14. Pressing Next will now present you with the 3G/4G setup screen. This is where we will enter our settings to get the Dongle up and running. Enter the settings as follows;
    
    LAN IP Address: 192.168.1.1 (Should default to this)
    APN: m-bb.o2.co.uk
    PIN Code: Leave Empty
    Dialed Number: *99#
    Account: o2bb
    Password: password
    
    Your screen should now look like the following;
    
    Figure 8: 3G / 4G Setup
    
    
    
    Note: Where entering o2 Make sure you enter the letter ‘o’ rather than the number ‘0’.
    
15. Pressing Next will show the Wireless Settings step. Feel free to set your wireless network up anyway you wish. For the purposes of my requirements, I have disabled the Wireless Network;
    
    Figure 9: WIFI Setup
    
    
16. Pressing Next again will show the Summary screen. Here you can confirm that you have entered everything correctly. Once your happy, you should tick the “Do you want to proceed with the network testing?” and “The Ethernet Port will be used as LAN Port after saving. Confirm?” Checkboxes;
    
    Figure 10: Confirm Settings
    
    
17. Pressing next will cause begin a connection test. Here the modem is waiting for the Dongle to connect and for a connection to the internet to be available.
    
    Figure 11: Connection Test
    
    
18. If everything has worked you will be shown the following success screen;
    
    Figure 12: Connection Success
    
    
    
    However if the connection has failed, which happenned to me the first time, then you may see the Connection Failed Screen;
    
    Figure 13: Connection Failed
    
    
19. At this point you may need to enter some further settings which are hidden away in the Advanced Section of the Router. So, press the “Advanced” link in the menu bar towards the top of the screen to access the Advanced Settings screen;
    
    Figure 14: Advanced Settings
    
    
20. The Settings we need to modify / add can be found in the “Basic Setup” screen, which can be accessed using the Menu on the left of the screen;
    
    Figure 15: Basic Setup
    
    
21. Enter the settings exactly as below and press Save;
    
    APN: m-bb.o2.co.uk
    PIN Code: Leave Empty
    Dialed Number: *99#
    Username: o2bb
    Password: password
    Authentication: Auto
    Primary DNS: 193.113.200.200
    Secondary DNS: 193.113.200.201
    
22. You will now be prompted that the “change doesn’t take effect until router is rebooted”. So we must reset the router for the changes we made to take effect. To reset the router we must use the “Toolbox” screen, which can be accessed by pressing the last link on the right, shown near the top of the screen;
    
    Figure 16: ToolBox
    
    
23. Press the “Reboot” link in the menu on the left of the screen, and ok the message box to confirm. The router will now begin to reset;
    
    Figure 17: Rebooting
    
    
24. Once the reboot is complete after upto 30 seconds, and all being well, you should now be connected. This is obvious if you look at the LED on the 3G dongle, which should now be a steady Greenish Blue colour, rather than a slowly flashing blue;
    
    Figure 18: All Connected!
    
    
25. If for some reason you aren’t connected, then double check all the settings you entered above, and repeat the procedure.

Hopefully this proves useful to someone else out there!

Adding SQL Server 2008 R2 features to SQL Server Express

In order to add features from the full version of SQL Server 2008 R2 to the Express version.

Get a hold of the full version DVD or installation media, then use the following command from the command prompt;

setup.exe /FEATURES=Tools /Q  /INDICATEPROGRESS  /ACTION=Install /INSTANCENAME=UPSTAIRS\SQLEXPRESS /BROWSERSVCSTARTUPTYPE=Automatic /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"  /IACCEPTSQLSERVERLICENSETERMS

Visual Studio 2010 Source Control using Windows + Git + Git Extensions + DropBox

The following lays out a way to use Git + Git Extensions + Drop Box with an existing Visual Studio 2010 project. This will allow you to collaborate across multiple PC’s on the same project.

There may be quite a few steps, but it’s all quite simple stuff…

1. Install Git
2. Install Git Extensions
3. Install Drop Box
4. On the machine with the working Solution / project;
1. Browse to your DropBox folder using Windows Explorer
2. Create a directory to hold your Cloud Based Repo’s, for example /repos
3. Create a directory in your new repos directory to hold your Remote Cloud Based Project Repo, e.g. /repos/myproject/
4. Open a Git Gui
5. Click “Create a new repository”, and point it to the directory housing the local copy of your Solution / Project.
6. Click “Ok”, and let Git Gui create a repository within your Solution location
7. Create a .gitignore file in your favourite editor, and add the following sub directories (don’t forget that the directories are case sensitive, and will require a trailing forward slash)
1. The “/bin” directory for all projects
2. The “/obj” directory for all projects
3. Any other directories which you don’t require in your repository
8. Open your new repository in Git Gui
9. It should show all files ready to be staged and committed in the top left window.
10. Make sure this list contains all the files you’re expecting
11. Select all files and select “Stage to Commit” from the “Commit” menu
12. Add a commit comment such as “Origin”
13. Press Commit
14. Choose “Add” from the “Remote” menu
15. Choose a name for your remote repository. e.g. DropBox
16. In windows explorer copy the path to the remote repository contained in your DropBox folder at Step 2 above
17. In the “Further Action” section, choose “Initialize Remote Repository and Push”. This should then setup your Cloud Based Repository
    
5. On the Users’ machine who wishes to collaborate;
1. Create a directory to house the Solution / Project
2. Open Git Gui
3. Again create a repository at the location in Step 1
4. Again, add a Remote Repository in exactly the same way as in steps 13, 14, 15 and 16 above (NOT step 17!).
5. However, in the “Further Action” section, choose “Fetch Immediatly”
6. For some reason this doesn’t seem to actually go ahead and fetch all the project files, so flip back to windows explorer
7. Browse to the directory of your Solution / Project as created in Step 1
8. Right Click on the Directory and go to to Git Extensions –> Pull
9. In the “Pull From” section, and the “Remote” Drop Down, select the name of your Remote Cloud Based Repo. e.g. DropBox
10. In the “Branch” section, and the “Remote Branch”, select “master”
11. In the “Merge Options” section, make sure “Merge remote branch to current branch” is selected and that the “Auto stash” checkbox is clear
12. Hit “Pull”
13. You should now be able to see all your project files filled into your working directory

You can now;

• Make changes to the project,
• Stage and commit the changes
• Push the Changes to the Remote Cloud Based Repository
• Pull those changes on other machines
• Track changes between machines
• And much more