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

[karenros]

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

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

[kleinma]

are you doing this in

VB.NET
VB6
VBA in Excel

??

[karenros]

I am doing this in VB.NET

[kleinma]

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.

[kleinma]

check out this MS link:

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

[karenros]

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

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

Thanks,
Karen