Help! I have a VB6/Soaptoolkit3.0/Sql reports issue

Question

Help! I have a VB6/Soaptoolkit3.0/Sql reports issue

Paul Mauriello

Valued Member

Points: 60
More actions
May 11, 2005 at 9:03 am

#164432

I am trying to retro fit Sql Reports in my VB6 app. Now i have a dynamic RDL Generator that assembles the .RDL and writes it out to a file. That part works fine. The next step I'm getting stuck on is the SOAP part to deploy it to the reportserver. I have scoured the internet but there isn't a lot of help out there because everyone is jumping off the VB6 boat, so here I am. I have this so far:

        'Use SOAP API to deploy reports to server
        Dim oSoapClient As MSSOAPLib30.SoapClient30
        Set oSoapClient = Nothing
        Set oSoapClient = New MSSOAPLib30.SoapClient30
        Call oSoapClient.MSSoapInit("http://servername/reportserver/reportservice.asmx?wsdl")

That part executes fine with out error

Now when I start to reference things like oSoapClient.url or oSoapClient.createdatasource i get "Object doesn't support this property or method"

Is there something I am leaving out? Am I missing a step?

Any help would be appreciated.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

ChrisMoix-87856 SSCertifiable Points: 7288 More actions · Answer 1

I don't know enough VB6 to help you out with specifics, but I know that the Hitchhiker's Guide to SQL Server 2000 Reporting Services book includes examples for deploying and manipulating reports via the SOAP interface. Take a look at the book or check their website (http://www.sqlreportingservices.net/) and maybe they will have more info there.

Paul Mauriello Valued Member Points: 60 More actions · Answer 2

I have that book and it's my bible for this, however it doesn't go into VB6 and using the SOAPToolKit 3.0 just the .NET stuff. But thanks anyway for your reply.

I have the .NET version of this working perfectly it's just the VB6/SOAPToolKit 3.0 part that I am getting stuck on.

Paul Mauriello Valued Member Points: 60 More actions · Answer 3

I have played around with the idea that the SQL 2000 Reporting services file "reportservice.wsdl" needs to be in the VB6 references somehow. But I have no idea on how to get in there. If thats a viable option.

RB-334772 Newbie Points: 7 More actions · Answer 4

Did you get an answer to this?

I'm simply trying to call a SQL server rdl report from VB6 and am unsure how to do it/whether it is possible.

Thanks

bsivel Valued Member Points: 57 More actions · Answer 5

I'm now in the same boat that you were in...

I have a VB6 app and I'm trying to integrate sql2005 reports. I have a browser embedded on a form in my app and I can call any report to this form by url. What I'm stuck on is all the reports that require parameters (customerID, TransactionID,etc..) to execute. I need to pass the parameter values via the app but don't know how...

Hope you can give me some direction

Thanks,