Does anyone know how it could be possible to get a 403.9 error (Forbidden - Too many users) on my localhost server, where I am the only one that could possibly be connecting? Well, I'm getting that very error. I've been experimenting with Excel connections this morning. Could that be the cause?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Too many users on localhost???
- Thread starter snoopy75
- Start date
<url>
Q262632&ID=KB;EN-US;Q262632&LN=EN-US&rnk=4&SD=tech&FR=0&
qry=windows%20XP&src=DHCS_MSPSS_tech_SRCH&SPR=IIS50&
</url>
_____________________________________________________________________
You can accomplish anything in life, provided that you do not mind who gets credit.
Harry S. Truman
- Thread starter
- #3
Alright, so rebooting my machine is the solution, but I'm still trying to figure out the cause. Here is the page that is effectively crashing my webserver:
Some basic debugging has narrowed down the problem point to the line that opens the workbook (line 6 above). But I don't see how it could be doing such a thing. Any ideas? 
Code:
<%
Dim xls
Set xls = CreateObject("Excel.Application")
Dim rows
Dim cols
Const xlReadWrite = 3
xls.Workbooks.Open server.MapPath("yourfile.xls"), xlReadWrite, False
xls.Sheets("Sheet1").Select
xls.ActiveSheet.Cells(1,1).Value = "Wahoo"
xls.ActiveSheet.Cells(1,2).Value = "(1,2)"
xls.ActiveSheet.Cells(3,3).Value = "=Sum(A4+B4)"
xls.ActiveSheet.Cells(4,4).Value = 7777
rows = xls.ActiveSheet.UsedRange.rows.Count
cols = xls.ActiveSheet.UsedRange.columns.Count
response.Write(rows & " rows<br>")
response.Write(cols & " columns<br>")
xls.Save
xls.Application.Quit
Set xls = Nothing
response.Write("Done!")
%>- Status
Similar threads
- Locked
- Question
- Locked
- Question