?
Solved

Problem with IIS 6.0 - Server object error

Posted on 2004-07-30
14
Medium Priority
?
1,835 Views
Last Modified: 2009-06-02
Hello, let me preface this question with I am not sure whether this is an IIS 6.0 question or a Windows 2003 SBS question so here it goes.  I am running an ecommerce site using ASP and a MSSQL database on a new 2003 SBS server.  I am not having a problem with the site itself, the problem is that when the customer checks out, they enter their shipping and billing information, once they choose a shipping option, the information is sent to a third party using XML and the third party will then return an XML page with the shipping info.  The problem is that it when I check the server in the morning, mind you, not every morning, I receive the following error

Server object error 'ASP 0177 : 80070008'

/testshipping.asp, line 95

80070008

Line 95 follows:

Set objXmlHttp = Server.CreateObject("Msxml.ServerXMLHTTP")

If I go into the IIS 6.0 console and stop, then start the site, I do not receive the error.  I have been trying to figure out this problem for about 3 weeks now and can not figure it out.  Any help would be much appreciated.
0
Comment
Question by:PlanetB04
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 6
14 Comments
 
LVL 6

Expert Comment

by:jdfulton
ID: 11680194
Basically the error means it cannot find or create the server object.  Have you upgraded your server to the latest version of MSXML?  Go here to download the latest version.
http://www.microsoft.com/downloads/details.aspx?FamilyID=3144b72b-b4f2-46da-b4b6-c5d7485f2b42&displaylang=en
0
 
LVL 6

Expert Comment

by:jdfulton
ID: 11680300

After you upgrade change your Server Object code to.

Set objXmlHttp = Server.CreateObject("Msxml2.ServerXMLHTTP.4.0")
0
 

Author Comment

by:PlanetB04
ID: 11680411
If it was the MSXML version, would I receive the error every time?  I only receive the error during the middle of the night, then when I restart the webservice, I might not receive the error again for up to 5 days....
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 6

Expert Comment

by:jdfulton
ID: 11680494
No maybe not.  2003 server is weird.  It could work for awhile then stop because something is not refreshing correctly.   When you restart the service it gets refreshed and starts working again.  I would try upgrading anyways to the latest version.  If this doesn't work then we know it's not the problem.
0
 

Author Comment

by:PlanetB04
ID: 11680560
Thanks...  I will let it run the weekend, I will let you know on Monday...
0
 

Author Comment

by:PlanetB04
ID: 11693422
Hi the upgrade did not work, Friday night the site completely went down when trying to process the Server.CreateObject.  When I rebooted the machine, the site (www.planetbattery.com) worked fine.  I have checked what processes, if any, are running during the overnight hours, this seems to be when I am having the problem, and I cannot find any.  Any further help would be appreciated
0
 
LVL 6

Expert Comment

by:jdfulton
ID: 11693915
Did you upgrade the XML yet and change your code?
0
 
LVL 6

Expert Comment

by:jdfulton
ID: 11694606
What version of  SQL Server are you running?
0
 

Author Comment

by:PlanetB04
ID: 11695314
Yes, I upgraded to msxml4.dll and I changed the code as written above.

I am running SQL 2000... I have installed SP3
0
 
LVL 6

Expert Comment

by:jdfulton
ID: 11696741
So has it ever worked?
0
 

Author Comment

by:PlanetB04
ID: 11696952
Yes, it work for about 3 or 4 hours on Friday, I reset the server Sunday afternoon, it work again, then the server had to be reset again this morning.
0
 
LVL 6

Expert Comment

by:jdfulton
ID: 11697224
No i mean has it ever worked without any problems.  Working 3-4 hours wouldn't be classified as working.  

What I am getting at is if it has never worked I would look at the code for the cause.  It seems to me that its the problem.  Since it stops or doesn't work after a certain time, there has to be some sort of loop etc.. causing IIS to stop processing object requests.   Another thing to try is to configure the folder where your application is for pooling.  You do this under the website properties in the IIS console.   This should keep your IIS service running for everything else.
0
 

Author Comment

by:PlanetB04
ID: 11725504
Yes, it had worked since Monday Aug. 2 without any problems. It has worked for as long as 10 days without a problem.

The code that I use was sent to us from a company called Intershipper, it calculates UPS Shipping costs, below is the Code.

Set objXmlHttp = Server.CreateObject("MSXML2.ServerXMLHTTP.3.0")
 
    'Specify Program And Quote Request Data
    dim url
    url = "http://www.intershipper.com/Interface/Intershipper/XML/v2.0/HTTP.jsp" & "?" & requestParameters
    objXmlHttp.open "POST", url , False
    'Send Quote Request... Execution Of ASP Holds Until Response Is Received


    objXmlHttp.send
response.write("<h1>"&error&"</h1>")
      On Error Resume Next

    'Pass XML Quote To String
    strXML = objXmlHttp.responseText
    'Print XML Quote
Response.write "Information returned from Intershipper<br><br>---"    
response.Write server.htmlencode(strxml)

Set fs = CreateObject("Scripting.FileSystemObject")
if fs.fileexists(FILENAMEANDPATH) then
    Set f = fs.OpenTextFile("c:\inetpub\wwwroot\planetbattery\xml\ship.xml", ForAppending,TristateFalse)
else
    Set f = fs.CreateTextFile("c:\inetpub\wwwroot\planetbattery\xml\ship.xml", True)
end if
f.write(strxml)
'fs.close
response.write strxml&"<br>"
set fs = nothing
set f = nothing
end if

The Server.CreateObject creates an XML form, this was located in the root of the site, I just created a folder and changed to Server.CreateObject to point toward this folder.  I cannot find the option in the IIS console to allow pooling.
0
 
LVL 6

Accepted Solution

by:
jdfulton earned 800 total points
ID: 11726853
Pooling can be enabled by clicking on the website properites, folder properties or virtual directory properties.   Then the Home Directory tab.  You want to configure the Application settings.  I would recommend doing it for the website itself and then the main directory of your application.  This should keep your entire site from going down if there is a problem.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Here are the symptoms: You start receiving calls from users that one of your legacy web apps isn't coming up, so you log into your IIS 5 server to check it out.  When you pull up the services, you notice that the WWW Publishing service isn't runn…
Prologue It is often required to host multiple websites on a single instance of IIS, mostly in development environments instead of on production servers. I am sure it is not much a preferred solution on production servers but this is at least a pos…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question