The cable for the RH-96 is a standard serial port level and no USB is involved. Many mistake the odd connector on the front panel of the 996T and XT models as well as the side connectors on the portable models as Mini USB connectors. They are not, they are a slightly diferent connector that does resemble a mini-usb connector until you look at it a little closer. I forget what the connector is officially called but there was a very old post when someone had found some short USB cables that had the standard USB A end on the computer end and this odd connector on the other end that Uniden used. I seem to recall it was called a Hi_rose connector but I think that may have actually been a Chinese manufacturer of cables and connectors and not really the connector name. Anyway, the old eBay link for the 4 inch adapter cables was a good source of the connector. One just needed to remove the computer USB A end and splice the remaining connector to whatever they needed to attach the front Uniden ports too. A DB-9 for programming and firmware updates or a standard 1/8th inch (3.5mm) stereo connector if making a cable for the RH-96.
I forget the actual RS-232 pinout for the cable and connector but it was very simple to build your own. Use a meter and determine the ground or common wire and that will be the sleeve on your 3.5mm plug. The only other signals were the TX and RX data signals. One of course went to the Tip and the other to the Ring on your stereo plug. If your baud rates match on the scanner and your RH-96, it should work. If not, simply reverse the RX and TX wires at the stereo plug or whichever end is easier and you should be good to go. Being RS-232 levels, reversed wiring will not cause any damage to either device. If the RH96 still does not work, double check that the baud rates match on both the scanner for that port and the RH96. Also double check the wiring again and make sure the common or ground wire is on the sleeve of the stereo connector. The corresponding pins if working on the DB-9 end are Pin 5 for the common or ground wire and pins 2 and 3 for the TX and RX data signals.
On the 996T and XT models, the rear DB-9 connector will also work with the RH-96 using a properly built cable and correct baud rate settings in the radio.
The RH-96 will also work with the rear DB-9 connector on the 536HP model as well as the odd serial connector on the side of the 436HP model. You just select the correct baud rate on the x36HP models from the GPS setup menu which is found under the Set Your Location/Set Up GPS/Set Serial Port menu and choosing the matching baud rate for the RH96. I forget but you may need a Null modem adapter and possibly a gender changer if using the rear DB-9 port on the base models and are also using some type of pre-built cable. If rolling your own cable for using the DB-9 port, you would just wire it correctly so you do not need a gender changer or null modem adapter.
The SDS100 no longer has the odd looking serial port connector (or any standard serial port for that matter) so the RH-96 cannot be used with this model. Even if the SDS100 did have a serial port connector, the RH96 would probably not work very well with it due to all the screen info the SDS100 can output over the serial line compared with the much smaller command set output by the older models. If an SDS100 did have a serial port, an RH96 may display some info but it would probably be mostly unreadable gibberish. For an example, try hooking an SDS100 up to ProScan and set the Scanner Type in ProScan to an x96 or an x36HP model and see how the virtual display screen looks! That's a fair example of how a RH96 would display an SDS100 if you could hook it up to a RH96. The older models from the 15 up to the 536HP can work with the RH96 as long as the RH96 has the latest firmware applied that allowed it to work with the newer XT models when they were released.