I have a custom File management ASP application that handles Large File uploads and download from a database (30 - 40 MB files) The application works fine on IIS5 but when I relocate it to IIS6 i get an error when I file not found error when i attempt to download out of the Database. IS there a reg setting or metabase setting that i need to change to handle large blob outputs.? Sorry I can't be more specific about the error msg but that is all it give's me a File not found error. it does however work fine with small files less then 2mb in size When i checked for help i found this:http://support.microsoft.com/default.aspx?scid=KB;EN-US;q316431&[^] And this is the error i get Error message 1 Internet Explorer cannot download file from server. Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later. I was using IIS 5.0 and win 2000 before. Now i have migrated to IIS6.0 and Win2003 Any help on this will be highly appreciated. Biju Sam

Thanks for the reply Graus. No i did not generate this report. I was just trying to give a sample layout of the report. 1)Without runat=server how can i read the value in my .cs code? 2)How can i read through so many records inside HTML? I did a lot of google search, but all the results just show a direct export from HTML to Excel. It will copy exactly the same structure as it is there in HTML. But in my case the requirement is to convert from a List view to some what like Column like View(or like a Grid View) Please Help

I have a requirement in ASP.Net, where is there is a HTML page which will be around 1200 pages with records fetched from a Database using some reports. The records shown in HTML is in a Listed View some thing like Name : BS Age : 66 Work : Personal : xyz : Buisines : xyz Name : AA Age : 66 Work : Offial : abc : Buisines : abc I need this format replicated to an excel sheet in the following way(column wise) Name Age Work.Personal Work.Buisiness Work.Official BS 66 xyz xyz NULL AA 66 NULL abc abc Remember the HTML page has around 1200 pages ie may be around 50,000 rows. And some times the column heirarchy for eg: work can be more like work-official-buisiness-abc-abc----. So taking data from each td is making the task that much difficult. How can i meet this requirement? And also since it is HTML page there is no runat = server for table. in this case how can i get the TD,TR,TABLE etc inside my server side code if i want to loop thorugh each TD and TR. Please give me a solution which can meet this requirement. Or with any other languages this can be met? i mean by Javascript or Java or etc??? Please help. Thanks in advance. Biju Sam

Hi I have a trange requirement which is as follows: I have a HTML file with records which looks like a List View in ASP.NET. Please note that it is like a List view and not like a Datagrid. But this is inside a single table. I have to take this data and export it to excel in a DataGrid type of view. One more problem i see in this HTML file is, say suppose there are 200 records which is displayed in that List view, if the first record has values, the second might have 12. So the resulting excel sheet should have columns with maximum colums what the List view had. HTML looks something this: lt;table class='basic' width='100%' border='1' cellspacing='0'><tr class='header'><td valign='top' colspan=2 width='15%' class='sectionHeader'>Properties</td><tr><td valign='top' width='15%'>SI_ID</td><td valign='top'>15314</td></tr><tr><td valign='top' width='15%'>SI_NAME</td><td valign='top'>B&amp;C Share Top Dealers by Fund</td></tr><tr><td valign='top' width='15%'>SI_OWNER</td><td valign='top'>sweekev-a</td></tr><tr><td valign='top' width='15%'>SI_PARENT_FOLDER</td><td valign='top'>6294</td></tr><tr><td valign='top' width='15%'>SI_UPDATE_TS</td><td valign='top'>2/13/2008 4:59:01 PM</td></tr><tr><td valign='top' width='15%'>SI_CREATION_TIME</td><td valign='top'>2/13/2008 4:59:01 PM</td></tr><tr><td valign='top' width='15%'>SI_KIND</td><td valign='top'>Excel</td></tr><tr><td valign='top' width='15%'>SI_PROGID</td><td valign='top'>CrystalEnterprise.Excel</td></tr><tr><td valign='top' width='15%'>SI_FILES</td><td valign='top'><table class='basic' width='100%' border='1' cellspacing='0'><tr><td valign='top' width='15%'>SI_PATH</td><td

I gave permission to NETWORK SERVICE. it solved the problem.

