I did run the mdac_typ.exe(manually also), but still it doesn't work.
I have done the 'Oracle ODBC test', that Oracle provides, using a DSN I got connected and could query the data. So I know that the ODBC drivers from Oracle side are fine, but I think there is problem with ODBC drivers that VB provides.
Thanks