Need Transmission Info [Please Help]

Hello im new to this forum and need some help. So I've always been a fan of the 1st Gen Cls, and last week I finally bought my first One. I picked up a 98 Cl 2.3 Automatic.. The only problem is it has no reverse. My question is what other Trans will interchange with my car, I've been told a 98-02 Accord will work, and also a 98 up Honda Odyssey/Isuzu Oasis, and a 97-99 Cl which one would be best for my car, and are they any differences in the Automatic Trannys? Any info on this would be greatly Appreciated! THANKS