FiveTech Software tech support forums

Posted: **Fri Jun 01, 2007 11:17 pm**

Enrico

This could be a complicated issue for Antonio and the ADO rdd developers .. RDD is so engrained with the concept of indexes .. for me ( with your help ) .. I have been able to leverage my rdd knowledge in substituting the ADO methods and have almost finished my complete re-write of a very complicated and robust application in MS SQL.

I see where the current ADO rdd builds on indexes for relations .. to me .. going into this ADO project .. I have totally abandoned indexes and sharpened my SQL to to just query what I want and not ( never, never ) do a SELECT * from TABLE unless I have to do an APPEND addnew() and that cursor is a bit UGLY 25k worth of records with a complete field recorset.

For the most part .. ( day to day ) data entry is limited to editing existing records and adding or editing related records spun off with a seperate recordset SELECT * ( or fields ) from <relational table> where <condition> = <primary key> .. returns only a cursor with limited records and I might add with no INDEXES... very fast.

I have noticed a 'severe' limitation to the SQL part of the ( open ) connection string in that if you list fields to limit your query .. if you add more than 6 or 7 .. xHarbours ADO will lock up .. apparently there is a limit on the length of the charactor string you can pass ..

I have taken a fresh approach to ADO and have totally wiped indexes off my radar scope. Now .. with that said .. I think the FIND method could be wrapped up into seek .. however if you use .dbf and ADO in combination you are going to have a translation problem .. what perhaps could happen is leave traditional seek in the ADO rdd for those developers that can use those databases that support indexes .. but spin off a new command like SeekAdo ( cSQL ) that one could use the oRs:Find() wrapper.

Also needed is the <order by> clause in the USE command which I have found to have very little overhead in presenting a records fetch.. plus I think it helps if the <order by> is your primary key ..

Lots of potential here .. could open up the whole RDMS world to xBase !!

Rick Lipkin

Posted: **Fri Jun 22, 2007 10:25 am**

I have installed a free MS SQL 2005 server on a server.

I've build a database with some tables.

How can I connect to it. Do I have to use a path or an ip adress.

Do I need a client dll ??

I think the examples in the adordd are working for a local file.

Thanks,

Willy Hermans.

Posted: **Fri Jun 22, 2007 11:01 am**

Hi Willy,

try http://fivetechsoft.com/forums/viewtopic.php?t=7312

You can use Server Name if you use DNS Server or hosts file with names and ips.

No, you don't need a client.

Best regards,

Felix

Posted: **Fri Jun 22, 2007 12:42 pm**

Use "MediBank" Via "ADORDD" Table "Provider" FROM "Server\SQLEXPRESS" User "sa" PASSWORD "" SQL

If I run this I have an error code 16389 E_Fail:Open

The User is sa and there is no password

It works in visual studio

Any idea

Thanks,

Willy Hermans

Posted: **Sat Jun 30, 2007 4:21 pm**

How can I change my buildh.bat . I did some chnages with some errors :

Code: Select all | Expand

echo c0w32.obj + > b32.bc
echo %1.obj, + >> b32.bc
echo %1.exe, + >> b32.bc
echo %1.map, + >> b32.bc
echo %fwhdir%\lib\FiveH.lib %fwhdir%\lib\FiveHC.lib + >> b32.bc
echo %hdir%\lib\rtl.lib + >> b32.bc
echo %hdir%\lib\vm.lib + >> b32.bc
echo %hdir%\lib\gtgui.lib + >> b32.bc
echo %hdir%\lib\lang.lib + >> b32.bc
echo %hdir%\lib\macro.lib + >> b32.bc
echo %hdir%\lib\rdd.lib + >> b32.bc
echo %hdir%\lib\dbfntx.lib + >> b32.bc
echo %hdir%\lib\dbfcdx.lib + >> b32.bc
echo %hdir%\lib\dbffpt.lib + >> b32.bc
echo %hdir%\lib\hbsix.lib + >> b32.bc
echo %hdir%\lib\debug.lib + >> b32.bc
echo %hdir%\lib\common.lib + >> b32.bc
echo %hdir%\lib\pp.lib + >> b32.bc
echo %hdir%\lib\codepage.lib + >> b32.bc

rem Uncomment these two lines to use Advantage RDD
echo %fwhdir%\lib\adordd.lib + >> b32.bc
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
echo %hdir%\lib\Ace32.lib + >> b32.bc
echo %hdir%\lib\Ads32.lib + >> b32.bc

echo %bcdir%\lib\cw32.lib + >> b32.bc
echo %bcdir%\lib\import32.lib + >> b32.bc
echo %bcdir%\lib\psdk\odbc32.lib + >> b32.bc
echo %bcdir%\lib\psdk\nddeapi.lib + >> b32.bc
echo %bcdir%\lib\psdk\iphlpapi.lib + >> b32.bc
echo %bcdir%\lib\psdk\rasapi32.lib + >> b32.bc
echo %fwhdir%\lib\hboleaut.lib, >> b32.bc
^^^^^^^^^^^^^^^^^^^^^^^^^^^^

