There are many types of sedation like laughing gas or I/v that could help you get around the sight sounds and smells of the drill. I'd also like to reccomend you take a-look at
www.dentalfearcentral.org/forum to see other people with fears similar (like me)

and help you figure out a way to solve it.