FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour ADO RDD xHarbour
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: ADO RDD xHarbour
Posted: Wed Jul 01, 2015 06:00 PM

Lucas,

I am running Win 8.1 x64. I'm using the latest xHarbour and FWH.

The complete error is shown in a previous message. It is failing to open the table.

Please send me your working EXE so I can try it here.

James

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Posts: 1303
Joined: Tue Jul 21, 2009 08:12 AM
Re: ADO RDD xHarbour
Posted: Wed Jul 01, 2015 06:08 PM

James,

I sent you a zip file with an exe so as to retreive full error.log and check error.

Here you also have it:

http://rg.to/file/6a40703c481c85f1d406d ... zO___.html

Muchas gracias. Many thanks.



Un saludo, Best regards,



Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producci贸n]



Implementando MSVC 2010, FWH64 y ADO.



Abandonando uso xHarbour y SQLRDD.
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: ADO RDD xHarbour
Posted: Wed Jul 01, 2015 06:22 PM

Lucas,

OK, I was linking in adordd.lib and you were using #include "adordd.prg." When I changed to your syntax, it worked. Perhaps I need to move the lib location in the buildx.bat file?

James

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Posts: 1303
Joined: Tue Jul 21, 2009 08:12 AM
Re: ADO RDD xHarbour
Posted: Wed Jul 01, 2015 06:35 PM

Hello,

Try to put the adordd.lib as the first lib.

Or maybe there is something wrong at the lib.

Glad you get it working.

Muchas gracias. Many thanks.



Un saludo, Best regards,



Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producci贸n]



Implementando MSVC 2010, FWH64 y ADO.



Abandonando uso xHarbour y SQLRDD.
Posts: 1067
Joined: Wed Nov 09, 2005 02:17 AM
Re: ADO RDD xHarbour
Posted: Wed Jul 01, 2015 07:58 PM
Hi Guys,
I'm trying to test ADORDD, but when i compile the adordd.prg, appear these errors:
Code (fw): Select all Collapse
ADORDD.PRG(288) Error E0020 聽Incomplete statement or unbalanced delimiters
ADORDD.PRG(291) Error E0020 聽Incomplete statement or unbalanced delimiters
ADORDD.PRG(295) Error E0010 聽ENDIF does not match IF
ADORDD.PRG(363) Error E0020 聽Incomplete statement or unbalanced delimiters
ADORDD.PRG(424) Error E0020 聽Incomplete statement or unbalanced delimiters
ADORDD.PRG(428) Error E0030 聽Syntax error "syntax error at 'END'"


I'm using FW/Harbour and get the adordd.prg from https://github.com/AHFERREIRA/adordd
Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Bel茅m-Pa-Brazil
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: ADO RDD xHarbour
Posted: Wed Jul 01, 2015 08:15 PM

Vilian,

From your errors, it appears that Harbour doesn't support the TRY/CATCH/END commands. Or, maybe you need to #include another file.

I am using xHarbour and I don't get any errors.

James

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: ADO RDD xHarbour
Posted: Wed Jul 01, 2015 08:20 PM
Lucas,

Try to put ADORDD.LIB as the first lib.


Good guess, that worked. Before I had it as the last library.

James

Code (fw): Select all Collapse
...
echo %bcdir%\lib\c0w32.obj + > b32.bc
echo adordd.lib + >> b32.bc
...
FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Posts: 1067
Joined: Wed Nov 09, 2005 02:17 AM
Re: ADO RDD xHarbour
Posted: Wed Jul 01, 2015 11:14 PM
Thanks James,
I included the hbcompat.ch, and only rest some warnings:

Code (fw): Select all Collapse
adordd.prg(4471) Warning W0001 聽Ambiguous reference 'LRET'
adordd.prg(4476) Warning W0001 聽Ambiguous reference 'LRET'
adordd.prg(4481) Warning W0001 聽Ambiguous reference 'LRET'
fivewin.ch(109) Warning W0002 聽Redefinition or duplicate definition of #define CRLF
adordd.prg(5442) Warning W0002 聽Redefinition or duplicate definition of #define UR_FI_FLAGS
adordd.prg(5443) Warning W0002 聽Redefinition or duplicate definition of #define UR_FI_STEP
adordd.prg(5444) Warning W0002 聽Redefinition or duplicate definition of #define UR_FI_SIZE


