Hi Friend,
I’m sure that there is no problem with the USB cable. Can you post a Screen Shot or picture of hyper terminal data that you are receving from GSM modem when connected.
Important Note: Take care that you are connecting Tx pin of GSM module to Rx pin of DB9 serial cable & Rx pin of GSM module to Tx pin of DB9 serialcable.