File or assembly name ADODB, or one of its dependencies, was not found.

Posted on 2005-04-28
Last Modified: 2008-01-09

I am having trouble in deploying web application. Development was done using,,MSSql AND  Crytal Report 10.0. I made a build to the development server and then move all aspx, rpt files and bin folder to the production server. Production server is running latest framework version and crystal report 10.


When I try to access the page which has the crystal report call, it gives following error.
File or assembly name ADODB, or one of its dependencies, was not found.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: File or assembly name ADODB, or one of its dependencies, was not found.

Assembly Load Trace: The following information can be helpful to determine why the assembly 'ADODB' could not be loaded.

Stack Trace:

[FileNotFoundException: File or assembly name ADODB, or one of its dependencies, was not found.]
   CrystalDecisions.CrystalReports.Engine.ReportDocument.(Object C) +0
   CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSource(Object dataSet) +21
   nyclaw.comps.web.IEYearlyForm.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\nyclaw.comps_4_1\IEYearlyForm.aspx.vb:78
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +750


ANYONE has any idea?
Question by:rpatoriya
    LVL 9

    Expert Comment

    Well, it sounds like your production server is missing adodb.dll.  It's odd though, because the error is actually being thrown by CrystalReports and you claim the production server has CR 10 installed (which should have included adodb.dll)

    I'd try copying adodb.dll from C:\Program Files\Microsoft.Net\Primary Interop Assemblies\ on your dev machine to the /bin/ directory of your application on the production machine.

    Author Comment

    It worked!!!! I really really appreciate your timely answer.  

    How do you know that - that one particular file was missing?

    AND - why do I have to put it manually that file under bin folder? Isn't that, should add to the reference automatically like all other dlls??
    if this is a required dll for our solution, why did it compile without being referenced?

    I have 5-more web application to move to the server - do I have to do this with each and every web application which uses crystal report?

    Any suggestion?

    LVL 9

    Expert Comment

    Well, I knew the file was missing because that's what the error message said: "File or assembly name ADODB, or one of its dependencies, was not found."  I just know that the namespace ADODB is contained within adodb.dll.

    The reason you have to put it in the /bin/ directory is because that is one of the first places the application looks when it can't find an assembly it needs.  You could also put it a number of different places.

    The reason VS.NET didn't add the reference could be a number of reasons.  First, it could have not cared because on your development machine the assembly was in the GAC and it figured any other machine would have it there too.  The other reason could be because it wasn't directly referenced by your application; it was referenced by an assembly your application referenced (Crystal Reports).

    Check out this knowledge base article; it might help you figure out how to make sure the other machines get the assembly:;en-us;321688
    LVL 9

    Accepted Solution

    Since it appears I answered the question I suggest awarding the points to me.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
    ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now