473,385 Members | 1,958 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > asp / active server pages > questions > too many variable.

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Too many variable.

Dear NG.

IIS5 (and II6) , ASP 3.0.; W2k, WS03.

A websolution has a login-page, transaction page (just reading data), and
logout-page

Under heavy load I get in the IIS-Log : Too many variables (Microsoft OLE DB
privider for V.FoxPro: Too many Variables).

I have written a testprogram to call the three pages (login, tranaction,
logout) and in one run, I login for 8 users.(in diffenet threads)
Running the program 7 times on one pc gave the "Too many variables'. Restart
IIS, and I get it agin. (depending on memory).
Ah simple, I thought, programming bug - a connection is open, or I forget to
close (nothing ) to stuff..
I removed all the close stuff, and would expect the bug come up earlier, but
it came exacly at the 7. run again. Hm.

In the transaction and login I have code as

CreateObject("ADODB.Commad)
Add parameters to a select statement with "?"
execute the command (not yet closed)
Create new Command
Add parameters to select statement with "?"
execute the command

hereafter I close the stuff.

IF I remove one of the parameterised "command-executes", I can run upto 20
times until the bug shows up.
So it seems as some management of the memory/variables isn't given free,
when I say it.

Can anybody give a hint where to look?
IIS must somwhow remember the test-prog ran before (as though the
connections/logout were not performed)

Regards,
flemming
Jul 19 '05 #1
5 2951
Could this be Visual Fox Pro not handling the close?

-rwg
This is what I think, not necessarily what is accurate!
Jul 19 '05 #2
Rob.

Which close: the connection, the Command object, or ...?

Have you seen something written about this - where?

Regards,
flemming
"Rob Greene" <a-****@online.microsoft.com> wrote in message
news:7m*************@cpmsftngxa06.phx.gbl...
Could this be Visual Fox Pro not handling the close?

-rwg
This is what I think, not necessarily what is accurate!

Jul 19 '05 #3
| Which close: the connection, the Command object, or ...?
|
| Have you seen something written about this - where?

I have nothing in writing about this, What I know is that IIS itself does not know what the application is doing or what resources the application
has opened. IIS will keep a Session open for your client, and it keeps the Application open. If you are placing objects in session of
application variables, and not closing them correctly, then this would account for the resource consumption resulting in problems. Because
you seem to be closing the resources, and because I know that IIS itself does not maintain resources like this, and because I know very little
about V.FoxPro, I was suggesting that maybe there is a visual fox pro newsgroup which has seen this issue.

Do you have error numbers listed in the IIS logs, a number like 0x800xxxxx or -2xxxxxxxxxx type of number? If not, can you paste IIS log entry
here?

-rwg
This is what I think, not necessarily what is accurate!

--------------------
| From: "flemming eriksen" <fn************@kabnospama.com>
| References: <OL**************@TK2MSFTNGP10.phx.gbl> <7m*************@cpmsftngxa06.phx.gbl>
| Subject: Re: Too many variable.
| Date: Mon, 8 Mar 2004 07:14:41 +0100
| Lines: 18
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <#W**************@TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.inetserver.asp.general
| NNTP-Posting-Host: 193.192.244.130
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.inetserver.asp.general:267714
| X-Tomcat-NG: microsoft.public.inetserver.asp.general
|
| Rob.
|
| Which close: the connection, the Command object, or ...?
|
| Have you seen something written about this - where?
|
| Regards,
| flemming
| "Rob Greene" <a-****@online.microsoft.com> wrote in message
| news:7m*************@cpmsftngxa06.phx.gbl...
| > Could this be Visual Fox Pro not handling the close?
| >
| > -rwg
| > This is what I think, not necessarily what is accurate!
| >
| >
|
|
|
Jul 19 '05 #4
Rob,

I paste some lines from the 2 logs.

2004-03-05 14:04:56 10.2.10.62 - 10.2.10.62 80 GET
/intranetdialog/login.asp - 200 -
2004-03-05 14:04:56 10.2.10.62 - 10.2.10.62 80 POST
/intranetdialog/login.asp - 302 -
2004-03-05 14:04:56 10.2.10.62 - 10.2.10.62 80 POST
/intranetdialog/login.asp - 302 -
2004-03-05 14:05:31 10.2.10.62 - 10.2.10.62 80 POST
/intranetdialog/login.asp |153|80004005|Too_many_variables. 500 -
2004-03-05 14:05:40 10.2.10.62 - 10.2.10.62 80 POST
/intranetdialog/login.asp |132|80004005|Too_many_variables. 500 -
2004-03-05 14:05:40 10.2.10.62 - 10.2.10.62 80 POST
/intranetdialog/login.asp |-|ASP_0147|500_Server_Error 500 -

2004-03-17 09:35:10 10.2.10.62 - 10.2.10.62 80 GET
/intranetdialog/login.asp - 200 -
2004-03-17 09:35:10 10.2.10.62 - 10.2.10.62 80 GET
/intranetdialog/login.asp - 200 -
2004-03-17 09:35:10 10.2.10.62 - 10.2.10.62 80 POST
/intranetdialog/login.asp - 302 -
2004-03-17 09:35:11 10.2.10.62 - 10.2.10.62 80 POST
/intranetdialog/login.asp - 302 -
2004-03-17 09:36:25 10.2.10.62 - 10.2.10.62 80 POST
/intranetdialog/login.asp |153|80004005|Too_many_variables. 500 -
2004-03-17 09:36:25 10.2.10.62 - 10.2.10.62 80 POST
/intranetdialog/login.asp |-|ASP_0147|500_Server_Error 500 -
Any hints?

Flemming
"Rob Greene" <a-****@online.microsoft.com> wrote in message
news:iq***************@cpmsftngxa06.phx.gbl...
| Which close: the connection, the Command object, or ...?
|
| Have you seen something written about this - where?

I have nothing in writing about this, What I know is that IIS itself does not know what the application is doing or what resources the application has opened. IIS will keep a Session open for your client, and it keeps the Application open. If you are placing objects in session of application variables, and not closing them correctly, then this would account for the resource consumption resulting in problems. Because you seem to be closing the resources, and because I know that IIS itself does not maintain resources like this, and because I know very little about V.FoxPro, I was suggesting that maybe there is a visual fox pro newsgroup which has seen this issue.
Do you have error numbers listed in the IIS logs, a number like 0x800xxxxx or -2xxxxxxxxxx type of number? If not, can you paste IIS log entry here?

-rwg
This is what I think, not necessarily what is accurate!

--------------------
| From: "flemming eriksen" <fn************@kabnospama.com>
| References: <OL**************@TK2MSFTNGP10.phx.gbl> <7m*************@cpmsftngxa06.phx.gbl> | Subject: Re: Too many variable.
| Date: Mon, 8 Mar 2004 07:14:41 +0100
| Lines: 18
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <#W**************@TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.inetserver.asp.general
| NNTP-Posting-Host: 193.192.244.130
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.inetserver.asp.general:267714 | X-Tomcat-NG: microsoft.public.inetserver.asp.general
|
| Rob.
|
| Which close: the connection, the Command object, or ...?
|
| Have you seen something written about this - where?
|
| Regards,
| flemming
| "Rob Greene" <a-****@online.microsoft.com> wrote in message
| news:7m*************@cpmsftngxa06.phx.gbl...
| > Could this be Visual Fox Pro not handling the close?
| >
| > -rwg
| > This is what I think, not necessarily what is accurate!
| >
| >
|
|
|

Jul 19 '05 #5
rwg
I suspect you are using VFP OLE DB Provider version 7. There is supposed to be a fix in version 8 of the provider for this issue. This is a Foxpro issue
and you might be able to get better answer on a Foxpro group.

-rwg
This is what I think, not necessarily what is accurate!

--------------------
| From: "flemming eriksen" <fn************@kabnospama.com>
| References: <OL**************@TK2MSFTNGP10.phx.gbl> <7m*************@cpmsftngxa06.phx.gbl> <#WPYbSNBEHA.2476
@TK2MSFTNGP12.phx.gbl> <iq*************@cpmsftngxa06.phx.gbl>
| Subject: Re: Too many variable.
| Date: Wed, 17 Mar 2004 10:47:09 +0100
| Lines: 100
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <Or**************@tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.inetserver.asp.general
| NNTP-Posting-Host: 193.192.244.130
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.inetserver.asp.general:268510
| X-Tomcat-NG: microsoft.public.inetserver.asp.general
|
| Rob,
|
| I paste some lines from the 2 logs.
|
| 2004-03-05 14:04:56 10.2.10.62 - 10.2.10.62 80 GET
| /intranetdialog/login.asp - 200 -
| 2004-03-05 14:04:56 10.2.10.62 - 10.2.10.62 80 POST
| /intranetdialog/login.asp - 302 -
| 2004-03-05 14:04:56 10.2.10.62 - 10.2.10.62 80 POST
| /intranetdialog/login.asp - 302 -
| 2004-03-05 14:05:31 10.2.10.62 - 10.2.10.62 80 POST
| /intranetdialog/login.asp |153|80004005|Too_many_variables. 500 -
| 2004-03-05 14:05:40 10.2.10.62 - 10.2.10.62 80 POST
| /intranetdialog/login.asp |132|80004005|Too_many_variables. 500 -
| 2004-03-05 14:05:40 10.2.10.62 - 10.2.10.62 80 POST
| /intranetdialog/login.asp |-|ASP_0147|500_Server_Error 500 -
|
| 2004-03-17 09:35:10 10.2.10.62 - 10.2.10.62 80 GET
| /intranetdialog/login.asp - 200 -
| 2004-03-17 09:35:10 10.2.10.62 - 10.2.10.62 80 GET
| /intranetdialog/login.asp - 200 -
| 2004-03-17 09:35:10 10.2.10.62 - 10.2.10.62 80 POST
| /intranetdialog/login.asp - 302 -
| 2004-03-17 09:35:11 10.2.10.62 - 10.2.10.62 80 POST
| /intranetdialog/login.asp - 302 -
| 2004-03-17 09:36:25 10.2.10.62 - 10.2.10.62 80 POST
| /intranetdialog/login.asp |153|80004005|Too_many_variables. 500 -
| 2004-03-17 09:36:25 10.2.10.62 - 10.2.10.62 80 POST
| /intranetdialog/login.asp |-|ASP_0147|500_Server_Error 500 -
|
|
| Any hints?
|
| Flemming
| "Rob Greene" <a-****@online.microsoft.com> wrote in message
| news:iq***************@cpmsftngxa06.phx.gbl...
| > | Which close: the connection, the Command object, or ...?
| > |
| > | Have you seen something written about this - where?
| >
| > I have nothing in writing about this, What I know is that IIS itself does
| not know what the application is doing or what resources the application
| > has opened. IIS will keep a Session open for your client, and it keeps
| the Application open. If you are placing objects in session of
| > application variables, and not closing them correctly, then this would
| account for the resource consumption resulting in problems. Because
| > you seem to be closing the resources, and because I know that IIS itself
| does not maintain resources like this, and because I know very little
| > about V.FoxPro, I was suggesting that maybe there is a visual fox pro
| newsgroup which has seen this issue.
| >
| > Do you have error numbers listed in the IIS logs, a number like 0x800xxxxx
| or -2xxxxxxxxxx type of number? If not, can you paste IIS log entry
| > here?
| >
| > -rwg
| > This is what I think, not necessarily what is accurate!
| >
| > --------------------
| > | From: "flemming eriksen" <fn************@kabnospama.com>
| > | References: <OL**************@TK2MSFTNGP10.phx.gbl>
| <7m*************@cpmsftngxa06.phx.gbl>
| > | Subject: Re: Too many variable.
| > | Date: Mon, 8 Mar 2004 07:14:41 +0100
| > | Lines: 18
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| > | X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| > | Message-ID: <#W**************@TK2MSFTNGP12.phx.gbl>
| > | Newsgroups: microsoft.public.inetserver.asp.general
| > | NNTP-Posting-Host: 193.192.244.130
| > | Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.phx.gbl
| > | Xref: cpmsftngxa06.phx.gbl
| microsoft.public.inetserver.asp.general:267714
| > | X-Tomcat-NG: microsoft.public.inetserver.asp.general
| > |
| > | Rob.
| > |
| > | Which close: the connection, the Command object, or ...?
| > |
| > | Have you seen something written about this - where?
| > |
| > | Regards,
| > | flemming
| > | "Rob Greene" <a-****@online.microsoft.com> wrote in message
| > | news:7m*************@cpmsftngxa06.phx.gbl...
| > | > Could this be Visual Fox Pro not handling the close?
| > | >
| > | > -rwg
| > | > This is what I think, not necessarily what is accurate!
| > | >
| > | >
| > |
| > |
| > |
| >
| >
|
|
|
Jul 19 '05 #6
New Post

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
Help with variable substitution using XSL
by: Scott | last post by:
I have an XML Document in a format like: <Variable name="Bob">ABCDEFG</Variable> <Variable name="Steve">QWERTYUI</Variable> <Variable name="John">POIUYTR</Variable> <Variable...
.NET Framework
4
Generate variable name from node values in xslt
by: Frederik Sørensen | last post by:
I include a xslt stylesheet with variables for all the error messages in my system. <xsl:variable name="Banner_error_1"> errormessage 1 for banner </xsl:variable> <xsl:variable...
.NET Framework
134
"no variable or argument declarations are necessary."
by: James A. Donald | last post by:
I am contemplating getting into Python, which is used by engineers I admire - google and Bram Cohen, but was horrified to read "no variable or argument declarations are necessary." Surely that...
Python
10
Set the value of a variable using a variable
by: Blaxer | last post by:
There is probably a really easy way to do this, so please forgive me but I would like to set the value of a variable from a variable, an example would be... function Calculate_Something(ByVal...
Visual Basic .NET
23
Dynamic variable names
by: Russ Chinoy | last post by:
Hi, This may be a totally newbie question, but I'm stumped. If I have a function such as: function DoSomething(strVarName) { ..... }
Javascript
3
referencing an xslt variable
by: rls03 | last post by:
I have the following which creates a variable containing a relative path where <xsl:value-of select="."/returns a portion of the filename: <xsl:variable...
.NET Framework
1
pbmods
Variable Scope in JavaScript
by: pbmods | last post by:
VARIABLE SCOPE IN JAVASCRIPT LEVEL: BEGINNER/INTERMEDIATE (INTERMEDIATE STUFF IN ) PREREQS: VARIABLES First off, what the heck is 'scope' (the kind that doesn't help kill the germs that cause...
Javascript
2
variable instantiation & eval
by: Florian Loitsch | last post by:
hi, What should be the output of the following code-snippet? === var x = "global"; function f() { var x = 0; eval("function x() { return false; }"); delete x; alert(x); }
Javascript
37
Static variable vs Class variable
by: minkoo.seo | last post by:
Hi. I've got a question on the differences and how to define static and class variables. AFAIK, class methods are the ones which receives the class itself as an argument, while static methods...
Python
112
How to eliminate this global variable, silent?
by: istillshine | last post by:
When I control if I print messages, I usually use a global variable "int silent". When I set "-silent" flag in my command line parameters, I set silent = 1 in my main.c. I have many functions...
C / C++
0
Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
General
0
How to turn on java script in a villaon keypad mobile phone
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
Java
0
Basic Javascript concepts
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
Javascript
0
Merging data from multiple Excel files
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
Data Management
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
1
Is that possible of reading the .csv file in column wise and the column have different lengths ?
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
C / C++
0
How to build RAID in BIOS?
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
Computer Hardware
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!