Dancer does have a standalone deployment mode using HTTP::Server::Simple::PSGI

OP, not sure why you are having issues getting ODBC working, as Corion said there are modules for it. Post your code?

Anyway, I'm a big fan of Dancer.