Very Computer

by **news at microsof** » Mon, 31 May 1999 04:00:00

Hi all,
i was tring to send a MSMQ message containg a recordset object and it works,
the recordset was actually persisted, but when i tried to do the same to a
Hierarchchal Recordset the Father Recordset passed ok, but the child
recordsets didnt.

is this a bug in the recordset object ?
did i do something wrong ?

what i was realy tring to do is pass 4 recordset's in a single message , and
i thought that if i grouped them togheter to one Hierarchchal recordset it
would work, but since it didnt , if anyone has any idea's about how to do
that (transfering the 4 recordsets) i will be very happy to hear from you.

Nave Ronen

by **Paul Adamso** » Mon, 31 May 1999 04:00:00

I don't know if hierarchical recordsets can be persisted, but I solved this
problem by sending a bunch of individual recordsets within an MSMQ
transaction, which guarantees arrival order.

Paul Adamson

> Hi all,
> i was tring to send a MSMQ message containg a recordset object and it
works,
> the recordset was actually persisted, but when i tried to do the same to a
> Hierarchchal Recordset the Father Recordset passed ok, but the child
> recordsets didnt.

> is this a bug in the recordset object ?
> did i do something wrong ?

> what i was realy tring to do is pass 4 recordset's in a single message ,
and
> i thought that if i grouped them togheter to one Hierarchchal recordset it
> would work, but since it didnt , if anyone has any idea's about how to do
> that (transfering the 4 recordsets) i will be very happy to hear from you.

> Nave Ronen

by **jon-slem sever** » Tue, 01 Jun 1999 04:00:00

One easy way to take care of this to use VB propertyBag.
Add 4 properties to the propertybag and set each property's value to one
of the
recordset, of course in the backend when you are opening the propertybag
you must
know the name of each property and the value each has..

Jon-Slem

> Hi all,
> i was tring to send a MSMQ message containg a recordset object and it works,
> the recordset was actually persisted, but when i tried to do the same to a
> Hierarchchal Recordset the Father Recordset passed ok, but the child
> recordsets didnt.

> is this a bug in the recordset object ?
> did i do something wrong ?

> what i was realy tring to do is pass 4 recordset's in a single message , and
> i thought that if i grouped them togheter to one Hierarchchal recordset it
> would work, but since it didnt , if anyone has any idea's about how to do
> that (transfering the 4 recordsets) i will be very happy to hear from you.

> Nave Ronen

jsevere.vcf
< 1K Download

by **Nave Rone** » Tue, 01 Jun 1999 04:00:00

i dont think you can add an object to a propertybag as a property,
your suppose to convert it to a string, dont you ?

> One easy way to take care of this to use VB propertyBag.
> Add 4 properties to the propertybag and set each property's value to one
> of the
> recordset, of course in the backend when you are opening the propertybag
> you must
> know the name of each property and the value each has..

> Jon-Slem

> > Hi all,
> > i was tring to send a MSMQ message containg a recordset object and it
works,
> > the recordset was actually persisted, but when i tried to do the same to
a
> > Hierarchchal Recordset the Father Recordset passed ok, but the child
> > recordsets didnt.

> > is this a bug in the recordset object ?
> > did i do something wrong ?

> > what i was realy tring to do is pass 4 recordset's in a single message ,
and
> > i thought that if i grouped them togheter to one Hierarchchal recordset
it
> > would work, but since it didnt , if anyone has any idea's about how to
do
> > that (transfering the 4 recordsets) i will be very happy to hear from
you.

> > Nave Ronen

by **Paul Adamso** » Tue, 01 Jun 1999 04:00:00

Mr. Severe's description of property bag use is correct. This is how you
persist objects in MSMQ. It doesn't, however, work with persisted
recordsets. It seems like there are additional underlying interfaces of the
recordset that are not exposed and that are required.

Paul Adamson

> i dont think you can add an object to a propertybag as a property,
> your suppose to convert it to a string, dont you ?

> > One easy way to take care of this to use VB propertyBag.
> > Add 4 properties to the propertybag and set each property's value to one
> > of the
> > recordset, of course in the backend when you are opening the propertybag
> > you must
> > know the name of each property and the value each has..

> > Jon-Slem

> > > Hi all,
> > > i was tring to send a MSMQ message containg a recordset object and it
> works,
> > > the recordset was actually persisted, but when i tried to do the same
to
> a
> > > Hierarchchal Recordset the Father Recordset passed ok, but the child
> > > recordsets didnt.

> > > is this a bug in the recordset object ?
> > > did i do something wrong ?

> > > what i was realy tring to do is pass 4 recordset's in a single message
,
> and
> > > i thought that if i grouped them togheter to one Hierarchchal
recordset
> it
> > > would work, but since it didnt , if anyone has any idea's about how to
> do
> > > that (transfering the 4 recordsets) i will be very happy to hear from
> you.

> > > Nave Ronen

by **Jeff Dunmal** » Tue, 01 Jun 1999 04:00:00

Nave,

Quote:>what i was realy tring to do is pass 4 recordset's in a single message ,
and
>i thought that if i grouped them togheter to one Hierarchchal recordset it
>would work, but since it didnt , if anyone has any idea's about how to do
>that (transfering the 4 recordsets) i will be very happy to hear from you.

Another idea: you could try persisting the recordset as XML (using the save
method), send the text across, and reconstruct the recordset on the other
side.

Jeff Dunmall

iMason.com - We build things that work

by **David Goldstei** » Wed, 02 Jun 1999 04:00:00

If you are interested in components that encapsulate persistence interfaces
(plus many persistent collections), check out my website
(http://www.idcsoftware.com/data_tools_alpha.htm )
and contact me via the link on that page if these components may suit your
needs.

These work quite well with MSMQ messages, and may offer more useful options
than would be had with a property bag.... there's no magic here, it won't
fix the hierarchical recordset problem.

- Dave G.

by **Nave Rone** » Fri, 04 Jun 1999 04:00:00

Hi All,

I've installed the ADO 2.1 and it solved the problem.
so thank's to everyone that tried to help me.

Very Computer

msmq and ado recordset persistance

msmq and ado recordset persistance

msmq and ado recordset persistance

msmq and ado recordset persistance

msmq and ado recordset persistance

msmq and ado recordset persistance

msmq and ado recordset persistance

msmq and ado recordset persistance

msmq and ado recordset persistance