Multiple network connections on Windows 7
Revised, as I did not understand your question totally at first: The reason is probably because of the metric I describe below, but in your case, you want to give preference to the wireless network. You will set it's metric to 1, and the LAN to 2, and move the wireless to the top of the binding order.
You should post your IPCONFIG/ALL as you have not posted enough information to help you with that part of the question, but you want to make sure that your IP addresses, subnet masks, and gateways are all correct.
To answer the second half of your question:
TCP/IP "SHOULD" automatically detemine that the wired connection is the fastest, but I have seen times where it does not do this correctly, especially if if gets plugged in after, and you already have a wireless connection, which is connected and active.
If you want to guarantee that the wired network gets preference, do the following:
Go into your Connection>Properties for both TCP/IPv4 and TCP/IPv6 (if in use)set the metric for your LAN connection to 2, and your Wireless to 1 (for most people, they would want these reversed). In the screenshot you can see where I set this for my wireless adapter. If you hit F1 right there, you can see this quote from the help file:
Automatic metric specifies whether TCP/IP automatically calculates a value for an interface metric that is based on the speed of the interface. The highest-speed interface has the lowest interface metric value.
Interface metric provides a location for you to type a value for the interface metric for this network connection. A lower value for the interface metric indicates a higher priority for use of this interface.
Then you can also change your binding order by opening Control Panel>Network and Internet>Network Connections>Advanced>Advanced Settings
as in this screenshot:
From my reading of this question, I think the accepted answer is wrong. The issue is that Windows 7 (and possibly other versions) only recognizes a connection without a gateway as an "Undentified Network" and labels it as a Public Network, which is why you can't share the printer. There is a snapin for the MMC that lets you get around this. See http://blog.kazmarek.com/2010/2/25/change-default-behavior-for-unidentified-network-in-vistawindows-server-2008windows-7/ NOTE that Windows 7 Home doesn't have this snapin! (Though an unsupported installer is out there.)
Setting the wired non-internet connection to a private network this way should allow the printer to be shared.