Hi, Sincere request to give a solution to my problem. I will explain in detail. I have an application in ASP.Net, Sybase which was running very fine in windows 2000 server. Recently i migrated it to a windows 2003/IIS6.0 server. After the migration one of the pages is having an error I'm trying to insert a byte[] data to sybase with Column datatype TEXT. I get this error: Sybase.Data.AseClient.AseException: Operand type clash: IMAGE is incompatible with TEXT This is the function which does this. public static bool Archive(string ReportID, string ReportDate, string User, DataTable ReportDataTable, string ProfileRegionID) { ArrayList ar = Report.ConvertToArrayList(ReportDataTable); AseParameter[] myParams = new AseParameter[1]; AseParameter p = new AseParameter(); p.ParameterName = "@report"; p.AseDbType = AseDbType.Text; byte[] ReportData = DB.Data.Adaptors.XML.ConvertToXMLStream(ar).ToArray(); p.Size =ReportData.Length; p.Value = ReportData; myParams[0] = p; Adaptor a = new Adaptor(); a.ExecuteStatement(@"insert into ReportHistory (report_id,report_date,report_data,create_user,create_date,profile_region_id,locked,version) " + @" values(" + ReportID + ","+ReportDate+",@report,'"+ User +"','" + System.DateTime.Now.ToShortDateString() + "',"+ProfileRegionID+",0,0)" ,myParams, CommandType.Text); a.Dispose(); return true; } In this function when the query executes an error saying Sybase.Data.AseClient.AseException: Operand type clash: IMAGE is incompatible with TEXT is coming . Please help. Thanks in advance. Biju S

Hi, Sincere request to give a solution to my problem. I will explain in detail. I have an application in ASP.Net, Sybase which was running very fine in windows 2000 server. Recently i migrated it to a windows 2003/IIS6.0 server. After the migration one of the pages is having an error. This is the function which does this. public static bool Archive(string ReportID, string ReportDate, string User, DataTable ReportDataTable, string ProfileRegionID) { ArrayList ar = Report.ConvertToArrayList(ReportDataTable); // We can use this code here if we ever wanted to see the serialized content. // if (ReportID.Equals("1")) // DB.Data.Adaptors.XML.Serialize(ar,@"D:\Inetpub\Wwwroot\website2\AAA.xml"); AseParameter[] myParams = new AseParameter[1]; AseParameter p = new AseParameter(); p.ParameterName = "@report"; p.AseDbType = AseDbType.Text; byte[] ReportData = DB.Data.Adaptors.XML.ConvertToXMLStream(ar).ToArray(); p.Size =ReportData.Length; p.Value = ReportData; myParams[0] = p; Adaptor a = new Adaptor(); a.ExecuteStatement(@"insert into ReportHistory (report_id,report_date,report_data,create_user,create_date,profile_region_id,locked,version) " + @" values(" + ReportID + ","+ReportDate+",@report,'"+ User +"','" + System.DateTime.Now.ToShortDateString() + "',"+ProfileRegionID+",0,0)" ,myParams, CommandType.Text); a.Dispose(); return true; } In this function when the query executes an error saying Sybase.Data.AseClient.AseException: Operand type clash: IMAGE is incompatible with TEXT is coming To see what is the serialized data when i uncomment the bold lines in the function i get this error System.UnauthorizedAccessException: Access to the path "D:\Inetpub\Wwwroot\website2\AAA.xml" is denied. I have given ASPNET rights. but no use. Some one please please help me. Thanks in advance Biju S

In Global.asax file, there are events for session_start and session_end. put your code to update the DB(in DB you shd have colums for last_login) in the above events. Biju Sam

I'm using the correct syntaxes. for the path. but the hyperlink will not open the file unless you give ~\\folder\\file i need to emiminate this. Biju S

If i put the path like C;/........ it will not open it. Biju S

Thanks.

Hi All, Can we open a file in a loacation outside the PhysicalApplicationPath. And set the path to a hyperlinks NavigateUrl property? Please Help Biju Sam

Thanks for the reply. But question was not for a connection string. I need do give a folder path in server like //192.3.2.220/Folder/888.pdf file so in ,my cs code i need to get this path and open the PDF file. How is this possible. Biju S

Hi All, I need to include my folderpath(where i have few PDF files) eg: c:/Temp in web.config and access this path in cs file. Can some one help me on this please. Thanks, Biju S

Hi, I have a web.site map and few sitemapnodes.. i need to show each sitemapnode based on some condition. Like i have Employee, Manager, Admin sitemap nodes. i need not show admin sitemapnode when i log in as a manager. Please help me on this issue. Thanks in advance. Biju S

document.getElementById("btnTD").style.display = "none";

Hi All, I would like to know that is there any sample or help where in i can edit the treeview. like go and add,delete, modify directly inside treeview? Any suggestions or help on this? Thanks and Regards, Biju S

Hi All, I would like to know that is there any sample or help where in i can edit the treeview. like go and add,delete, modify directly inside treeview? Any suggestions or help on this? Thanks and Regards, Biju S

Hi, i have an asp.net application which has pages in different folders like supervisors, managers etc. and each folder has n number of pages(aspx). it is finding difficulty for me to check the user rights for each page. so is it possible to restrict the user if he does not have the manager rights to all the pages in the manager folder? Please help. Biju S

on runtime ie when u take document.getElementById('txtName') the value of txtName will be different, thats why you are getting a undefined error. take viewsource and find out the value of the hidden field first and then give that name. it will be somethinglike ctl00$MainContent$txtDateSearch Biju S