ExamGuru IT/.Net Guru : ADO Error when trying to run Webservice on ASPFriends.com 'aspngmigrate' list

.NETGURU

ADO Error when trying to run Webservice

Messages

Related Types

This message was discovered on ASPFriends.com 'aspngmigrate' list.

Alwin Jeyakumar

-- Moved from [aspngwebservices] to [aspngmigrate] by Michiel van Otegem <Click here to reveal e-mail address> --

Hello All,
I am developing a web service to expose all our Online Repair
functionality. A function calls a method in a COM component and the COM
component returns back a recordset. (ADODB recordset). This method is
working fine in my development machine. But when I try to run this method of
the webservice in the Production machine (which has just the .NET runtime
and MDAC latest version), I am getting the following error :
"File or assembly name ADODB, or one of its dependencies, was not found."
I tried installing the new version of MDAC again and still it didn't work.
If anyone knows why this is happening, please let me know. It would be a
great help for me.
Thanks a lot.
Have a Nice Day !!!
Alwin

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

Reply to this message...

Michiel van Otegem

This means .NET can't find the Interop Assembly to work with the old version
of ADO. You can do three things:
-Migrate your code fully to .NET (including ADO.NET)
-Copy the wrapper assembly from Primary Interop Assemblies to the bin
directory of your App
-Create a wrapper assembly for the ado15 DLL using tlbimp. That DLL sits in
Program Files/Common Files/System/ADO.

---
Michiel van Otegem
ASPFriends.com Moderation Team

ASPNL.com - ASP/ASP.NET/XML Teacher
http://www.aspnl.com
http://www.aspalliance.com/michiel
---
Teach Yourself XSLT in 21 Days
http://www.amazon.com/exec/obidos/ASIN/0672323184/aspnlcom-20
"Alwin Jeyakumar" <Click here to reveal e-mail address> wrote in message
news:613141@aspngmigrate...
[Original message clipped]

Reply to this message...

Alwin Jeyakumar

Thanks a lot Michiel.
I tried the 2nd option and it worked.

Alwin

[Original message clipped]

_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com

Reply to this message...

Paul Litwin

That's the same problem I recently encountered (and you and I discussed)
and I discovered that #2 solved it but this still doesn't sound right.
I'd like to know why ASP.NET can't find the primary interop assembly. I
mean that's what's supposed to happen.

Paul
=========================
Paul Litwin
Principal, Deep Training
Editor-in-Chief, asp.netPRO Magazine

mailto:Click here to reveal e-mail address
http://www.deeptraining.com
http://www.aspnetpro.com
=========================

-----Original Message-----
From: Michiel van Otegem [mailto:Click here to reveal e-mail address]
Sent: Tuesday, March 12, 2002 7:27 AM
To: aspngmigrate
Subject: [aspngmigrate] Re: ADO Error when trying to run Webservice

This means .NET can't find the Interop Assembly to work with the old
version of ADO. You can do three things: -Migrate your code fully to
.NET (including ADO.NET) -Copy the wrapper assembly from Primary Interop
Assemblies to the bin directory of your App -Create a wrapper assembly
for the ado15 DLL using tlbimp. That DLL sits in Program Files/Common
Files/System/ADO.

---
Michiel van Otegem
ASPFriends.com Moderation Team

ASPNL.com - ASP/ASP.NET/XML Teacher
http://www.aspnl.com
http://www.aspalliance.com/michiel
---
Teach Yourself XSLT in 21 Days
http://www.amazon.com/exec/obidos/ASIN/0672323184/aspnlcom-20
"Alwin Jeyakumar" <Click here to reveal e-mail address> wrote in message
news:613141@aspngmigrate...
[Original message clipped]

| [aspngmigrate] member Click here to reveal e-mail address = YOUR ID
| http://www.asplists.com/asplists/aspngmigrate.asp = JOIN/QUIT

Reply to this message...

Chad Urvig

I had the same problem and I found another option (using Visual Studio). On the properties of the ADODB reference, set Copy Local to True. This will make a copy of the adodb.dll in your bin directory and it will be included when you move the application from server to server.

Chad

Reply to this message...

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification