I've heard repeatedly that the Keyspan adaptor always works and that all others have one problem or another. When you find the website for Keyspan, you want the product with one RS232 port on it.
A good answer is easier with a clear question giving the make and model of everything. "The biggest problem in communication is the illusion that it has taken place." -- G. “Bernie” Shaw