What is best interface layer to Access Oracle ?

What is best interface layer to Access Oracle ?

Postby shri_fwh » Mon Dec 28, 2009 7:16 am

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
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
shri_fwh
 
Posts: 301
Joined: Mon Dec 07, 2009 2:49 pm

Re: What is best interface layer to Access Oracle ?

Postby nageswaragunupudi » Mon Dec 28, 2009 8:33 am

ADO
ADO is more advanced than ODBC
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10626
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: What is best interface layer to Access Oracle ?

Postby shri_fwh » Mon Dec 28, 2009 8:41 am

Thanks a lot...!

Could you please post some code ?

Thanks
Shridhar
Thanks
Shridhar
FWH 19.12, BCC 7 32 bit, MariaDB
shri_fwh
 
Posts: 301
Joined: Mon Dec 07, 2009 2:49 pm

Re: What is best interface layer to Access Oracle ?

Postby nageswaragunupudi » Mon Dec 28, 2009 11:48 am

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
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10626
Joined: Sun Nov 19, 2006 5:22 am
Location: India


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 79 guests