If at all possible, use different IP subnets for each network (e.g. 192.168.0.0 for one and 192.168.1.0 for the other). If assigning a static IP on your Wi-Fi interface is acceptable, do that. Do not specify a default gateway. If you don't want to assign a static IP, give the Wi-Fi interface a higher metric value than your Ethernet interface. Interfaces with lower metric values are preferred over higher ones for routing. Same applies to IPv6 if both networks provide IPv6 connectivity. Regarding the diagram... pretty sure you don't actually connect to two separate Internets (globes).
I still havn't worked out the purpose of the second connection (the Ethernet one) as he says the Win7 PC does not need internet, so he's connecting to a router/modem and which is doing nothing?
I'm interpreting it as "Win7 machine needs access to DVR (CCTV system) [on the Wi-Fi network] only, I'd prefer not having Internet access [over Wi-Fi] due to slow connection."
hes using some really underground net ? (ethernet cable 200m to next building ? ) he has to change the bottom one non dvr dhcp range from 192.168.1.1 to 0.1 so the current port forwarding on the dvr is not altered.
For the record, this config. is not mine. My customer decided to purchase a separate Internet service for his own private office within the whole/general office. Why? I don't know. And I don't care. Then he decided to connect his new DVR and CCTV system to that modem/router, BUT now he wants his assistant to access the cameras too via HikVision iVMS-4200 utility to keep an eye on everywhere L0L.
Since they're both using the same subnet addresses it's possible that one interface is offered a DHCP address that the other interface is already using, and that's going to be a problem. Change one network to use different subnet addresses if you can and you'll save yourself a lot of trouble.
That's exactly what I pointed out. But then with 2 networks, only one should have a default gateway, essentially ... anything not on this LAN -> sent to GW. There is nothing wrong with having multiple internet connections, but the network design needs a serious rethink.
So I leave ethernet network alone, cause I want Internet access on this one. Wireless network needs to be reconfigured to static IP, different subnet and no gateway assigned, as I need access to DVR only. Questions (first time I do something like this): This reconfiguration is done in the Win7 machine only, correct? Do I have to do anything on the router side? How to not set a default gateway?
best is backwards. the internet modem ethernet on the router change the routers ip from 192.168.1.1 to 0.1 done. so it doesnt have same ip 192.168.1.1 on both routers. now if you browse to the dvr 192.168.1.x it wont go thru the 192.168.0.1 router on ethernet and then set static ip on the wifi with no gateway.
Changing the subnet affects all hosts on the network, so it has to be done for the router, as well as any other statically configured hosts on the network. For DHCP clients, renewing the IP will suffice. Make sure you don't assign all available addresses to the DHCP pool (e.g. 192.168.1.20-254) and set any static IPs outside of that so that the DHCP server doesn't give out one of those to other hosts. You just leave it blank. Properly configured, "netstat -rn" will then show only one route for "0.0.0.0", and it should point to the router (gateway) that you want to use for Internet access. If IPv6 connectivity is available, it should also show one route for "::/0".