The XPR USB cable will work on XTL radios. I have never tried the other way as you describe. However, make sure you are selecting the proper COM PORT in the software. Generally a db9 will be COM 1 and the USB will be something > COM 4.
Aside from that, what is the error message you are getting? What version of software?
Connecticut Database Administrator