Type A is the standard size HDMI port (TV) and Type D is the micro port (phone/tablet). So you would need a Type A male to Type D male which is the same thing as a standard HDMI to micro HDMI cable.
Here is an example:
That's actually a 10 foot cable. Standard is a 6 foot.
The issue is probably lack of HDCP support. Not all DVI ports fully support HDCP, and i'd suspect that with your TV this is the case. I believe the connection between the Xoom and the TV requires HDCP support.
Here's a little article explaining the issue:
DVI HDMI and HDCP - A Practical Guide
try taking a look at this.
If you have DVI instead of a VGA on your TV you can pick up a converter just about anywhere! They are easy to find
AnPu HDMI to VGA and 3 RCA Audio Video AV Adapter Cable 5ft - DinoDirect.com