What class should i import in order to use ADODB.Stream

Hi..
I want transfer a image from my excel spreadsheet to a web server and i have written a web services so that it accepts a filename and then dumps it into web server.. if i just called that code in vb it works fine... but when i run the service it doesnt work.. this is the error that i am getting

System.Web.HttpException: The component 'ADODB.STREAM' cannot be created. Apartment threaded components can only be created on pages with an <%@ Page aspcompat=true %> page directive.
at System.Web.Util.AspCompatApplicationStep.CheckThreadingModel(String progidDisplayName, Guid clsid)
at System.Web.HttpServerUtility.CreateObject(String progID)
at MyService.Service1.getFileBytes(String flnm, String stype) in C:\Documents and Settings\user\My Documents\Visual Studio 2005\Projects\MyService\MyService\Service1.asmx.vb:line 31
at MyService.Service1.Sendit(String sFilename, String Stype) in C:\Documents and Settings\user\My Documents\Visual Studio 2005\Projects\MyService\MyService\Service1.asmx.vb:line 21
at MyService.Service1.UploadFile(String Filename, String sType) in C:\Documents and Settings\User\My Documents\Visual Studio 2005\Projects\MyService\MyService\Service1.asmx.vb:line 16


and this is my code

Code:

---

Public Function getFileBytes(ByVal flnm As String, ByVal stype As String)
        Dim objstream As Object
        objstream = Server.CreateObject("ADODB.STREAM")
        If stype = "on" Then
            objstream = 1
        End If
        objstream.open()
        objstream.LoadFromFile(flnm)

        If stype = "on" Then
            getFileBytes = objstream.Read
        Else
            getFileBytes = objstream.ReadText
        End If
        objstream.Close()
        objstream = Nothing


    End Function

---

Any help will be appreciated..
Thanks,
Karen

are you doing this in

VB.NET
VB6
VBA in Excel

??

I am doing this in VB.NET

Sorrry, I think I misread, from the error message, it looks to me you are using VS2005.

I think the actual REASON for the exception is outlined pretty clearly though:

The component 'ADODB.STREAM' cannot be created. Apartment threaded components can only be created on pages with an <@ Page aspcompat=true> page directive.

ADODB is an old COM object from old ADO. If you are using .NET, it may be easier to use the actual built in ADO.NET data classes.

check out this MS link:

http://msdn.microsoft.com/en-us/library/zwk9h2kb.aspx

But i am using the ADODB.Stream in a Webservice and i am getting an error that says
Attribute Page is not a valid element of webservice... and the aspCompat attribute is not supported by the Page attribute...
this is what i have done in my .asmx page

Code:

---

<%@ WebService Language="VB" CodeBehind="Service1.asmx.vb" Class="MyService.Service1" %>
<%@ Page AspCompat = "true"  Language ="VB" %>

---

Thanks,
Karen