> Our client IIS uses NT Authentication and not anonymous.
> We have XLS files in a different server than the IIS server, but both
> server are in the same domain with IIS.
> The user ids that are used are all in a group that has full control
> of the directory where the XLS file that we want to access (say
> \\myserver2\Work\myfilesFolder\).
> But in the ASP page when using GetFile method to get to the XLS file,
> it gets HTTP500 internal server error.
> What causes this and how to fix it ?
> Thank you.
>
> This is the code:
> sExcelPath = \\myserver2\Work\myFilesFolder\ExcelTemplate.xls
> Set fso = CreateObject("Scripting.FileSystemObject")
> Set f1 = fso.GetFile(sExcelPath)  -> HTTP500 internal server error

> Our client IIS uses NT Authentication and not anonymous.
> We have XLS files in a different server than the IIS server, but both server
> are in the same domain with IIS.
> The user ids that are used are all in a group that has full control of the
> directory where the XLS file that we want to access (say
> \\myserver2\Work\myfilesFolder\).
> But in the ASP page when using GetFile method to get to the XLS file, it
> gets HTTP500 internal server error.
> What causes this and how to fix it ?
> Thank you.
>
> This is the code:
> sExcelPath = \\myserver2\Work\myFilesFolder\ExcelTemplate.xls
> Set fso = CreateObject("Scripting.FileSystemObject")
> Set f1 = fso.GetFile(sExcelPath)  -> HTTP500 internal server error
>
>

"Roberto Franceschetti" <roberto_remove_t***@logsat.com> wrote in message
news:49fe3a29$0$11839$9a6e19ea@unlimited.newshosting.com...
> If you're using "Integrated Windows Authentication" in the Directory
> Security tab under authentication methods, this only allows IIS to have a
> security token that grants authenticated users to resources local on the
> IIS server itself, they won't have network access. If you remove
> integrated authentication, and enable only "Basic Authentication", users
> will be prompted with a username/password dialog box that will allow them
> to authenticate. Now IIS will have the complete user's credentials, and
> will allow them access to the network shares.
>
> --
> Roberto Franceschetti
> LogSat Software
> http://www.logsat.com
>
>
> fniles wrote:
>> Our client IIS uses NT Authentication and not anonymous.
>> We have XLS files in a different server than the IIS server, but both
>> server are in the same domain with IIS.
>> The user ids that are used are all in a group that has full control of
>> the directory where the XLS file that we want to access (say
>> \\myserver2\Work\myfilesFolder\).
>> But in the ASP page when using GetFile method to get to the XLS file, it
>> gets HTTP500 internal server error.
>> What causes this and how to fix it ?
>> Thank you.
>>
>> This is the code:
>> sExcelPath = \\myserver2\Work\myFilesFolder\ExcelTemplate.xls
>> Set fso = CreateObject("Scripting.FileSystemObject")
>> Set f1 = fso.GetFile(sExcelPath)  -> HTTP500 internal server error

Gazing into my crystal ball I observed "fniles" <fni***@pfmail.com>
writing in news:uXd0WnozJHA.140@TK2MSFTNGP03.phx.gbl:

> Thank you everybody.
> They now turned off the friendly message.
>
> Using "basic authentication" the fso.GetFile(sExcelPath) works fine,
> but they do not want to use "basic authentication" because the
> password is sent in clear text.
> So, they try to use "digest authentication for windows domain
> servers". When they do that, they got the following error:
>
> Microsoft VBScript runtime error '800a0035'
> File not found
> /myIntranetSite/myTest.asp, line 7   -> this is on the
> fso.GetFile(sExcelPath)

"Adrienne Boswell" <arb***@yahoo.com> wrote in message
news:Xns9C04478C4DC3arbpenyahoocom@207.115.33.102...
> Gazing into my crystal ball I observed "fniles" <fni***@pfmail.com>
> writing in news:uXd0WnozJHA.140@TK2MSFTNGP03.phx.gbl:
>
>> Thank you everybody.
>> They now turned off the friendly message.
>>
>> Using "basic authentication" the fso.GetFile(sExcelPath) works fine,
>> but they do not want to use "basic authentication" because the
>> password is sent in clear text.
>> So, they try to use "digest authentication for windows domain
>> servers". When they do that, they got the following error:
>>
>> Microsoft VBScript runtime error '800a0035'
>> File not found
>> /myIntranetSite/myTest.asp, line 7   -> this is on the
>> fso.GetFile(sExcelPath)
>
> What is the physical path?  Does the file indicated exist at the physical
> path?
>
>>
>> Why "digest authentication for windows domain servers" gave the above
>> error and how can we fix it ?
>
> That's not an authentication error, it's a file not found error, so there
> is something going on there.  Verify that the file exists at the
> specified path.
>
>
>
>
> --
> Adrienne Boswell at Home
> Arbpen Web Site Design Services
> http://www.cavalcade-of-coding.info
> Please respond to the group so others can share
>

> "Adrienne Boswell" <arb***@yahoo.com> wrote in message
> news:Xns9C04478C4DC3arbpenyahoocom@207.115.33.102...
>> Gazing into my crystal ball I observed "fniles" <fni***@pfmail.com>
>> writing in news:uXd0WnozJHA.140@TK2MSFTNGP03.phx.gbl:
>>
>>> Thank you everybody.
>>> They now turned off the friendly message.
>>>
>>> Using "basic authentication" the fso.GetFile(sExcelPath) works fine,
>>> but they do not want to use "basic authentication" because the
>>> password is sent in clear text.
>>> So, they try to use "digest authentication for windows domain
>>> servers". When they do that, they got the following error:
>>>
>>> Microsoft VBScript runtime error '800a0035'
>>> File not found
>>> /myIntranetSite/myTest.asp, line 7   -> this is on the
>>> fso.GetFile(sExcelPath)
>>
>> What is the physical path?  Does the file indicated exist at the
>> physical path?
>>
>>>
>>> Why "digest authentication for windows domain servers" gave the
>>> above error and how can we fix it ?
>>
>> That's not an authentication error, it's a file not found error, so
>> there is something going on there.  Verify that the file exists at
>> the specified path.
>>
> The physical path is something like
> \\myServer\Work\myCo\MyFolder\MyTemplate.xls
>
> The file does exist, and if I use "basic authentication" it work fine,
> we can get to the file.
> Only doesn't work when I use "digest authentication for windows domain
> servers"

