> How do I setup the isolation level to "dirty read" for the
> connection ?

You can't. Dirty reads are not supported by the server. Lowest
isolation level is read committed.