Firstly
There is no such car that is 17 years old and only driven 115,000 kms.
Secondly
Welcome to Honda autobox ownership, (they are trash even when new) you can verify if all pressure switches are reporting and if the shift solenoids are truly working, then you have direct clutch drum piston failure which has damaged the clutch packs it holds.
Repairing the box with new parts will make you choke if you price it out, and for such an an old car it would be ok to slap a scrapyard box in it, but remember that you may get lucky and get a good item or get a literal piece of scrap, so you may have to swap 2 to 4 times to get a reliable one.
And even after that its still a gamble as you wont know how old the scrapyard box is and how much life is left in it.