What you have now is an RS-232 serial port to USB adapter.
What you need is called an "encoder".
Sounds like the type of encoder you're looking for changes joystick/button presses into gamepad outputs (gamepad-style encoder) rather than one that outputs keystrokes. (keyboard-style encoder)
Here's some general pinout info for MSX joysticks.
http://old.pinouts.ru/Inputs/JoystickMsx_pinout.shtmlNot sure exactly which version of
"the arcade" joystick you have, but it appears that they are also Atari-compatible since most systems that used DB9 joystick port connectors used almost identical pinouts.
Raphnet has a DB9 to USB adapter with a built-in gamepad encoder >>>
here <<< that
should work for your setup.
Looking at the
schematic from the related raphnet build-your-own-from-scratch
project page:
- Up, down, left, and right are on pins 1-4 -- good for both MSX and Atari sticks
- Common is on pin 8 -- good for both MSX and Atari sticks
- Button 1 is on pin 6 -- good for both MSX and Atari sticks
- Button 2 (if your stick has one) might be on pin 7 which is labeled "select" on the raphnet adapter.
-- The project page mentions that the firmware has auto-detection, so you might want to ask them if your stick is already compatible.
--
Worst case scenario, you might have to make an adapter cable from a DB9 extension cable to connect joystick pin 7 to the correct adapter pin.
This page mentions that there may be a select switch button on the bottom of your stick that changes which button is conected to which pin.
That's about as close to certain as I can get you without knowing the exact model and pinout of your stick.
Scott