File or assembly name ADODB, was not found.

[KLomax]

I have a VB6 com object that uses ADO 2.1 for data access.
I have referenced this object in a aspx application.
It works fine on my local development machine.
On our staging server, it errors when trying to
instantiate the com object.
This object runs fine in another asp application on the
same box, so it is not the object itself.
I am remotely compiling the application on our staging
server.
The full error message is below.

Any ides ?


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

File name: "ADODB"
at Debt.DebtMan.CReceiptAndDisbursement.Load(String
ControlGroup, Int32 SecurityID, enuReportPeriod
ReportPeriod)
at Debt.Reports.Report_RandD() in \\tacsdev1
\Data\inetpub\SomeThingReporter\SomeThingReporter\Debt\Repo
rts.aspx.vb:line 313

Fusion log follows:
=== Pre-bind state information ===
LOG: DisplayName = ADODB, Version=7.0.3300.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
(Fully-specified)
LOG: Appbase =
file:///D:/inetpub/SomeThingReporter/SomeThingReporter
LOG: Initial PrivatePath = bin
Calling assembly : SomeThingReporter,
Version=1.0.1430.13864, Culture=neutral,
PublicKeyToken=null.
===

LOG: Publisher policy file is not found.
LOG: No redirect found in host configuration file
(C:\WINNT\Microsoft.NET\Framework\v1.0.3705\aspnet.config).
LOG: Using machine configuration file from
C:\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:///C:/WINNT/Microsoft.NET/Framework/v1.0.3705/Temporar
y ASP.NET
Files/SomeThingreporter/ed21083f/2075927f/ADODB.DLL.
LOG: Attempting download of new URL
file:///C:/WINNT/Microsoft.NET/Framework/v1.0.3705/Temporar
y ASP.NET
Files/SomeThingreporter/ed21083f/2075927f/ADODB/ADODB.DLL.
LOG: Attempting download of new URL
file:///D:/inetpub/SomeThingReporter/SomeThingReporter/bin/
ADODB.DLL.
LOG: Attempting download of new URL
file:///D:/inetpub/SomeThingReporter/SomeThingReporter/bin/
ADODB/ADODB.DLL.
LOG: Attempting download of new URL
file:///C:/WINNT/Microsoft.NET/Framework/v1.0.3705/Temporar
y ASP.NET
Files/SomeThingreporter/ed21083f/2075927f/ADODB.EXE.
LOG: Attempting download of new URL
file:///C:/WINNT/Microsoft.NET/Framework/v1.0.3705/Temporar
y ASP.NET
Files/SomeThingreporter/ed21083f/2075927f/ADODB/ADODB.EXE.
LOG: Attempting download of new URL
file:///D:/inetpub/SomeThingReporter/SomeThingReporter/bin/
ADODB.EXE.
LOG: Attempting download of new URL
file:///D:/inetpub/SomeThingReporter/SomeThingReporter/bin/
ADODB/ADODB.EXE.

 

[Bob Barrows]

I have a VB6 com object that uses ADO 2.1 for data access.
I have referenced this object in a aspx application.
It works fine on my local development machine.
On our staging server, it errors when trying to
instantiate the com object.
This object runs fine in another asp application on the
same box, so it is not the object itself.
I am remotely compiling the application on our staging
server.
The full error message is below.

Any ides ?


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

File name: "ADODB"
at Debt.DebtMan.CReceiptAndDisbursement.Load(String
ControlGroup, Int32 SecurityID, enuReportPeriod
ReportPeriod)
at Debt.Reports.Report_RandD() in \\tacsdev1
\Data\inetpub\SomeThingReporter\SomeThingReporter\Debt\Repo
rts.aspx.vb:line 313

Fusion log follows:
=== Pre-bind state information ===
LOG: DisplayName = ADODB, Version=7.0.3300.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
(Fully-specified)
LOG: Appbase =
file:///D:/inetpub/SomeThingReporter/SomeThingReporter
LOG: Initial PrivatePath = bin
Calling assembly : SomeThingReporter,
Version=1.0.1430.13864, Culture=neutral,
PublicKeyToken=null.
===

LOG: Publisher policy file is not found.
LOG: No redirect found in host configuration file
(C:\WINNT\Microsoft.NET\Framework\v1.0.3705\aspnet.config).
LOG: Using machine configuration file from
C:\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:///C:/WINNT/Microsoft.NET/Framework/v1.0.3705/Temporar
y ASP.NET
Files/SomeThingreporter/ed21083f/2075927f/ADODB.DLL.
LOG: Attempting download of new URL
file:///C:/WINNT/Microsoft.NET/Framework/v1.0.3705/Temporar
y ASP.NET
Files/SomeThingreporter/ed21083f/2075927f/ADODB/ADODB.DLL.
LOG: Attempting download of new URL
file:///D:/inetpub/SomeThingReporter/SomeThingReporter/bin/
ADODB.DLL.
LOG: Attempting download of new URL
file:///D:/inetpub/SomeThingReporter/SomeThingReporter/bin/
ADODB/ADODB.DLL.
LOG: Attempting download of new URL
file:///C:/WINNT/Microsoft.NET/Framework/v1.0.3705/Temporar
y ASP.NET
Files/SomeThingreporter/ed21083f/2075927f/ADODB.EXE.
LOG: Attempting download of new URL
file:///C:/WINNT/Microsoft.NET/Framework/v1.0.3705/Temporar
y ASP.NET
Files/SomeThingreporter/ed21083f/2075927f/ADODB/ADODB.EXE.
LOG: Attempting download of new URL
file:///D:/inetpub/SomeThingReporter/SomeThingReporter/bin/
ADODB.EXE.
LOG: Attempting download of new URL
file:///D:/inetpub/SomeThingReporter/SomeThingReporter/bin/
ADODB/ADODB.EXE.

 

[Bob Barrows]

I've never seen this message. You should ask in one of the public.dotnet
groups.

Bob Barrows

 

[Aaron Bertrand - MVP]

http://www.aspfaq.com/5002

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

 

[Tony Archer]

You may try checking the "Copy to Server" box for that object. That fixed
it for me a while ago when I had a similar problem.