FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour What is best interface layer to Access Oracle ?
Posts: 336
Joined: Mon Dec 07, 2009 02:49 PM
What is best interface layer to Access Oracle ?
Posted: Mon Dec 28, 2009 07: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 24.04, BCC 7 32 bit, MariaDB
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: What is best interface layer to Access Oracle ?
Posted: Mon Dec 28, 2009 08:33 AM

ADO
ADO is more advanced than ODBC

Regards



G. N. Rao.

Hyderabad, India
Posts: 336
Joined: Mon Dec 07, 2009 02:49 PM
Re: What is best interface layer to Access Oracle ?
Posted: Mon Dec 28, 2009 08:41 AM

Thanks a lot...!

Could you please post some code ?

Thanks
Shridhar

Thanks

Shridhar

FWH 24.04, BCC 7 32 bit, MariaDB
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: What is best interface layer to Access Oracle ?
Posted: 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

Continue the discussion