The Software answer is parially correct.
You have to select "Cable" as the input with your set-up software. IF "Antenna" selected, you have an impedance mismatch that will cause a good deal of heat in the cable. There is a possibility that the card isn't burnt, though.
Remove and replace the bad cable
Start the "TV" program.
Enter the set up (ctrl-S or right click, set-up with ATI)
Select the Tuner Tab, Then you should have a selection for Cable Standard (select which country you are in)
Then select Cable,
IF Cable was already selected and not Antenna, Then the burnt Coax was probably shorted from a manufacturing defect, Crimping defect (if the Cable Installer made one on the spot) or from the center conductor shorting against the shielding (From not making sure that it went in to center hole properly, therefore bending and smashing it).
Probably the software, though. Hope you get it working. It's cool to watch TV while you're using Internet explorer.