That Siemens Speedstream 4100 Ethernet ADSL Modem is really a modem/router combo. Click on
http://www.whatismyip.com/ and you will see your public IP address--the one that your ISP assigns to you. It will not be 192.168.anything.
Using the hub as you do you should be able to successfully connect both computers to the internet at the same time either by setting both to 'obtain IP auto' and 'obtain DNS auto' or else using static IP addresses (192.168.0.2 and 192.168.0.3 with mask 255.255.255.0 and Gateway and DNS 192.168.0.1.
If these do not work, and if I read your post correctly you've already tried, there is probably something wrong with the Speedstream. Can you login it to it by entering 192.168.0.1 in your browser address window? If so, what can you learn about the settings, and can you change them? Did the unit come preconfigured?
Please post an ipconfig /all for each computer when they are both connected (or trying to connect). If we can't spot anything wrong in them, you'll probably need to contact your ISP to find out what's going on.