vb.net - Connect an application to type of ODBC driver 32 and 64 -

vb.net - Connect an application to type of ODBC driver 32 and 64 -

i stuck scenario, developing vb application import info excel file oracle db on scheme runs win7 64 , office 32. connection oracle through odbc. issue here not able connect both odbc driver @ same time, office driver 32 , oracle driver 64 if app runs in 64 mode recognizes oracle dsn not office , , if runs in 32 mode connect office not oracle. thought how prepare this, please note making connection oracle through odbc must

thanks

so 32 bit odbc driver oracle or 64 bit odbc driver office.

alternatively, odbc-odbc bridge - can bridge between 32 bit applications , 64 bit drivers.

vb.net excel odbc