How can i solve this? Does it have a library for harbour?
Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Bel茅m-Pa-Brazil
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: ADO RDD xHarbour
Posted: Wed Jul 01, 2015 11:24 PM

Vilian,

I don't know why you are getting the lRet as being ambiguous since it is defined as a LOCAL. They do happen to be within the TRY/END sequence so I wonder if that isn't still an issue.

The other warnings I wouldn't worry about.

You can build your own lib using Borland's TLIB.EXE, or just add the prg to your app.

James

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Posts: 1303
Joined: Tue Jul 21, 2009 08:12 AM
Re: ADO RDD xHarbour
Posted: Thu Jul 02, 2015 10:21 AM

Vilian,

You can safely ignore such warnings.

They are from functions under development.

Muchas gracias. Many thanks.



Un saludo, Best regards,



Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producci贸n]



Implementando MSVC 2010, FWH64 y ADO.



Abandonando uso xHarbour y SQLRDD.
Posts: 1067
Joined: Wed Nov 09, 2005 02:17 AM
Re: ADO RDD xHarbour
Posted: Thu Jul 02, 2015 11:58 AM
Thanks Lucas,

Now, when i try open a file appear this error:

(DOS error -2147352567) WINOLE/1007 Operation not allowed when the objeto has closed(0x800A0E78) ADODB.Connection

I'm trying to use ADORDD with MariaDb.
Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Bel茅m-Pa-Brazil
Posts: 1303
Joined: Tue Jul 21, 2009 08:12 AM
Re: ADO RDD xHarbour
Posted: Thu Jul 02, 2015 12:19 PM

Hello,

We tested with Access, MySQL and MSSQL.

With the above, its working pretty good.

Muchas gracias. Many thanks.



Un saludo, Best regards,



Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producci贸n]



Implementando MSVC 2010, FWH64 y ADO.



Abandonando uso xHarbour y SQLRDD.
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: ADO RDD xHarbour
Posted: Thu Jul 02, 2015 12:32 PM

Vilian,

It appears that MariaDB is not yet supported. However, take a look at the ADOOPENCONNECT Method of the ADORDD.PRG and you will see how the various SQL databases are opened. Maybe you can create your own CASE statement for the MariaDB. Let us know if that works.

Alternately, you could just try getting up and running with the ACCESS Northwind.mdb as I have done. Then once you have that figured out you could proceed to trying to get the MariaDB going too.

James

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Posts: 1067
Joined: Wed Nov 09, 2005 02:17 AM
Re: ADO RDD xHarbour
Posted: Thu Jul 02, 2015 03:19 PM
James,

With MariaDb don麓t work. I changed to MySql and now i have this error:

Code (fw): Select all Collapse
聽 聽Error description: (DOS Error -2147352567) WINOLE/1007 聽[Microsoft][ODBC Driver Manager] Name of database font not find (0x80004005): Microsoft OLE DB Provider for ODBC Drivers
聽 聽Args:
聽 聽 聽[ 聽 1] = C 聽 Driver={mySQL ODBC 5.3 ANSI Driver};server=localhost;Port=3306;Option=32;database=vfatec;uid=root;pwd=vfatec;

Stack Calls
===========
聽 聽Called from: 聽=> TOLEAUTO:OPEN( 0 )
聽 聽Called from: \tec2000\SGV90\ADORDD.PRG => ADOOPENCONNECT( 474 )
聽 聽Called from: \tec2000\SGV90\ADORDD.PRG => ADOGETCONNECT( 5238 )
聽 聽Called from: \tec2000\SGV90\ADORDD.PRG => ADODEFAULTS( 5218 )
聽 聽Called from: tempresa.prg => TSISTEMA:NEW( 400 )
聽 聽Called from: \tec2000\SGV90\SGV.PRG => START( 175 )


I need to install anymore thing ?
Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Bel茅m-Pa-Brazil
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: ADO RDD xHarbour
Posted: Thu Jul 02, 2015 09:36 PM

Vilian,

It appears to be saying that it is not finding the database. Perhaps the path is not specified or is incorrect.

You should also check your normal connection syntax with that being used in the ADORDD.PRG's ADOOOPENCONNECT() function.

I don't have MySQL installed here so I can't test it. Plus I am running xHarbour not Harbour.

I do suggest using the ACCESS Northwind.mdb to get started. After you get that opened successfully, then you can try other databases. MySQL is supposed to be syntax compatible so it should be easy once you get Northwind.mdb working.

James

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10