Out of string space Error

[Ankor]

Hello all,
Here is the problem. I have two web servers that connect to the same database. I have exactly the same set of files on both servers. One of these files pulls html from the SQL Server stored procedure and creates a menu. It works without any problem on one of the servers, but returns an error message on another one:
Error Type:
Microsoft VBScript runtime (0x800A000E)
Out of string space
Any ideas?

Thanks in advance for your help.

 

[dbMark]

Wow, I looked and there's not much help available for this issue. This might point you in the right direction:

Apparently these 2 web servers are not equal, with one having less workspace. According to one site, you could not create a string object because you used up all your system memory. Causes: A dynamically allocated array growing too large, or the instantiation of a large number of objects. Fixes:

Use the Erase statement to reallocate dynamic-array storage space.

Use the ReDim statement to reallocate storage space.

Close any unnecessary applications, documents, or source files that are open.

Links:

http://www.nedcomp.nl/support/origdocs/vbscript/extracted/html/vserroutofstringspace.aspx

http://dbforums.com/arch/196/2002/6/886050

 

[Ankor]

Thanks for the answer. IIS restart solved the problem.

 

[dbMark]

Reminds me of the old joke...

4 engineers (structural, mechanical, design and Microsoft)riding in a car, it goes thump and dies. Three get out and scurry around trying to figure out the problem. The last, the Microsoft engineer, gets out but gets right back ing again. The others ask, aren't you going to do anything? He replies, I just did. When I have problems, I just get out and go back in and everything works.

Yep, stopping the service (or computer) and restarting is often the first step to take.