topic-6814

Gale FORd

Posts: 663

Joined: Mon Dec 05, 2005 11:22 PM

New AdoRDD (free)
Posted: Fri Apr 27, 2007 04:37 PM

I compiled and linked provided prg's with xHarbour commercial and FWH and it is working ok so far.

Thanks,

Antonio Linares

Posts: 44158

Joined: Thu Oct 06, 2005 05:47 PM

New AdoRDD (free)
Posted: Fri Apr 27, 2007 05:44 PM

Code: Select all Collapse

2007-04-27 19:33 UTC+0100 Antonio Linares (alinares@fivetechsoft.com)
   * contrib/adordd/adordd.ch
   * contrib/adordd/adordd.prg
      * QUERY support and MS SQL support (thanks to Vikthor!)

Vikthor already successfully tested the ADORDD on Microsoft SQL server and added a new clause QUERY :-)

Regards,

Antonio

regards, saludos

Antonio Linares
www.fivetechsoft.com

Vikthor

Posts: 298

Joined: Fri Oct 07, 2005 05:20 AM

Re: Where can I find ADORDD.lib
Posted: Fri Apr 27, 2007 08:44 PM

ask wrote:
Antonio Linares wrote:A.S.K.

You just need AdoRdd.lib and HbOleAut.lib if you use Harbour. For xharbour users, just AdoRdd.lib

Antonio I use xharbour but I don't have ADORDD.LIB .Can you please tell me where I can found it?

Thank you in advance
A.S.K.

if you are using xHarbour and got this errors :

Code: Select all Collapse

Error: Unresolved external '_HB_FUN_USRRDD_RDDDATA' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd 
Error: Unresolved external '_HB_FUN_USRRDD_AREADATA' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd 
Error: Unresolved external '_HB_FUN_USRRDD_ID' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd 
Error: Unresolved external '_HB_FUN_UR_SUPER_ERROR' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd 
Error: Unresolved external '_HB_FUN_UR_SUPER_SETFIELDEXTENT' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd 
Error: Unresolved external '_HB_FUN_UR_SUPER_ADDFIELD' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd 
Error: Unresolved external '_HB_FUN_UR_SUPER_OPEN' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd 
Error: Unresolved external '_HB_FUN_UR_SUPER_CLOSE' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd 
Error: Unresolved external '_HB_FUN_USRRDD_GETFUNCTABLE' referenced from C:\XHARBOUR\LIB\ADORDD.LIB|adordd

you must be add usrrdd library into linked

by the way , if you are using Microsoft SQL Server 2005 , and wish use adordd , you must be make little changes to adordd.prg file

Code: Select all Collapse

       case s_cEngine == "SQL" 
              oAdo:CursorType      = adOpenStatic 
              oAdo:CursorLocation = adUseClient 
              oAdo:LockType         = adLockPessimistic 
              oAdo:Open( "SELECT * FROM " + s_cTableName,; 
                                "Provider=SQLOLEDB;" + ; 
                                "server=" + s_cServer + ; 
                                ";database=" + aOpenInfo[ UR_OI_NAME ] + ; 
                                ";uid=" + s_cUserName + ; 
                                ";pwd=" + s_cPassword, adOpenKeyset, adLockOptimistic )

and need modify this line into Adordd.ch

Code: Select all Collapse

[ <dbEngine: ACCESS, MYSQL, ORACLE, INFORMIX, SQL> ];

USE northwind VIA "ADORDD" TABLE "Customer" SQL ;
FROM "ServerSql2005" USER "sa" PASSWORD "super"
Browse()
[/code]

Y finally , like said Rene, SQL dosen'n need ODBC

Fernando y Antonio...¡¡ felicitaciones por este aporte !!

and .... remote connections with SQL y MySQL works perfect