|
| Problem with using ado in .net asp |
|
|
|
|
| Messages |
|
Related Types |
This message was discovered on microsoft.public.vsnet.general.
| Tobiasz |
| GOOD ANSWER |
I'm tryin to use cdo. when i add references to cdo in .net application vs.net adding me adodb too. when i compile this page i've got this error my .net server is on another machine.
Server Error in '/gus' Application. ---------------------------------------------------------- ----------------------
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.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Assembly Load Trace: The following information can be helpful to determine why the assembly 'ADODB' could not be loaded.
=== Pre-bind state information === LOG: DisplayName = ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a (Fully-specified) LOG: Appbase = file:///D:/Inetpub/wwwroot/gus LOG: Initial PrivatePath = bin Calling assembly : gus, Version=1.0.1028.14158, Culture=neutral, PublicKeyToken=null. ===
LOG: Publisher policy file is not found. LOG: No redirect found in host configuration file (D:\WINNT\Microsoft.NET\Framework\v1.0.3705 \aspnet.config). LOG: Using machine configuration file from D:\WINNT\Microsoft.NET\Framework\v1.0.3705 \config\machine.config. LOG: Post-policy reference: ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a LOG: Attempting download of new URL file:///D:/WINNT/Microsoft.NET/Framework/v1.0.3705/Tempora ry ASP.NET Files/gus/202febc7/975a58e0/ADODB.DLL. LOG: Attempting download of new URL file:///D:/WINNT/Microsoft.NET/Framework/v1.0.3705/Tempora ry ASP.NET Files/gus/202febc7/975a58e0/ADODB/ADODB.DLL. LOG: Attempting download of new URL file:///D:/Inetpub/wwwroot/gus/bin/ADODB.DLL. LOG: Attempting download of new URL file:///D:/Inetpub/wwwroot/gus/bin/ADODB/ADODB.DLL. LOG: Attempting download of new URL file:///D:/WINNT/Microsoft.NET/Framework/v1.0.3705/Tempora ry ASP.NET Files/gus/202febc7/975a58e0/ADODB.EXE. LOG: Attempting download of new URL file:///D:/WINNT/Microsoft.NET/Framework/v1.0.3705/Tempora ry ASP.NET Files/gus/202febc7/975a58e0/ADODB/ADODB.EXE. LOG: Attempting download of new URL file:///D:/Inetpub/wwwroot/gus/bin/ADODB.EXE. LOG: Attempting download of new URL file:///D:/Inetpub/wwwroot/gus/bin/ADODB/ADODB.EXE.
Stack Trace:
[FileNotFoundException: File or assembly name ADODB, or one of its dependencies, was not found.] gus._default3.Page_Load(Object sender, EventArgs e) +0 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +29 System.Web.UI.Page.ProcessRequestMain() +724
---------------------------------------------------------- ---------------------- Version Information: Microsoft .NET Framework Version:1.0.3705.288; ASP.NET Version:1.0.3705.288
|
|
|
| |
|
|
| |
| |
| Dan |
| GOOD ANSWER |
Tobiasz, Am I correct that VS is not installed on your web server? That shouldn't be necessary, but what I believe is happening is that on your local machine, ADODB.dll is in your global assembly cache (GAC - think system32 folder for ..net), so when you build your project, VS believes it does not need to be copied into your output folder. In fact, your output folder is on the web server, which in this case does not have ADODB.dll in its GAC (because the dll is installed with VS.NET, and not with just the .NET redistribution which is all you have on your server). I've verified that this issue is logged in our development database. In the meantime, you will need to manually make the dll available to your project. Probably it will be sufficient to just copy adodb.dll (it's in C:\Program Files\Microsoft.Net\Primary Interop Assemblies on your development machine) to the same folder as your binary on your web server (ie, the bin folder in your web app folder on the server).
Let us know whether this fixes your issue. Dan (VS Core Team)
-- This posting is provided "AS IS" with no warranties, and confers no rights. "Tobiasz" <Click here to reveal e-mail address> wrote in message news:d4ac01c27c0d$b89e0ce0$36ef2ecf@tkmsftngxa12... [Original message clipped]
|
|
|
| |
|
|
| |
| |
| FERHAT KARATAS |
| GOOD ANSWER |
Hi.. thank u this is good job! i've solved my problem with your explaination
-------------------------------- From: FERHAT KARATAS
|
|
|
| |
|
|
| |
|
| |
| kathryn eanonymous |
| GOOD ANSWER |
yep copying adodb.dll to the Bin folder of the web application worked for me too. Good job Dan!
-------------------------------- From: kathryn eanonymous
|
|
|
| |
|
|
| |
|
|
| |
| Dan |
| GOOD ANSWER |
In case it helps: if you ship your app with a setup project, Q321688 describes how to make sure your customers get the adodb.dll which they won't have in their .net redistribution. Dan (VS Core Team) -- This posting is provided "AS IS" with no warranties, and confers no rights. "Tobiasz" <Click here to reveal e-mail address> wrote in message news:d4ac01c27c0d$b89e0ce0$36ef2ecf@tkmsftngxa12... [Original message clipped]
|
|
|
| |
|
|
| |
| |
| carrie kristapsons |
| GOOD ANSWER |
I don't know if it helped tobiasz, but it helped me. Thanks!
-------------------------------- From: carrie kristapsons
|
|
|
| |
|
|
| |
|
|
|
|
|
|
|
|
|
BootFX
Reliable and powerful .NET application framework. |
|
|
|
|
|
|