errors :
Compiling...
Harbour Alpha build 1.0 Intl.
Copyright 1999-2007, http://www.harbour-project.org/
Compiling 'access1.prg' and generating preprocessed output to 'access1.ppo'...
Lines 3712, Functions/Procedures 1
Generating C source output to 'access1.c'... Done.
Borland C++ 5.5.1 for Win32 Copyright (c) 1993, 2000 Borland
access1.c:
Turbo Incremental Link 5.00 Copyright (c) 1997, 2000 Borland
Error: Unresolved external '_HB_FUN_USRRDD_RDDDATA' referenced from E:\COMPILER
CLIPPER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_USRRDD_AREADATA' referenced from E:\COMPILE
\CLIPPER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_USRRDD_ID' referenced from E:\COMPILER\CLIP
ER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_UR_SUPER_ERROR' referenced from E:\COMPILER
CLIPPER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_HB_ISLOGICAL' referenced from E:\COMPILER\C
IPPER\FWH\LIB\HBOLEAUT.LIB|win32ole
Error: Unresolved external '_HB_FUN_UR_SUPER_SETFIELDEXTENT' referenced from E:
COMPILER\CLIPPER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_UR_SUPER_ADDFIELD' referenced from E:\COMPI
ER\CLIPPER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_UR_SUPER_OPEN' referenced from E:\COMPILER\
LIPPER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_UR_SUPER_CLOSE' referenced from E:\COMPILER
CLIPPER\FWH\LIB\ADORDD.LIB|adordd
Error: Unresolved external '_HB_FUN_USRRDD_GETFUNCTABLE' referenced from E:\COM
ILER\CLIPPER\FWH\LIB\ADORDD.LIB|adordd
* There are errors

E:\programs\Database\clipper\FWH\adordd>

Posted: **Sat Jun 30, 2007 7:30 pm**

Ehab,

You have to link usrrdd.lib too

Posted: **Sun Jul 01, 2007 6:56 pm**

I got that error :

Compiling...
Harbour Alpha build 1.0 Intl.
Copyright 1999-2007, http://www.harbour-project.org/
Compiling 'access1.prg' and generating preprocessed output to 'access1.ppo'...
Lines 3712, Functions/Procedures 1
Generating C source output to 'access1.c'... Done.
Borland C++ 5.5.1 for Win32 Copyright (c) 1993, 2000 Borland
access1.c:
Turbo Incremental Link 5.00 Copyright (c) 1997, 2000 Borland
Error: Unresolved external '_hb_rddGetWorkAreaPointer' referenced from E:\COMPIL
ER\CLIPPER\FWH\LIB\USRRDD.LIB|usrrdd
Error: Unresolved external '_HB_FUN_HB_ISLOGICAL' referenced from E:\COMPILER\CL
IPPER\FWH\LIB\HBOLEAUT.LIB|win32ole
* There are errors

Code: Select all | Expand

rem Uncomment these two lines to use Advantage RDD
echo %fwhdir%\lib\adordd.lib + >> b32.bc
echo %fwhdir%\lib\usrrdd.lib + >> b32.bc
echo %fwhdir%\lib\hboleaut.lib + >> b32.bc

echo %hdir%\lib\Ace32.lib + >> b32.bc
echo %hdir%\lib\Ads32.lib + >> b32.bc

echo %bcdir%\lib\cw32.lib + >> b32.bc
echo %bcdir%\lib\import32.lib + >> b32.bc
echo %bcdir%\lib\psdk\odbc32.lib + >> b32.bc
echo %bcdir%\lib\psdk\nddeapi.lib + >> b32.bc
echo %bcdir%\lib\psdk\iphlpapi.lib + >> b32.bc
echo %bcdir%\lib\psdk\rasapi32.lib , >> b32.bc

Posted: **Sun Jul 01, 2007 8:27 pm**

Ehab,

Download the most recent Harbour build for FWH from www.fivetechsoft.com/files/harbour.exe

Posted: **Tue Jul 03, 2007 4:38 pm**

hi, when i down last code of adordd? thanks

Posted: **Thu Jul 19, 2007 5:07 am**

Antonio,
Está en este foro la última versión de AdoRDD?

Cual es el link para bajarla?

Gracias de antemano.

Posted: **Thu Jul 19, 2007 7:14 am**

José,

www.fivetechsoft.com/files/adordd.zip

Posted: **Thu Jul 19, 2007 12:10 pm**

Antonio Linares wrote:José,

www.fivetechsoft.com/files/adordd.zip

Muchas gracias Antonio.

Posted: **Thu Jul 26, 2007 2:05 pm**

Hello Antonio

is it possible create a table with MySql ?
I try this but doesn't work

DbCreate( "licenze;rag;MYSQL;localhost;root;mauri",;
{ { "FIRST", "C", 10, 0 },;
{ "LAST", "C", 10, 0 },;
{ "AGE", "N", 8, 0 } }, "ADORDD" )

Regards MAurizio

Posted: **Thu Jul 26, 2007 6:22 pm**

Maurizio,

In our tests we have not been able to create it, probably because we were using a remote MySQL host free website. If you are able to create it using standard ADO, then ADORDD should also work as ADORDD is just a wrapper on top of ADO and USRRDD

Posted: **Wed Aug 01, 2007 1:11 pm**

O ADORDD funciona com Postgres ?
Se sim, como ?

Obrigado

FiveTech Software tech support forums

New AdoRDD (free)

How to connect to MS SQL server