I saw an article on MSDN knowledge base that explains how to use a SQLXML
tool ( IIS Configuration ) to select a stored procedure and generate a web
service wrapper. I noticed that the example to call the generated web
service was VBScript / VB6 / COM. When I go to VS.NET and create a VB.NET
WinForm app, then try to add the web reference to the SQLXML generated web
service, the VS.NET dialog "Web Services on the Local Machine" does list the
new web service name. However, you can't add it if you select that web
service. When you select the service name, to add the reference, it tries
to browse to the wsdl file, it get file not found. The wsdl file is in the
correct folder, and the virtual directory is present.
Does this SQLXML wizard not generate everything needed for .NET to add a web
reference? How is the .ssc file related? I noticed that the .ssc ( SQL
Server Config?) file is create with the .wsdl, but it seems that some other
management application we have, is registered with the .scc file extension.
What is the proper application to associate with the .scc file extension?
Thanks for any help.
RJ