Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / Web Services / March 2005

Tip: Looking for answers? Try searching our database.

.NET WebServices Newbie Compilation Error!  (imports adodb)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Adam Short - 23 Mar 2005 12:21 GMT
I am trying to use the ADODB functionality of a legacy ASP RecordSet.  Why
you may ask, I have my reason's, I will reply!

I have read all over the Net how easy it is to use Visual Studio to do this,
I do not have this luxury!  What are the lines of code I need to use to to
do the equivilent of registering the component?
Compilation Error
Description: An error occurred during the compilation of a resource required
to service this request. Please review the following specific error details
and modify your source code appropriately.

Compiler Error Message: BC30466: Namespace or type 'adodb' for the Imports
'adodb' cannot be found.

Source Error:

Line 9:  imports system.data
Line 10: imports system.data.odbc
Line 11: imports adodb

Regards

Adam
Signature

Phuture-UK +44 (01202) 518122

Manohar Kamath - 23 Mar 2005 13:58 GMT
You will need to add a reference to ADODB library. Do a "Add Reference"..
click on the "COM" tab, and select ADODB library. Hope that helps.

Signature

Manohar Kamath
Editor, .netWire
www.dotnetwire.com

> I am trying to use the ADODB functionality of a legacy ASP RecordSet.  Why
> you may ask, I have my reason's, I will reply!
[quoted text clipped - 19 lines]
>
> Adam
Adam Short - 23 Mar 2005 14:28 GMT
I don't have Visual Studio!!!

Anyway, an adodb.dll file is available for download, by including the
following line of code you can manipulate recordsets

<%@ Assembly name="adodb" %>

> You will need to add a reference to ADODB library. Do a "Add Reference"..
> click on the "COM" tab, and select ADODB library. Hope that helps.
[quoted text clipped - 28 lines]
>>
>> Adam
Manohar Kamath - 23 Mar 2005 17:06 GMT
well... you need to first create an interop library for ADODB (I think it is
msado15.dll).

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cptools/html/cp
grftypelibraryimportertlbimpexe.asp


Doing so, you are creating assemblies that can be "understood" by .NET. They
are mere wrappers that call into the actual COM component.

Second, copy this assembly in your bin folder of Web app. You don't need the
@Assembly directive in that case. Hope that works.

Signature

Manohar Kamath
Editor, .netWire
www.dotnetwire.com

> I don't have Visual Studio!!!
>
[quoted text clipped - 35 lines]
> >>
> >> Adam
Manohar Kamath - 23 Mar 2005 17:15 GMT
Forgot... MS ships adodb primary interops, check in the folder:

c:\Program Files\Microsoft.NET\Primary Interop Assemblies\adodb.dll

Signature

Manohar Kamath
Editor, .netWire
www.dotnetwire.com

> well... you need to first create an interop library for ADODB (I think it is
> msado15.dll).

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cptools/html/cp
grftypelibraryimportertlbimpexe.asp


> Doing so, you are creating assemblies that can be "understood" by .NET. They
> are mere wrappers that call into the actual COM component.
[quoted text clipped - 42 lines]
> > >>
> > >> Adam
Adam Short - 23 Mar 2005 18:37 GMT
Excellent, found it ADOVB.DLL.

> Forgot... MS ships adodb primary interops, check in the folder:
>
[quoted text clipped - 57 lines]
>> > >>
>> > >> Adam

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.