"Bart Lynn" <rumour@bellsouth.net.net> wrote in message
news:uL5lAxusDHA.3492@TK2MSFTNGP11.phx.gbl...
> I have it working by the following code:
>
> Response.Clear()
>
> Response.Buffer = True
>
> Response.ContentType = "application/vnd.ms-excel"
>
> Response.Charset = ""
>
> EnableViewState = False
>
> Dim oStringWriter As System.IO.StringWriter
>
> oStringWriter = New System.IO.StringWriter
>
> Dim oHtmlTextWriter As System.Web.UI.HtmlTextWriter
>
> oHtmlTextWriter = New System.Web.UI.HtmlTextWriter(oStringWriter)
>
> dataGrid1.RenderControl(oHtmlTextWriter)
>
> Response.Write(oStringWriter.ToString())
>
> Response.End()
>
> When I click the button, a prompt to Open or save the file. Either is
fine.
>
> The problem is when a user on our domain tries to access the file. The
> websever is not on the domain. When they click the button, a popup for the
> "network password" is displayed. I can't find which user is being used on
> the webserver (I was thinking it was the IISASPNET one, but I guess not).
> I'd rather not put the server on the domain, for several reasons. I'd
rather
> set the correct permission for the correct user (the guest account, or
> whatever) .
>
> Any ideas?
>
> Bart
>
>

"Milan Todorovic" <milan.todorovic@ttu.edu> wrote in message
news:%23z44vC4sDHA.3144@tk2msftngp13.phx.gbl...
> Bart,
>
> Your solution works GREAT. Thanks!
> So, let me try to help you. If I understand your problem correctly, your
> users are required to provide a correct logon when they execute the
routine,
> but validation does not work because the web server in not a DC. If this
is
> the case, only thing you need to do is to disable Authenticated access
> feature in the ISS Security settings for the web site. That way the users
> always uses the anonymous IUSR_Servername user.
> I hope this helps
>
> Milan Todorovic
>
>
>
> "Bart Lynn" <rumour@bellsouth.net.net> wrote in message
> news:uL5lAxusDHA.3492@TK2MSFTNGP11.phx.gbl...
> > I have it working by the following code:
> >
> > Response.Clear()
> >
> > Response.Buffer = True
> >
> > Response.ContentType = "application/vnd.ms-excel"
> >
> > Response.Charset = ""
> >
> > EnableViewState = False
> >
> > Dim oStringWriter As System.IO.StringWriter
> >
> > oStringWriter = New System.IO.StringWriter
> >
> > Dim oHtmlTextWriter As System.Web.UI.HtmlTextWriter
> >
> > oHtmlTextWriter = New System.Web.UI.HtmlTextWriter(oStringWriter)
> >
> > dataGrid1.RenderControl(oHtmlTextWriter)
> >
> > Response.Write(oStringWriter.ToString())
> >
> > Response.End()
> >
> > When I click the button, a prompt to Open or save the file. Either is
> fine.
> >
> > The problem is when a user on our domain tries to access the file. The
> > websever is not on the domain. When they click the button, a popup for
the
> > "network password" is displayed. I can't find which user is being used
on
> > the webserver (I was thinking it was the IISASPNET one, but I guess
not).
> > I'd rather not put the server on the domain, for several reasons. I'd
> rather
> > set the correct permission for the correct user (the guest account, or
> > whatever) .
> >
> > Any ideas?
> >
> > Bart
> >
> >
>
>