Page 1 of 1
FiveWin and MS Sql
Posted: Thu Aug 30, 2007 8:47 am
by 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 ??
SQL and FiveWin
Posted: Thu Aug 30, 2007 9:16 am
by alexstrickland
I suggest you investigate ADORDD, in the sticky post just above your message.
Regards
Alex
Posted: Thu Aug 30, 2007 2:10 pm
by 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
Posted: Fri Aug 31, 2007 7:57 am
by PeterHarmes
Has anyone compared speed/performace between ADO & the xHarbour SQLRDD?
I would be interested in how seek speeds compare
Pete
Posted: Fri Aug 31, 2007 4:16 pm
by 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.