Yes you do need to use an odbc connection but you really do not need to set up a dsn you can connect strait to your oracle database through ado.

Thanks
Darren Mc Dowell

P.S. use microsofts oracle driver, oracles driver has problems