FiveTech Software tech support forums

Posted: **Fri Apr 27, 2007 4:37 pm**

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

Thanks,

Posted: **Fri Apr 27, 2007 5:44 pm**

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

Posted: **Fri Apr 27, 2007 8: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 | Expand

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


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

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

Sorry, but my english is very , very bad.

Posted: **Sat Apr 28, 2007 2:49 am**

Hi Friends

you must be add usrrdd library into linked

Can a get a copy of USRRDD.LIB please.

My email : aksharasoft@hotmail.com

Thanks

- Ramesh Babu P

Posted: **Sat Apr 28, 2007 6:30 am**

You can get it from http://www.harbour-project.org/ downloading the latest stable binaries.

Regards Eugeniusz

Posted: **Sat Apr 28, 2007 7:22 am**

Here it is usrrdd.lib for Harbour:

http://rapidshare.com/files/28329001/usrrdd.zip.html

And here it is for xharbour:

http://rapidshare.com/files/28329167/usrrdd.zip.html

Posted: **Sun Apr 29, 2007 10:51 am**

SET FILTER TO ... support

i.e.: SET FILTER TO First = "Homer"

To use special SQL expressions, place quotation marks around them, i.e.:
SET FILTER TO "City LIKE 'Chi*'"

http://rapidshare.com/files/28522792/adordd.zip.html

Posted: **Sun Apr 29, 2007 11:17 am**

It should be

Code: Select all | Expand

SET FILTER TO "City LIKE 'Chi%'"

as far as I know.

EMG

Posted: **Sun Apr 29, 2007 11:24 am**

Enrico,

Thanks for your info :-)

Anyhow, SET FILTER TO "City LIKE 'Chi*'" seems to be working fine too:

Posted: **Sun Apr 29, 2007 11:26 am**

I wonder if the used character is db engine dependent...

EMG

Posted: **Sun Apr 29, 2007 11:27 am**

I used '%' with Jet, MSDE, MSSQL and MSVFP driver.

EMG

Posted: **Sun Apr 29, 2007 11:29 am**

Enrico,

Yes, probably.

We are doing the tests with MySQL and Access and it worked fine.

Posted: **Sun Apr 29, 2007 1:56 pm**

Antonio,

Enrico is right !

http://www.techonthenet.com/sql/like.php

http://en.wikipedia.org/wiki/SQL

Regards,

Felix

Posted: **Sun Apr 29, 2007 3:24 pm**

Felix,

Thanks :-)

Posted: **Sun Apr 29, 2007 3:39 pm**

2007-04-29 17:34 UTC+0100 Antonio Linares (alinares@fivetechsoft.com)
* contrib/adordd/adordd.prg
* Oracle support, thanks to Srdjan Dragojlovic

* contrib/adordd/adordd.ch
* formatting

You may download it from here:
http://rapidshare.com/files/28565058/adordd.zip.html

FiveTech Software tech support forums

New AdoRDD (free)

Re: Where can I find ADORDD.lib