Please,My car is not moving on the drive position on 1998 Honda CR-V

on my way from office,the check engine light came up and the car cld not move again.Then since then cld not move on drive or reverse position and if wait f a while,it wil move fr a short distance and then stops

Asked by for the 1998 Honda CR-V
It sounds like the transmission has failed!