Is the hold light on the dash blinking? If it is there might be an issue with the AT system. Last I know on that transmission the TCM receives inputs and decides when to shift. Look under this place for the AT service manual, might be useful if you decide to troubleshoot.
http://mellens.net/mazda/Mazda-Miata-1997/index.html