Re: Passing an ADO recordset using remoting

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


How do you use remoting between VB6 and VB.Net ? ,,,,,, i believed you could
only use remoting between .Net apps



"WayneB" <WayneB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F55BE192-509D-433F-82F2-941B97186527@xxxxxxxxxxxxxxxx
> Hi
>
> I have inherited an existing Windows application written in VB6 with all
> UI,
> BL, DL embedded in the one app. I am intending to move some of the
> functionality from the VB6 client app to a central server so that it may
> be
> accessed by both the client app and a web app. The problem is that the
> client
> app utilises a lot of data and being written in VB6 this means ado and
> recordsets.
>
> I have created a server component to return a disconnected recordset (not
> a
> dataset) to the client using TCP remoting. However, when I try to bind
> this
> to a VB6 datagrid I get a "type mismatch" exception. Converting the
> recordset
> to a binary stream (using ado stream) on the server, passing this using
> remoting, and re-constructing as a recordset on the client machine works
> fine
> but obviously incurs the overhead of the save/load from the stream (approx
> 1
> sec on each load and save when tested with 10K records)
>
> Is it actually possible to pass the disconnected recordset directly using
> remoting or am I stuck with converting to a binary stream first.
>
> I would be grateful for any thoughts on this
>
> Thanks
>
> Wayne


.

Relevant Pages

  • Re: .NET interop and using remoting
    ... App with your applications name. ... This doesnt help for debugging because it seems that vb6 compiles on the fly ... I have debuged remarking parts of the remoting component code, ...
    (microsoft.public.dotnet.framework.interop)
  • Re: Problems with SELECT from JOIN
    ... I had searched the Help file for "Null" both in VB6 ... the exact syntax to use. ... from an app where I use "." ... >> the recordset name from the field names: ...
    (microsoft.public.vb.database)
  • Re: VB6, CR8.5 Designer / Mail Labels, Change Start Position, Across then Down
    ... addresses information inorder to skip to the correct label position. ... Our app uses VB6 to create a recordset to pass to Crystal reports. ...
    (microsoft.public.vb.crystal)
  • Select Count(*) question
    ... In VB6 I have this code for returning data to a recordset via 2 ... Thinking I could just copy the code from VB6 to Access 2003, ... But in my Access app, I found I cannot use "rs!results". ... My select count yields 1 row here too, but I need to return the results ...
    (comp.databases.ms-access)
  • Re: Dotnet versus Java-Applets
    ... from real deployed experience I think putting the browser in the ... Remoting. ... I took over a very mature VB6 app used concurrently by 40+ users on both ... > ClickOnce deployment technology. ...
    (microsoft.public.dotnet.faqs)