A collection of software, firmware, tools, and utilities for the LEGO® MindStorms RCX
For RCX bricks with a power port, the LEGO recommendation was their 9V AC Adapter part # 9833.
FTDI chips generally have the best reputation, so more general advice is to look for adapters with those chips.
Due to the design of the serial IR tower, a “dummy” 9V battery is the easiest replacement. No fees, commissions, etc. are earned with these links; other sources welcome.