I have been trying forever and searching for the answer to connect to
Oracle or any database from ODBC using DAO and/or ADO.

Can someone give some quick code as to how to do it?

Thanks in advance,
Jonetta.

Hi,

If you have the ODBC-Data-Source,
then the fastest way is to use the Application-Wizard,
shipping with VB pro and enterprise-versions.
It asks you a few questions, and then generates code for Data-Access via ADODC,
or simple code or as a Dataprovider-Class.

It's worth it to play around

Juergen