ActiveX Data Objects 2.7 ADODB.dll 7.0.3300.0 version in GAC vs. Add Reference

[Tom McMillan]

For Exchange SDK you can download a sample event sink written in
VB.NET.
This solution, HHContactsEventSink2, written by Quadrus, has a
reference to
ADODB (all capital letters). The reference properties show a path
like:
C:\WINNT\assembly\GAC\ADODB\7.0.3300.0_....
I built a C# project that references adodb. I used the Add Reference
dialog box. The properties for that reference show this path:
C:\Program Files\Microsoft.NET\Primary Interop Assemblies\adodb.dll.
If I look at the GAC, I do have ADODB in there, but of course I cannot
reference
it directly. Can anyone explain what is going on here. Do I need to
add something in my registry if I want the path for ADODB to point to
the GAC?

Thanks
Tom McMillan

[Tom McMillan]

tmcm...@amb.com (Tom McMillan) wrote in message news:<6ec6b8dc.03021...@posting.google.com>...

Figured out the answer:
If you go to the COM tab of the Add Reference dialog box in Visual
Studio.NET,
and add a reference to Microsoft ActiveX Data Objects 2.7 Library,
behind
the scenes, the PIA is automatically referenced, and your reference
properties
then show the path like C:\WINNT\assembly\GAC\ADODB\7.0.3300.0_....
So that explains the behavior, would still be interested how this
works if
you know.
BTW: 'Can't open ADO recordset in C#' posting of Thomas Zueger has a
good example of using 'Type.Missing' to fill in optional parameters in
ADO commands.

Thanks
Tom McMillan