If you try to use a storage engine [dev.mysql.com] that is not compiled in or that is compiled in but deactivated, MySQL instead creates a table using the default storage engine, usually MyISAM.

If this is your particular case, then no, you don't have a lot of choice but to move to a different host. You can simulate your own transactions [webmasterworld.com] using table locking but having more control over your database moving into the future is something you are going to find being a requirement as opposed to a benefit.