Web service asks for Login (unexpectedly)

[Hiran]

I have a simple 'hello world' web service here
http://www.askhiran2008.com/asliwebs...2/service.asmx. It should
return data from the Northwind sample database.

It works fine when being consumed by a simple ASP.NET application. See
here http://www.askhiran2008.com/AsliWSClient2/default.aspx

BUT when I try to Import it into Excel 2003 I get a login screen.

I have tested what I'm doing my putting this into the Excel 2003
Import XML
http://www.webservicex.com/airport.asmx?WSDL - and I don't get asked
for a login.

Here is all my code in my .asmx file (ASP.NET 2.0)

Imports System.Web
Imports System.Web.Services
Imports System.Web.Services.Protocols

<WebService(Namespace:="http://tempuri.org/")_
<WebServiceBinding(ConformsTo:=WsiProfiles.BasicPr ofile1_1)_
<Global.Microsoft.VisualBasic.CompilerServices.Des ignerGenerated()_
Public Class Service
Inherits System.Web.Services.WebService

<WebMethod()_
Public Function GetProductsAll() As Products.ProductsDataTable
Dim taProducts As ProductsTableAdapters.ProductsTableAdapter
taProducts = New ProductsTableAdapters.ProductsTableAdapter()
Return taProducts.GetProducts()
End Function

End Class
BTW both services work without the login requirement when tested in
www.validWSDL.com

What am I missing here?

Thanks for any help,
Hiran

[John Saunders]

"Hiran" <hi***@desilva.comwrote in message
news:2c**********************************@f36g2000 hsa.googlegroups.com...

I have a simple 'hello world' web service here
http://www.askhiran2008.com/asliwebs...2/service.asmx. It should
return data from the Northwind sample database.

It works fine when being consumed by a simple ASP.NET application. See
here http://www.askhiran2008.com/AsliWSClient2/default.aspx

BUT when I try to Import it into Excel 2003 I get a login screen.

Since you know for a fact that your web service isn't asking for a login,
there is no reason for us to look at your code. Neither should you.

How does Excel know to display a login screen? It would have to be because
of network traffic. So you need to look at the network traffic. There is a
list of ways to look at network traffic at
http://johnwsaundersiii.spaces.live.com/blog/cns!600A2BE4A82EA0A6!224.entry.
--
John Saunders | MVP - Connected System Developer