Scenario :

1. The Department files to be accessed are present in the File server.
2. The Code is present in a different server with OS being Windows Server
2003.
3. Access to File server happens using ADS Authentication.
4. Code is developed in ASP.NET using VB.NET. (Web.Config file settings are
based on ADS Login; Authentication=Windows ; )
5. Requirement is to display folders and files in a treeview structure.
[Built in functions like GetDirectories and GetFiles returns nothing and
functions related to Kernel Programming like (Private Declare Function
FindFirstFile Lib "kernel32" Alias "FindFirstFileA" (ByVal lpFileName As
String, ByRef lpFindFileData As WIN32_FIND_DATA) As Integer—ïƒ* Returns -1 )]
when executed from Windows Server 2003.
6. The same code works fine without any issues when run locally from an XP
machine.

Problem 2 : Unable to generate Excel Application in ASP.NET using Interop
Assemblies.

Scenario

1. The Code is present in a server with OS being Windows Server 2003.
2. Microsoft Office 2003 along with SP3 and interop assemblies dll is
installed on the server.
3. The Code snippet mentioned below does not show up any error but at the
same time will not generate an excel sheet.

Dim excel As Microsoft.Office.Interop.Excel.Application
Dim wb As Microsoft.Office.Interop.Excel.Workbook
Dim ws As Microsoft.Office.Interop.Excel.Worksheet

excel = New Microsoft.Office.Interop.Excel.Application

excel.Visible = True
wb = excel.Workbooks.Add(XlWBATemplate.xlWBATWorksheet)
ws = CType(wb.Worksheets(1), Worksheet)
ws.Name = "sample"

4. The same code works fine when run on a local XP machine.

Neeba wrote:

Your code is almost certainly suffering from either
A permissions problem - web applications run with a /lower/ set of
permissions than an interactive user, or
A "network visibility" problem - web servers generally aren't allowed to
"see" the network (and certainly not mapped drives).

Quick test: Reconfigure the web application to run under a specified
account (under which the code /works/) and see if things improve.

And how would you know even if it did?

The Web server is a Windows Service and, as such, runs on a (I can't
call it "virtual" any more, so) "pretend" desktop that /nobody/ ever can
get to look at (which is why ASP[.Net] doesn't have a MsgBox function).
Unless you /save/ the modified WorkBook, how are you going to see if
a new Worksheet has been added?

HTH,
Phill W.