FiveWin and MS Sql

[Jack]

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 ??

[alexstrickland]

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

Regards
Alex

[Rick Lipkin]

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

[PeterHarmes]

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

I would be interested in how seek speeds compare

Pete

[R.F.]

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.