?
Solved

Having an issue with SOAP & SQL Reporting Service in VB6.

Posted on 2005-05-12
5
Medium Priority
?
287 Views
Last Modified: 2012-06-27
I am trying to retro fit SQL Reports in my VB6 app. 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.
I have the .NET version of this working perfectly it's just the VB6/SOAPToolKit 3.0 part that I am getting stuck on.

0
Comment
Question by:Steve Sirica
  • 3
  • 2
5 Comments
 
LVL 16

Expert Comment

by:jimbobmcgee
ID: 13987744
This may be a silly question but you have registered all necessary DLLs in your app, yes?

J.
0
 
LVL 4

Author Comment

by:Steve Sirica
ID: 13989120
The best of my knowledge all DLLs are registered and properly referenced.
0
 
LVL 4

Author Comment

by:Steve Sirica
ID: 13989251
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 that's even a viable option?
0
 
LVL 16

Accepted Solution

by:
jimbobmcgee earned 2000 total points
ID: 13995418
I don't know about the .wsdl file but is Reporting Services running on the development machine?  You could always try browsing for the .wsdl file in the Project -> References menu.

J.
0
 
LVL 4

Author Comment

by:Steve Sirica
ID: 14213109
I no longer care about this.  Jim Bob you got the poinx because you posted and I hate having open questions.

0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month13 days, 22 hours left to enroll

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question