AboutSyed Rizwan Muhammad Rizvi Expertise I can answers questions regarding web based and desktop based programming in VB.Net. Which can include SOAP, XML, Custom Controls, COM Interoperability etc.
Experience Have been working in this specific area for last 2 years previously I was a VB 6 Developer with experties in other languages as well. Total 10 years of programming experience.
Question QUESTION: Website created in VS2005 can access Excel sheets as well as update from gridview. But when this site is published in IIS (or may be later on Webserver) simply goes to wait state - in the status bar message shown is - waiting for http://localhost/website1/excelread.aspx -
Statements used are simly
xlsfile = "E:\accounts\budget.xls"
With objExcel
.Visible = True
.Workbooks.Open(xlsFile)
End With
Kindly suggest any changes I am supposed to make
Regards
Vinod
ANSWER: Assuming that Excel runtime is installed on the server, check to see if IIS has permissions to run the Excel COM.
Regards,
Rizwan
---------- FOLLOW-UP ----------
QUESTION: Dear Rizwan,
Thanks for your guidance as under -
Assuming that Excel runtime is installed on the server, check to see if IIS has permissions to run the Excel COM.
But -Please pardon my ignorance. How to find it IIS has such permisions? And what is the procedure to affect these permissions
Thanks again
Vinod
ANSWER: before going into how to fix the problem a very simple way to test it is that in the same Virtual Directory you create another very simple page without any error handling. write some Excel object creation code in it, run it and test it, if it generates any error it would be displayed on screen anyway. if it doesnt and work then it means you have made some other mistake in your code which neads to be solved.
Hope that helps.
Regards,
Rizwan
---------- FOLLOW-UP ----------
QUESTION: Thanks Rizwan. As per your suggestions - I created a very simple page which simply opens an excel file by selected a row in gridview - Error I got is -- Remote procedure call failed exception HRESULT 0x800706BE - I searched for this on web - and tried advanced - performance options - added VBU.exe but did not work -- I also anonymous logon remote access - checked the box - but did not work - As I wrote to you before on Local site there are no problems - my PC uses xp prof and visual studio 2005 - Please guide me
Regards
Vinod
Answer The solutions to this problem can be very diverse it would be better if you can send me the error description as well. look in the Event Logs and check to see what description its showing you.
In broader terms it can be either of 3 things, 1. Permissions Problem, 2. Corrupt or Mismatching DLL, 3. A missing Component. Try running the application in Release mode rather than debug mode and see if that solves any problems?
