I have a report created in ASP (not ASP.NET) that uses Response.ContentType="application/vnd.ms-excel" to display the results of a query from SQL Server 2003 formatted as an html table using Excel in Internet Explorer (version 6.0.2800).
The report displayed fine when my PC had Excel 97 installed. My PC was recently upgraded to Office 2003 and now the report only displays the report header. Does anyone know of a change I can make to the ASP code to display the rest of the report in Excel 2003?
My company has recently started testing Win 2k3 servers to replace our current 2k versions. The problem I have is that our IT group sent out an email to all web developers stating that HTML forms would no longer be supported in 2k3 and all forms would have to be converted to asp pages.Since the form tag is in the html specs, I find this rather hard to believe.
I developed some code to export DataGrid to excel base on the html stream technology. But that one works only with worksheet cell. Is there any way to output Excel Chart based on the html stream?
This is a simple report that is supposed to render as an Excel document, for some reason it's not anymore, not sure why, I think it's related to permissions, we recently added a domain user as the anonymous user for the site, everyone has permissions to the virtual directory where the asp page is executed... Code:
Is this possible? I am planning to export data from SQL that generates HTML table. Instead of selecting the table and then copy then paste to excel, is ther a script(JS or VB) that will automatically export or open the Query to it.
We have a excel document, which is been updated regularly. After everyday updating, we export as HTML file and upload it. As a ASP programmer, I want to write a script, which can parse this excel file and make it as a web ready file. Is there any simple way to do this? Our data entry operator, is very new to computers and all he know is a little in Excel.
I am displaying the data into HTML table into a EXcel file using the REsponse.header and content type, The data retrieved from the database is sucessfully displayed and I am able to open Excel application and save it. But in One of my TD tag I have a image <IMG> tag which should disply the image, but in the excel application the image is not loaded, If I open the table in web browser the image is visible.
Also if I select the save open form the file download box, there is a blank browser window still open, I open this file with window.open functionality. Can somebody suggest how to close the blank window when the excel file is saved on the client PC instead of opening.
I an using ASP to read a database table and generate an HTML table which is save via FSO with a file extension of .xls which opens up in MS-Excel. I am inserting several lines of text into a cell and would like to force a line break between them.
I recorded an MS-Excel macro so see how Alt-Enter was captured which turned out to be Chr(10) which is the same as vbLf (right?)
I tried inserting that in character in the text but it didn't show up as a line break in MS-Excel.
i am using the following code to generate a xls file using the content type now when the user opnes the file at his pc it takes long time to open..if the no of records in file is large does the use of html tags has slow down the process of opening in excel. Code:
We face problems uploading excel (with macros) documents using HTML File Upload.
The file contents are corrupted while viewing the same. However, we are able to upload excel (w/o. macros) documents successfully. Is there anything we have to take care of, while handling uploads of excel documents with macros?
I currently have my website on a NT4 box, all pages work fine. I am working on moving it over to a win200k web edition server. I have my connection to my SQL working, copied all the pages to the new machine without making ANY changes to the pages. Now when my .asp page queries the database, it takes forever for it to return any data, and not only does it display incorrectly, it does it without putting anything in any of the tables that the data is suppose to be in. I have the data displayed in a table so it's all nice and neat, but the table is not being written. When I view the source code after the data is returned, it only has the data from the database, no mention of any tables, or the pictures or anything else. Is there something that has to get done so 2003 will write the tables properly??
I have 2000 Advanced Server with IIS 5.0 ..Net 2003 IDE and I want to create a ASP .Net Webservice Project. When I try to do that I get the message that the webserver is not running ASP.Net 1.1 . and I can't proceed. Is there a way to use ASP.Net 1.0 with IIS 5.0 in .Net 2003? I wont be upgrading to 2003 any time soon.
Our 2003 server recently updated itself with SP2, All our asp applications which use a variety of custom activex dlls stopped working with the classic "Method '~' of '~' failed" error. Changing permissions had no effect and only uninstalling SP2 fixed it.
I have a table having 3 columns. There is a checkbox for each line. I need to get those lines whose checkboxes are checked, and show those lines to another webpage. Is there any way to do that? My concern is that all information in the table are in <tb></tb> pairs without any name tag. Any idea?
I am writing a small CRM at the moment and would like one of the features to be that the first page picks up mail from a 'info@' mailbox on a locally hosted exchange 2003 server.
I am finding it a nightmare to track-down either how to do this or find the right info, I think partly because the methods may have changed with server upgrades.
Is there a definative method I should be using and any pointers to documentation etc.
So I only get the date, and not the time. What confuses me is the possibility that the string length can vary from date to date, else I'd use a trim, right?
Has anyone had any success in editing/debuggin classic ASP in Visual Studio 2003?
We have recently received a new project from an outside contractor done in .Net 1.1 and now have VS 2003 installed. We have tried to use it to work with our legacy ASP applications but we are stumped on how to get the debugger to work. It keeps trying to "build" and errors out because it cannot find a sub main().
If you have had any luck with this please either point to a resource that will get us started or share the steps to get this going.
I migrated my webapplication from VS 2003 to VS 2005. and i am running on win xp Professional sp2. After migrating. i am getting the following error ."The type initializer for 'System.Web.Compilation.CompilationLock' threw an exception." the error is shown in the following line
My window server is going to be upgraded from Win NT 4.0 Server to Win 2003 Server. I don't know if I can put an ASP web application on this new server without any problem. I guess ASP.NET would be better but right now I just have a classic ASP. Can you help me about this? Or any article about this issue would be greatly appreciated.
i am working on application which we are migrated asp application from WIN NT to WIN 2003. Here iam facing some problems.
here iam loading .asp file as image on another .asp file to display data in chart. this is working good in WIN NT but it is not loading in WIN 2003. iam giving html tag which we used to load the image
<img src="abcd.asp"> (this .asp is in the same directory)
but this is not loading. Is it the problem with WIN 2003
How do I add additional IP's manually in Windows 2003 Web Edition? I was told to add them to subnet mask? I am not sure about this as I am new to it. Also, in remote desktop connection perhaps? Where after I login?
I made some of the web pages using ASP on windows 2000 server, now i wanto to upgrade my Operating system from windows 2000 server to Windows 2003 Server , Are my web pages will work fine if i do this upgradation or there are any configurations on IIS i have to make to work fine ....
When I open a page from an existing website file in VS 2003, the page immediately executes without giving me the opportunity to view the code or insert a stop or break. How to view the code?
I get this error, despite doing everything the internet says to fix it: "Visual Studio .NET has detected that the specified web server is not running ASP.NET version 1.1. you will be unable to run ASP.NET web applications or services." YES, I have run "aspnet_regiis.exe -i" about 75 times. It doesn't work. I've uninstalled .NET Framework, reinstalled it, rerun aspnet_regiis over and over and over again... nothing works. I think it might have something to do with bad permissions somewhere, but I looked for over an hour for some magical window that says "Make ASP.NET work" and I'm convinced it doesn't exist. I'm using Windows XP Professional SP2, IIS v. 5.1, ASP.NET v. 1.1.4322.0, VS.NET 2003 Version 7.1.3088
I just migrated an NT4.0 website (all ASP) to Windows Server 2003 (small business server - deluxe edition) and some pages are very slow to render on client.
Seems to be pages with tables. I can stop the browser by clicking "X" and the table will be partly rendered. The table only has 26 rows and very little content.
Any ideas why this is happening would be appreciated. I have read of others with the same problem but no solutions.
I have a preformatted word file with tables. It is missing data which is in my MySQL database. Does anyone know how I can connect to my database from within Word in order to download specific fields in a specific table?
Instead of doing a complete dump (that's the only thing I've found on this subject. Make a complete dump in Excel and then probably make macros in order to get the right data into word.
i have the problem of session state being lost when i move on to the next page. i did read up on the security updates of ie 6 and understood that there were some security updates.
if i access the site http:localhost then the session is lost, if i access the site http:172.3.100.3 then the session works.
the weird thing is why does it work with the ip address, i also noted that the server name doesnot have a underscore, so what is happening here.
someone please help, i cant tell the customers to use the ip address?
this is Aravind from hyderbad. i am working on application which we are migrated asp application from WIN NT to WIN 2003. Here iam facing some problems. here iam loading .asp file as image on another .asp file to display data in chart. this is working good in WIN NT but it is not loading in WIN 2003. iam giving html tag which we used to load the image <img src="abcd.asp"> (this .asp is in the same directory) but this is not loading. Is it the problem with WIN 2003