SetTrans does not provide us the flexibility to manage ourselve the connnection and used for single db connection whereas SetTransObject gives multiple connection to manage