using rdo in C#

[pcPirate]

Hi,

 

I'm currently writing an application using C#. However, to access and update a database, I must only use rdo (due to a certain reason). I heard I can use the VB6 to make the function of accessing and updating the database and then, compile it into dll. After that, using the C#, adding the reference of the dll, I would be able to access or update the database.

 

Q1) Is this true?

Q2) If so, how do I do that? Can anybody share some codes about this?

 

Thanks in advance

pcPirate

[Derek Stone]

Yes. Compile the DLL in Visual Basic 6 and add it as a COM reference in your .NET project.

[pcPirate]

Okay, thanks for your opinion. I really appreciate that.

 

However, frankly, I'm not familiar with the ActiveX DLL thing. Just wanna ask some simple question.

 

In VB6. Is the ActiveX DLL coding is just the same when we make the .exe ?

 

In ActiveX DLL, can we make function that receive parameters, so that we can use it in C# when I add the reference.

 

Thanks in advance,

pcPirate

[Derek Stone]

Yes to both of your questions. The coding is the same and you can pass parameters and return values.

[pcPirate]

Ya, ya, I think i've got the whole picture.

 

I've tried two ways:

 

i) doing the rdo connection stuffs in VB6 and compile into .dll, then, add it in the .net reference

 

ii) This is different, I add the reference "Microsoft Remote Data Object 2.0". However, a big headache happened cos' the way of the statement presented is totally different in .net and there's really no other example regarding the rdo in .net. (Since Microsoft doesn't really care about the rdo anymore)

 

pcPirate.

[Nerseus]

So you could use RDO from within .NET? I'm unclear as to why you'd have to use RDO then, if you're not forced to use an RDO Resultset from an outside source and you haven't mentioned passing the Resultset on to anything else.

 

There are TONS of resources on using RDO, by the way. Search google for RDO Resultset for instance. The objects, methods, and such are the same.

 

-Ner

[pcPirate]

Haha,

 

It's true that I've been forced to use rdo. Frankly, rdo is slow (due to the resultSet) and I would absolutely won't use it unless I've been forced to. It's something related to the old source code to connect to a application database and there's no more other way than to use just rdo :)

 

Well, there're sure a lot of rdo example but you can't find one relating rdo to C#.

 

pcPirate