Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2021
  • Last Modified:

How do I add Interop.ADODB?

I have written the following code.


        Dim iMail As CDO.Message
        Dim iConf As CDO.Configuration
        Dim iFlds As ADODB.Fields
        set iMail = New CDO.Message
        set iConf = New CDO.Configuration
        set iFlds = iConf.Fields

Everything is fine until I get to "set iFlds = iConf.Fields".  Then I get a "Reference required to assembly 'Interop.ADODB' containg the type 'ADODB.Fields'. Add one to your project"

I have a reference to ADODB and CDO already added to my sln.  I am not for sure what they want me to do.



0
Richard Comito
Asked:
Richard Comito
  • 3
  • 3
1 Solution
 
micaiahCommented:
Are you referencing the COM version of adodb? Try referencing the .NET adodb dll. Or better yet, add a reference to System.Web.Mail and use a System.Web.Mail.MailMessage vs. CDO.

0
 
Richard ComitoDirector of ITAuthor Commented:
I was able to to get it to add the Interop.ADODB by adding the reference of Microsoft CDO for Windows 200 Library.  Instead of the Microsoft CDO 1.21 Library.

What is the difference between the CDO over the System.Web.Mail.MailMessage?
0
 
micaiahCommented:
They actually use the same underlying system calls, IIRC, but with System.Web.Mail being a native part of the .NET framework, it's likely to be better supported than the CDO wrappers in coming days. Additionally, if you're already referencing the framework's System.Web dll for anything else, you'll save a little memory vs. loading another dll.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Richard ComitoDirector of ITAuthor Commented:
I am using CDO for the scalability of the object.  I am building a List Serv that will be relying and authenticating through an Exchange server.  From what I can see System.Web.mail does not have that same scalability. Am I just looking at the wrong info or would you suggest some other object?

Thanks for your help.
0
 
micaiahCommented:
Yeah, sorry - the CDOSYS library is way to go for exchange.
0
 
Richard ComitoDirector of ITAuthor Commented:
No sweat.  At least now I know I am on the right track.  Thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now