using rdo in C#

[pcPirate]

Hi,

Im 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, Im 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 ive got the whole picture.

Ive 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 theres really no other example regarding the rdo in .net. (Since Microsoft doesnt really care about the rdo anymore)

pcPirate.

 

[Nerseus]

So you could use RDO from within .NET? Im unclear as to why youd have to use RDO then, if youre not forced to use an RDO Resultset from an outside source and you havent 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,

Its true that Ive been forced to use rdo. Frankly, rdo is slow (due to the resultSet) and I would absolutely wont use it unless Ive been forced to. Its something related to the old source code to connect to a application database and theres no more other way than to use just rdo

Well, therere sure a lot of rdo example but you cant find one relating rdo to C#.

pcPirate