What is best interface layer to Access Oracle ?

[shri_fwh]

Hi ,

May be this topic would be an old to all FWH users, bust as I new to FWH just I would like to know that, what is best layer to access to Oracle without any bug?
I read in forum, I found two options like ADO, ODBC. But still I'm confused which Option should I select whether ADO or ODBC ?

Please guide me ...! Thanks in advance...!

Regards
Shridhar

[nageswaragunupudi]

ADO
ADO is more advanced than ODBC

[shri_fwh]

Thanks a lot...!

Could you please post some code ?

Thanks
Shridhar

[nageswaragunupudi]

Please review \fwh\samples\testxbr3.prg. Among other things, this program also demonstrates the use of ADO with Access database. You need to change the connection string to test on Oracle.

You can find connection strings to different databases on http://www.connectionstrings.com.

Good source for learning more about ADO is http://www.w3schools.com