FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour FiveWin and MS Sql
Posts: 300
Joined: Wed Jul 11, 2007 11:06 AM
FiveWin and MS Sql
Posted: Thu Aug 30, 2007 08:47 AM

I have to access sql tables with xharbour and fivewin .

I have to be able to add record modify and delete .

I cant install odbc driver on each workstation .

Each workstations are connected to a Win2003 server and the EXE is
on this server .

How to do it ??

Posts: 23
Joined: Thu Aug 30, 2007 08:52 AM
SQL and FiveWin
Posted: Thu Aug 30, 2007 09:16 AM

I suggest you investigate ADORDD, in the sticky post just above your message.

Regards
Alex

Posts: 2706
Joined: Fri Oct 07, 2005 01:50 PM
FiveWin and MS Sql
Posted: Thu Aug 30, 2007 02:10 PM

I agree .. ADO is the best way to connect to any SQL database .. Any Windows OS from ( at least ) 2000 on supports ADO right out of the box .. nothing to install or configure.

Rick Lipkin
SC Dept of Health, USA

Posts: 363
Joined: Wed Feb 15, 2006 02:06 PM
FiveWin and MS Sql
Posted: Fri Aug 31, 2007 07:57 AM

Has anyone compared speed/performace between ADO & the xHarbour SQLRDD?

I would be interested in how seek speeds compare

Pete

Posts: 840
Joined: Thu Oct 13, 2005 07:05 PM
FiveWin and MS Sql
Posted: Fri Aug 31, 2007 04:16 PM

SQLRDD is build based on ODBC.

Since ADO can use a native ado provider or a ODBC DSN, is my guess that ADO is faster than an RDD.

In my experience, the best way to handle SQL tables is using SQL statements, you lose A LOT if you try to manipulate SQL data "a la DBF", that`s why ADO is the best way to handle data, the power of the SQL along with a DBF like data handling.

Saludos

R.F.

Continue the discussion