FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Universal Data Access
Posts: 1088
Joined: Fri Oct 07, 2005 03:33 PM

Universal Data Access

Posted: Fri May 04, 2012 01:07 PM

Hello,

I need some suggestions to develop a independent database application with the less efforts

I prefer to work with ADS, but here we have Oracle, Postgres, MySQL, .....

Some option?

ADO
SQLRDD ( xHarbour )
ODBC

have some body experiences to share with us??

best regards

Marcelo

Posts: 2706
Joined: Fri Oct 07, 2005 01:50 PM

Re: Universal Data Access

Posted: Fri May 04, 2012 01:21 PM

Marcello

I like ADO over ODBC .. and each database has its own Ado ( oledb ) client that will need to be present on each workstation running your application.

Ms Sql Server has native OLEDB client support out of the box and has been present in every Windows OS since Win98 including Windows 8. When I started using Enterprise RDMS's, I chose Ms Sql Server because I did not have to worry about distributing a workstation client.

The code is the same whether you connect to Oracle, dB2, Sql Server which makes your code transparent. The only difference is the connection string which is different for each database as well as the oledb ( ado ) client.

Here is the FiveWin wiki on the subject and code examples.

Rick Lipkin

http://wiki.fivetechsoft.com/doku.php?i ... ted_stuffs

Posts: 1088
Joined: Fri Oct 07, 2005 03:33 PM

Re: Universal Data Access

Posted: Fri May 04, 2012 06:12 PM

Rick,

thanks very much

regards

Marcelo

Continue the discussion