Home Network - Wired connection unable to connect to computer name

"Quite possibly your computer is confused about which interface to use when both wired and wireless are active. You've found the workaround -- disabling wireless when wired is active -- but here's a proper fix.

TCP/IP has an ""interface metric"" available in the Advanced protocol settings for each interface. Given two network adapters on the same network, Windows uses this interface metric to decide which one to use. The adapter with the lowest metric gets used first. So to fix this, assign a higher metric to your wireless adapter.

Open Network Connections.
Select your wireless connection, right-click, and open the Properties.
In the Protocols listed, select Internet Protocol (TCP/IP) and click the Properties button.
Click the Advanced button.
You should now have the Advanced TCP/IP Settings window open, on the ""IP Settings"" tab. Uncheck ""Automatic metric"", and add a number (like ""25"" or ""30"") into that box. Click OK.

Now do the same for your wired interface, and set it's metric to a lower number (like ""15"" or ""20"").

Here's an article with more detail on XP's automatic metric."