Prev: Problem with 5333
Next: MS makes Foxpro OPEN-SOURCE.. interesting move
From: iDesmet on 19 Mar 2007 21:23
Hello,

As some of you already knows, I'm switching to ADS and currently using
the sample application from Markus Lorenzi (good sample btw), but when
I try to use the ADSADT.RDD Driver I got the following error:

"Error 5018: The handle given was not recognized by Advantage. Verify
specified handle is open/active. The given handle is not readable."

This doesn't happen when I use the AXDBFCDX.RDD Driver. Looking at the
Advantage Help I found only this:

"Note to Advantage TDataSet Descendant users: If you are writing a
multi-threaded application (for example, a Web application) it is
possible to get this error if you have not uniquely named each
TAdsConnection component. For further explanation and an example see
the topic, Building Multi-Threaded Applications with TAdsQuery and
TAdsTable in the Advantage TDataSet Descendant Help documentation
(ADE.HLP). (Note that each of the Advantage products and their
corresponding Help files are installed separately.)"

But it doesn't apply for me.

I've re-installed the following: "Advantage CA-Visual Objects RDDs",
"Advantage Client Engine" and the "Advantage Data Architect" all are
version 8.10.0.06, I've confirmed it also with the ADSVER.EXE tool

Tried with Dependency Walker to see which VO dll's require the RDD's
and it show me that it depends on VO27RUN.DLL so this is not a
problem.

As a note: I've the following files at the Bin directory of CAVO27:

ace32.dll
ads.ini
adsadt.rdd
adsloc32.dll
adslocal.cfg
ansi.chr
axcws32.dll
axdbfcdx.rdd
axdbfntx.rdd
extend.chr

PS I also noted that if I want to try to open a DB using the
ADSADT.RDD Driver in the DB Server Editor, I doesn't let me choose
files with ADT extension, only DBF extension.

Well, that's all I've tried and I don't have more ideas. So any
suggestions would be welcome.

Thanks in advance.

Best Regards
David Desmet

From: Paul D B on 20 Mar 2007 03:57

>
> Well, that's all I've tried and I don't have more ideas. So any
> suggestions would be welcome.
>
> Thanks in advance.
>
> Best Regards
> David Desmet

David,

ADS have there own newsserver devzone.advantagedatabase.com and in there
you'll find a newsgroup advantage.visual-objects.
You'll have quicker respons there I think.
I have never used ADT files, can't help you with it.

--
Paul


From: Dave Francis on 20 Mar 2007 04:10
David,

Is the file you are trying to open a genuine ADT file and/or index? Can you
open it using ADS ARC tool? I think I'm right in saying that if you use ADTs
remember that they can support field types that VO cannot. Are you checking
the validity of the handles that the ADS functions returns to you?

HTH

Dave Francis

"iDesmet" <idesmet.vom(a)gmail.com> wrote in message
news:1174353784.278579.51900(a)d57g2000hsg.googlegroups.com...
> Hello,
>
> As some of you already knows, I'm switching to ADS and currently using
> the sample application from Markus Lorenzi (good sample btw), but when
> I try to use the ADSADT.RDD Driver I got the following error:
>
> "Error 5018: The handle given was not recognized by Advantage. Verify
> specified handle is open/active. The given handle is not readable."
>
> This doesn't happen when I use the AXDBFCDX.RDD Driver. Looking at the
> Advantage Help I found only this:
>
> "Note to Advantage TDataSet Descendant users: If you are writing a
> multi-threaded application (for example, a Web application) it is
> possible to get this error if you have not uniquely named each
> TAdsConnection component. For further explanation and an example see
> the topic, Building Multi-Threaded Applications with TAdsQuery and
> TAdsTable in the Advantage TDataSet Descendant Help documentation
> (ADE.HLP). (Note that each of the Advantage products and their
> corresponding Help files are installed separately.)"
>
> But it doesn't apply for me.
>
> I've re-installed the following: "Advantage CA-Visual Objects RDDs",
> "Advantage Client Engine" and the "Advantage Data Architect" all are
> version 8.10.0.06, I've confirmed it also with the ADSVER.EXE tool
>
> Tried with Dependency Walker to see which VO dll's require the RDD's
> and it show me that it depends on VO27RUN.DLL so this is not a
> problem.
>
> As a note: I've the following files at the Bin directory of CAVO27:
>
> ace32.dll
> ads.ini
> adsadt.rdd
> adsloc32.dll
> adslocal.cfg
> ansi.chr
> axcws32.dll
> axdbfcdx.rdd
> axdbfntx.rdd
> extend.chr
>
> PS I also noted that if I want to try to open a DB using the
> ADSADT.RDD Driver in the DB Server Editor, I doesn't let me choose
> files with ADT extension, only DBF extension.
>
> Well, that's all I've tried and I don't have more ideas. So any
> suggestions would be welcome.
>
> Thanks in advance.
>
> Best Regards
> David Desmet
>


From: Joachim Duerr on 20 Mar 2007 06:29
iDesmet schrieb in
<1174353784.278579.51900(a)d57g2000hsg.googlegroups.com>:

> "Error 5018: The handle given was not recognized by Advantage. Verify
> specified handle is open/active. The given handle is not readable."

could you please show us some code and point to the line where you get
this error? You should check all return values of ADS Functions. If the
return value is != AE_SUCCESS (0), then check the help file for the
error code.
5018 could be the result if you connect to ADS (AdsConnect60), then set
the returned connection handle as being active for the workarea
(AX_SetConenctionHandle), disconnect (AdsDisconnect) and try to open a
table with that handle (AdsOpenTable).
Markus' dbServer uses all of these functions in the underlaying code.

--
Joachim D�rr
Sybase iAnywhere
AdvantageSupport[at]ianywhere.com
From: iDesmet on 20 Mar 2007 18:51
Paul,

No problem and thanks, I've just suscribed to advantage.visual_objects
newsgroup

Thanks again.


Dave,

I think I'm using a genuine ADT file and index. I can open it with the
ADS ARC tool. About the validity of the handles, I don't know.

I'm using the sample from Markus Lorenzi, you can download it from
here: http://www.voug-bodensee.net/Zip-Download/MigrationADS.zip

Thanks


Joachim,

You can find the code over here: http://www.voug-bodensee.net/Zip-Download/MigrationADS.zip

Thanks

 |  Next  |  Last
Pages: 1 2 3
Prev: Problem with 5333
Next: MS makes Foxpro OPEN-SOURCE.. interesting move