Solved

'Out of String Space' Error, what to do?

Posted on 2004-09-06
11
9,204 Views
Last Modified: 2012-06-21
I am getting "error 14, Out of string space' from my VB app.  I do have several large tables and forms in the app.  What are the limits of 'string' space in a VB app.  Is it possible to control, expand or even monitor them beyond the task manager memory usage  monitor.

I am running Window XP.  I am not an OS guy but on a very high level I thought that the operating system would aquire wahtever resources it needs to satisfy a given applications memory requirements.  Event to the point of using available hard drive space, which would obviously severely slow down the app but still enable it to run.
0
Comment
Question by:mlcktmguy
[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
  • 3
  • 3
  • 2
  • +3
11 Comments
 
LVL 11

Accepted Solution

by:
bingie earned 45 total points
ID: 11993045
0
 
LVL 18

Expert Comment

by:JR2003
ID: 11993067
Find the line of code causing error and then look at the length of the string using:

Debug.Print Len(sMyString)
0
 
LVL 86

Assisted Solution

by:Mike Tomlinson
Mike Tomlinson earned 40 total points
ID: 11993438
Are you reading any large files all at once into a string and then manipulating that string?

If so, you may need to read the file line by line or in chunks.

Idle_Mind
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
LVL 2

Expert Comment

by:pelegst
ID: 11993546
By way of explanation: I have heard that VB isn't very good about recovering string space. The example referenced in the article, where it does "MyString = MyString & MyString" in a loop 100 times kills the program demonstrates (apparently) that every time you save the new string, it goes and gets some a new piece of heap space but doesn't seem to recover the old space.
0
 
LVL 18

Expert Comment

by:JR2003
ID: 11994397
pelegst

In bingie's link:

MyString = "Hello"
For Count = 1 To 100
    MyString = MyString & MyString
Next Count

If the computer managed to get to 100, MyString would be 5*(2^100) characters long. It would need more memory to store the string than exisits in the world! It doesn't demonstrate that the old space isn't recovered.
 
0
 
LVL 7

Expert Comment

by:Burbble
ID: 11996722
5,764,607,523,034,234,880 terabytes (plus 10 bytes), to be exact.

Good ol' Microsoft, lol...

From MSDN:

>> There are two kinds of strings: variable-length and fixed-length strings.
>>   A variable-length string can contain up to approximately 2 billion (2^31) characters.
>>   A fixed-length string can contain 1 to approximately 64K (2^16) characters.

-Burbble
0
 
LVL 1

Author Comment

by:mlcktmguy
ID: 11997082
Interesting.  How do I define my strings to ensure that they are variable length?  Typically to define a string in a module I use:

Dim VarA as String

I understand that in UDT's I associate with file handling they must be fixed length.  I define those as:

Public Type defstrat
  ECode As String * 7
  ACode As String * 7
  DefStrategy As String * 50
  crlf As String * 2
End Type

Is there more to it than that?  What if I define my Stirngs as variant instead of String?


0
 
LVL 86

Expert Comment

by:Mike Tomlinson
ID: 11997133
You are correct:

    Dim VarA as String

would define VarA as a variable length string.

Idle_Mind
0
 
LVL 18

Assisted Solution

by:JR2003
JR2003 earned 40 total points
ID: 11998440
When you have finished with a string you can just put
VarA = ""
This will release the memory from the string.
I sounds to be like might have a bug a bit like Microsoft's example of
Do
  MyString = MyString & MyString
Loop

It might be worth checking you code for this type of error.
0
 
LVL 1

Author Comment

by:mlcktmguy
ID: 12005988
I just found out that one of the users that is experiencing the 'Out of String' error is running XP Pro with Service Pack 2 installed.  I do not have Service Pack 2 on any of my machines and the app runs without error.  Does anyone know if Service Pack 2 could be the culprit.  Specifically does it mess with memory management?  I read through the write-ups and didn't see anything in it that should cause an issue with this single user, standalone app.  However I have heard numerous horror stories from those that installed, that's why I have not.
0
 
LVL 86

Expert Comment

by:Mike Tomlinson
ID: 12006023
I am running Win XP Pro w/ SP2 and have not yet encounterd any problems with VB6.  (That doesn't mean it's not the problem though...)

Idle_Mind
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses
Course of the Month3 days, 16 hours left to enroll

630 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