How to Inherit ADODB?

2 Mar 2006 12:17 PM

Venkatesh M.

Hi Everybody,
I am working on a Project which is first developed in VB6.0 (IIS
Application) and now it is converted to .NET . We are using a logging all the
Querys in a log file using our own class. I have to find all the querys used
in the application and have to write the line to log. It is a time consuming
thing. I tried to inherit ADODB Class so that I can override the execute
function and use the logging function there. It is a simple thing if it is
possible.
Please help me to,
1. Inherit ADODB Class (mainly Connection)
2. If not possible, give me a solution

Thanks in Advance,

--
Venkatesh M.
Eagle Consulting,
Chennai, India
Phone: 91 - 44 - 24917981 x 108

2 Mar 2006 1:02 PM

Michael Nemtsev

It's "Microsoft ActiveX Data Objects 2.8 Library" in AddReferences/COM tab

after that use code below to gain access to this library
using ADODB;

Show quote

> I am working on a Project which is first developed in VB6.0 (IIS
> Application) and now it is converted to .NET . We are using a logging all the
> Querys in a log file using our own class. I have to find all the querys used
> in the application and have to write the line to log. It is a time consuming
> thing. I tried to inherit ADODB Class so that I can override the execute
> function and use the logging function there. It is a simple thing if it is
> possible.
> Please help me to,
> 1. Inherit ADODB Class (mainly Connection)
> 2. If not possible, give me a solution

--
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

2 Mar 2006 1:03 PM

Kevin Spencer

You would be best off to convert all of the ADODB functionality to ADO.Net
functionlaity. ADODB is COM, and COM does not particularly mix well with
..Net.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
A brute awe as you,
a Metallic hag entity, eat us.

Show quote

"Venkatesh M." <venkate***@eagle-india.com> wrote in message
news:5A0E420A-4032-407D-A586-293D19D1177C@microsoft.com...
> Hi Everybody,
> I am working on a Project which is first developed in VB6.0 (IIS
> Application) and now it is converted to .NET . We are using a logging all
> the
> Querys in a log file using our own class. I have to find all the querys
> used
> in the application and have to write the line to log. It is a time
> consuming
> thing. I tried to inherit ADODB Class so that I can override the execute
> function and use the logging function there. It is a simple thing if it is
> possible.
> Please help me to,
> 1. Inherit ADODB Class (mainly Connection)
> 2. If not possible, give me a solution
>
> Thanks in Advance,
> --
> Venkatesh M.
> Eagle Consulting,
> Chennai, India
> Phone: 91 - 44 - 24917981 x 108