"Adrienne Boswell" <arb***@yahoo.com> wrote in message
news:Xns9C0547969F11Barbpenyahoocom@207.115.33.102...
> Gazing into my crystal ball I observed "fniles" <fni***@pfmail.com>
> writing in news:e48$Ut0zJHA.2656@TK2MSFTNGP05.phx.gbl:
>
> Please don't top post in Usenet.  Top posting corrected.
>
>> "Adrienne Boswell" <arb***@yahoo.com> wrote in message
>> news:Xns9C04478C4DC3arbpenyahoocom@207.115.33.102...
>>> Gazing into my crystal ball I observed "fniles" <fni***@pfmail.com>
>>> writing in news:uXd0WnozJHA.140@TK2MSFTNGP03.phx.gbl:
>>>
>>>> Thank you everybody.
>>>> They now turned off the friendly message.
>>>>
>>>> Using "basic authentication" the fso.GetFile(sExcelPath) works fine,
>>>> but they do not want to use "basic authentication" because the
>>>> password is sent in clear text.
>>>> So, they try to use "digest authentication for windows domain
>>>> servers". When they do that, they got the following error:
>>>>
>>>> Microsoft VBScript runtime error '800a0035'
>>>> File not found
>>>> /myIntranetSite/myTest.asp, line 7   -> this is on the
>>>> fso.GetFile(sExcelPath)
>>>
>>> What is the physical path?  Does the file indicated exist at the
>>> physical path?
>>>
>>>>
>>>> Why "digest authentication for windows domain servers" gave the
>>>> above error and how can we fix it ?
>>>
>>> That's not an authentication error, it's a file not found error, so
>>> there is something going on there.  Verify that the file exists at
>>> the specified path.
>>>
>> The physical path is something like
>> \\myServer\Work\myCo\MyFolder\MyTemplate.xls
>>
>> The file does exist, and if I use "basic authentication" it work fine,
>> we can get to the file.
>> Only doesn't work when I use "digest authentication for windows domain
>> servers"
>
> What happens if you loop through the files in that directory?  Does the
> file show up that way?  This is a file not found issue.
>
>
> --
> Adrienne Boswell at Home
> Arbpen Web Site Design Services
> http://www.cavalcade-of-coding.info
> Please respond to the group so others can share
>

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:%23LBk99%23zJHA.4736@TK2MSFTNGP05.phx.gbl...
> Bob Barrows wrote:
>>
>> fmiles, if the file definitely exists in the specified location, then
>> you definitely do not have permissions set correctly for the user
>> accessing the website. I know you said "The user ids that are used are
>> all in a group that has full control of the directory where the XLS
>> file that we want to access "
>
> Incidently, these need to be filesystem permissions, not website
> permissions. The FileSystemObject has no exposure to the website
> permissions set via IIS Manager. All it knows about are the permissions
> set on the file system via the operating system.
>
> --
> HTH,
> Bob Barrows
>
>

> Do you suggest me checking if the
> request.servervariables("logon_user") has permission to the file I am
> trying to access ?
>
> Thank you.
>
> "Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
> news:%23LBk99%23zJHA.4736@TK2MSFTNGP05.phx.gbl...
>> Bob Barrows wrote:
>>>
>>> fmiles, if the file definitely exists in the specified location,
>>> then you definitely do not have permissions set correctly for the
>>> user accessing the website. I know you said "The user ids that are
>>> used are all in a group that has full control of the directory
>>> where the XLS file that we want to access "
>>
>> Incidently, these need to be filesystem permissions, not website
>> permissions. The FileSystemObject has no exposure to the website
>> permissions set via IIS Manager. All it knows about are the
>> permissions set on the file system via the operating system.
>>
>> --
>> HTH,
>> Bob Barrows

@NOyahoo.SPAMcom> writing in news:#AQbm6#zJHA.4800@TK2MSFTNGP06.phx.gbl:

>>> Why "digest authentication for windows domain servers" gave the above
>>> error and how can we fix it ?
>>
>> That's not an authentication error, it's a file not found error, so
>> there is something going on there.  Verify that the file exists at the
>> specified path.
>>
> Adrienne, I frequently get "file not found" errors when there are
> permissions problems. You cannot dismiss permissions issues just
because
> the message says "file not found".
>

> Gazing into my crystal ball I observed "Bob Barrows" <reb01501
> @NOyahoo.SPAMcom> writing in
> news:#AQbm6#zJHA.4800@TK2MSFTNGP06.phx.gbl:
>
>>>> Why "digest authentication for windows domain servers" gave the
>>>> above error and how can we fix it ?
>>>
>>> That's not an authentication error, it's a file not found error, so
>>> there is something going on there.  Verify that the file exists at
>>> the specified path.
>>>
>> Adrienne, I frequently get "file not found" errors when there are
>> permissions problems. You cannot dismiss permissions issues just
>> because the message says "file not found".
>>
>
> Thanks, Bob.  I did not know that.  You would think "file not found"
> means exactly that.  You would think that if it were a permissions
> problem, it would say "permission denied" not "file not found".  Oh
> well, live and learn.
>