Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How do I free a prepared statement with .NET Data Provider on PocketPC?

13 posts in General Discussion Last posting was on 2003-09-08 13:13:26.0Z
metalcrypt/allosy Posted on 2003-08-12 14:16:58.0Z
Sender: 54e6.3f38f6cc.1804289383@sybase.com
From: metalcrypt/allosy
Newsgroups: ianywhere.public.general
Subject: How do I free a prepared statement with .NET Data Provider on PocketPC?
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f38f6f2.54ee.846930886@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 12 Aug 2003 07:17:22 -0700, 10.22.241.42
Lines: 54
NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
Date: 12 Aug 2003 07:16:58 -0700
X-Trace: forums-1-dub 1060697818 10.22.241.42 (12 Aug 2003 07:16:58 -0700)
X-Original-Trace: 12 Aug 2003 07:16:58 -0700, forums-2-dub.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1568
Article PK: 3797

Hello,

I've run into a problem developing an application on a
Pocket PC running the ASA 8.02 .NET Data Provider for the
Compact Framework, using Visual Basic.NET.

I have a form that lets the user add items by clicking on a
button. When the add button is clicked, I check to see if
the item is already in the database before adding it to a
list of items to be added (that list is just a table in
memory, not an ASA table)... So far so good.

I have an ASAConnection that I open at the start of the
application. I use an ASACommand that executes a SELECT
statement to check for the presence of the item to be added
(i.e. it returns only a single value.) This works fine too
but....

My boss was toying around with it, clicking add/remove
repeatedly. Eventually an exception popped up, saying
"resource governor for 'prepared statements' exceeded". So
somehow it doesn't like the multiple ASACommands being
executed when playing like that. :)

I searched this newsgroup for this error and there is talk
of "freeing the prepared statements". How do I do this with
the .NET Data Provider for the .NET CF? I've tried several
things:

- Dispose of the ASACommand object
- Cancel of the ASACommand object (out of desperation)
- Closing the connection after each command
- Disposing of the connection and re-opening a new one
- Force garbage collection after all of the above

The above for each and every run of the ASACommand (it's in
a separate procedure, so it was relatively easy to wreck
havoc in there.. :))

I don't think increasing the MAX_STATEMENT_COUNT would solve
the problem - it would only displace it. It is quite
probable that the user could use this several hundred times
- and the Pocket PC has limited resources, so I figure if I
set it to 0, it could run out of memory during an intensive
workday. Beside, I don't even know how to change
MAX_STATEMENT_COUNT on the PDA... Everything I've seen seems
to relate to PCs, not PDAs... :(

Any help would be greatly appreciated!!!

thanks,
Michel
metalcrypt666 @ NO hotmail SPAM . com (you know what to do
to clean up the address ;))


Jason Hinsperger Posted on 2003-08-12 21:17:36.0Z
From: "Jason Hinsperger" <NOJason_HinspergerSPAM@hotmail.com>
Newsgroups: ianywhere.public.general
References: <3f38f6f2.54ee.846930886@sybase.com>
Subject: Re: How do I free a prepared statement with .NET Data Provider on PocketPC?
Lines: 75
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
NNTP-Posting-Host: hinsperg-pc1.sybase.com
X-Original-NNTP-Posting-Host: hinsperg-pc1.sybase.com
Message-ID: <3f395970$1@forums-1-dub>
Date: 12 Aug 2003 14:17:36 -0700
X-Trace: forums-1-dub 1060723056 172.31.143.226 (12 Aug 2003 14:17:36 -0700)
X-Original-Trace: 12 Aug 2003 14:17:36 -0700, hinsperg-pc1.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1578
Article PK: 3807

Of the methods that you tried, which ones did/did not work?
There was an issue where the statement would not be dropped if the command
was deleted before the reader was closed. This is fixed in ASA 8.0.2 ebf
4278 and later. If you do not have this ebf, make sure to close your
ASAReader before deleting the ASACommand object.

--
Jason Hinsperger
International and Sustaining Engineering
iAnywhere Solutions

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
--

<metalcrypt/allosy> wrote in message
news:3f38f6f2.54ee.846930886@sybase.com...
> Hello,
>
> I've run into a problem developing an application on a
> Pocket PC running the ASA 8.02 .NET Data Provider for the
> Compact Framework, using Visual Basic.NET.
>
> I have a form that lets the user add items by clicking on a
> button. When the add button is clicked, I check to see if
> the item is already in the database before adding it to a
> list of items to be added (that list is just a table in
> memory, not an ASA table)... So far so good.
>
> I have an ASAConnection that I open at the start of the
> application. I use an ASACommand that executes a SELECT
> statement to check for the presence of the item to be added
> (i.e. it returns only a single value.) This works fine too
> but....
>
> My boss was toying around with it, clicking add/remove
> repeatedly. Eventually an exception popped up, saying
> "resource governor for 'prepared statements' exceeded". So
> somehow it doesn't like the multiple ASACommands being
> executed when playing like that. :)
>
> I searched this newsgroup for this error and there is talk
> of "freeing the prepared statements". How do I do this with
> the .NET Data Provider for the .NET CF? I've tried several
> things:
>
> - Dispose of the ASACommand object
> - Cancel of the ASACommand object (out of desperation)
> - Closing the connection after each command
> - Disposing of the connection and re-opening a new one
> - Force garbage collection after all of the above
>
> The above for each and every run of the ASACommand (it's in
> a separate procedure, so it was relatively easy to wreck
> havoc in there.. :))
>
> I don't think increasing the MAX_STATEMENT_COUNT would solve
> the problem - it would only displace it. It is quite
> probable that the user could use this several hundred times
> - and the Pocket PC has limited resources, so I figure if I
> set it to 0, it could run out of memory during an intensive
> workday. Beside, I don't even know how to change
> MAX_STATEMENT_COUNT on the PDA... Everything I've seen seems
> to relate to PCs, not PDAs... :(
>
> Any help would be greatly appreciated!!!
>
> thanks,
> Michel
> metalcrypt666 @ NO hotmail SPAM . com (you know what to do
> to clean up the address ;))


Michel Renaud Posted on 2003-08-13 00:34:56.0Z
Sender: 3b8a.3f398475.1804289383@sybase.com
From: Michel Renaud
Newsgroups: ianywhere.public.general
Subject: Re: How do I free a prepared statement with .NET Data Provider on PocketPC?
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f3987b0.3bd3.846930886@sybase.com>
References: <3f38f6f2.54ee.846930886@sybase.com><3f395970$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Aug 2003 17:34:56 -0700
X-Trace: forums-1-dub 1060734896 10.22.241.41 (12 Aug 2003 17:34:56 -0700)
X-Original-Trace: 12 Aug 2003 17:34:56 -0700, 10.22.241.41
Lines: 112
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1580
Article PK: 3810

Sorry, I thought I was clear in saying none of them worked.
:) I've also looked at the Solved Cases for help but
nothing there could resolve the problem. I have the latest
EBF update for Windows CE (May 14).

After posting earlier, I created a single form app in VB.Net
that simply runs a SELECT COUNT(*) on an empty table. I
open one ASAConnection when the program starts, then I click
a button that simply runs the ASACommand with the SELECT
query. After doing that 50 times, I get the error. Of
course, if I set MAX_STATEMENT_COUNT to 0, I can run that
several thousand times before the ASA temp file exceeds the
PocketPC's storage limit. Not an option.

One of the solved cases mentions something about setting
pooling=off and closing the connection to ensure everything
is freed, but that is not acceptable on the Pocket PC -
that's just too limiting, and more importantly, on
re-opening the connection when pooling is off, it has to
restart the whole ASA server again. Best way to be lynched
by the users. :) The connection must either be pooled, or
stay open during the whole session (essentially a whole
day.) But during the course of a day, a user can well
exceed the number of prepared statements allowed and/or
exceed storage space because of the ASA temp file.

Maybe it's just something I'm doing wrong... But I wonder
why a SELECT is treated as a prepared statement? I can send
you the sample project if it can be of any help...

thanks,
Michel

> Of the methods that you tried, which ones did/did not
> work? There was an issue where the statement would not be
> dropped if the command was deleted before the reader was
> closed. This is fixed in ASA 8.0.2 ebf 4278 and later.
> If you do not have this ebf, make sure to close your
> ASAReader before deleting the ASACommand object.
>
> --
> Jason Hinsperger
> International and Sustaining Engineering
> iAnywhere Solutions
>
> Whitepapers, TechDocs, and bug fixes are all available
> through the iAnywhere Developer Community at
> www.ianywhere.com/developer --
>
>
>
> <metalcrypt/allosy> wrote in message
> news:3f38f6f2.54ee.846930886@sybase.com...
> > Hello,
> >
> > I've run into a problem developing an application on a
> > Pocket PC running the ASA 8.02 .NET Data Provider for
> > the Compact Framework, using Visual Basic.NET.
> >
> > I have a form that lets the user add items by clicking
> > on a button. When the add button is clicked, I check to
> > see if the item is already in the database before adding
> > it to a list of items to be added (that list is just a
> > table in memory, not an ASA table)... So far so good.
> >
> > I have an ASAConnection that I open at the start of the
> > application. I use an ASACommand that executes a SELECT
> > statement to check for the presence of the item to be
> > added (i.e. it returns only a single value.) This works
> > fine too but....
> >
> > My boss was toying around with it, clicking add/remove
> > repeatedly. Eventually an exception popped up, saying
> > "resource governor for 'prepared statements' exceeded".
> > So somehow it doesn't like the multiple ASACommands
> > being executed when playing like that. :)
> >
> > I searched this newsgroup for this error and there is
> > talk of "freeing the prepared statements". How do I do
> > this with the .NET Data Provider for the .NET CF? I've
> > tried several things:
> >
> > - Dispose of the ASACommand object
> > - Cancel of the ASACommand object (out of desperation)
> > - Closing the connection after each command
> > - Disposing of the connection and re-opening a new one
> > - Force garbage collection after all of the above
> >
> > The above for each and every run of the ASACommand (it's
> > in a separate procedure, so it was relatively easy to
> > wreck havoc in there.. :))
> >
> > I don't think increasing the MAX_STATEMENT_COUNT would
> > solve the problem - it would only displace it. It is
> > quite probable that the user could use this several
> > hundred times - and the Pocket PC has limited resources,
> > so I figure if I set it to 0, it could run out of memory
> > during an intensive workday. Beside, I don't even know
> > how to change MAX_STATEMENT_COUNT on the PDA...
> > Everything I've seen seems to relate to PCs, not PDAs...
> :( >
> > Any help would be greatly appreciated!!!
> >
> > thanks,
> > Michel
> > metalcrypt666 @ NO hotmail SPAM . com (you know what to
> > do to clean up the address ;))
>
>


"Bruce Hay" Posted on 2003-08-13 12:59:41.0Z
From: "Bruce Hay" <hay at sybase dot com>
Newsgroups: ianywhere.public.general
References: <3f38f6f2.54ee.846930886@sybase.com><3f395970$1@forums-1-dub> <3f3987b0.3bd3.846930886@sybase.com>
Subject: Re: How do I free a prepared statement with .NET Data Provider on PocketPC?
Lines: 123
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: hay-xp.sybase.com
Message-ID: <3f3a363e$1@forums-2-dub>
X-Original-Trace: 13 Aug 2003 05:59:42 -0700, hay-xp.sybase.com
NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
Date: 13 Aug 2003 05:59:41 -0700
X-Trace: forums-1-dub 1060779581 10.22.241.42 (13 Aug 2003 05:59:41 -0700)
X-Original-Trace: 13 Aug 2003 05:59:41 -0700, forums-2-dub.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1582
Article PK: 3815

If you can build and run your app on NT/XP/Win2K, you might try downloading
the most recent EBF for Windows (which includes the fix Jason mentioned) and
see if that fixes your problem. If it does, then you just need a more recent
EBF for CE.

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

<Michel Renaud> wrote in message news:3f3987b0.3bd3.846930886@sybase.com...
> Sorry, I thought I was clear in saying none of them worked.
> :) I've also looked at the Solved Cases for help but
> nothing there could resolve the problem. I have the latest
> EBF update for Windows CE (May 14).
>
> After posting earlier, I created a single form app in VB.Net
> that simply runs a SELECT COUNT(*) on an empty table. I
> open one ASAConnection when the program starts, then I click
> a button that simply runs the ASACommand with the SELECT
> query. After doing that 50 times, I get the error. Of
> course, if I set MAX_STATEMENT_COUNT to 0, I can run that
> several thousand times before the ASA temp file exceeds the
> PocketPC's storage limit. Not an option.
>
> One of the solved cases mentions something about setting
> pooling=off and closing the connection to ensure everything
> is freed, but that is not acceptable on the Pocket PC -
> that's just too limiting, and more importantly, on
> re-opening the connection when pooling is off, it has to
> restart the whole ASA server again. Best way to be lynched
> by the users. :) The connection must either be pooled, or
> stay open during the whole session (essentially a whole
> day.) But during the course of a day, a user can well
> exceed the number of prepared statements allowed and/or
> exceed storage space because of the ASA temp file.
>
> Maybe it's just something I'm doing wrong... But I wonder
> why a SELECT is treated as a prepared statement? I can send
> you the sample project if it can be of any help...
>
> thanks,
> Michel
>
>
>
>
> > Of the methods that you tried, which ones did/did not
> > work? There was an issue where the statement would not be
> > dropped if the command was deleted before the reader was
> > closed. This is fixed in ASA 8.0.2 ebf 4278 and later.
> > If you do not have this ebf, make sure to close your
> > ASAReader before deleting the ASACommand object.
> >
> > --
> > Jason Hinsperger
> > International and Sustaining Engineering
> > iAnywhere Solutions
> >
> > Whitepapers, TechDocs, and bug fixes are all available
> > through the iAnywhere Developer Community at
> > www.ianywhere.com/developer --
> >
> >
> >
> > <metalcrypt/allosy> wrote in message
> > news:3f38f6f2.54ee.846930886@sybase.com...
> > > Hello,
> > >
> > > I've run into a problem developing an application on a
> > > Pocket PC running the ASA 8.02 .NET Data Provider for
> > > the Compact Framework, using Visual Basic.NET.
> > >
> > > I have a form that lets the user add items by clicking
> > > on a button. When the add button is clicked, I check to
> > > see if the item is already in the database before adding
> > > it to a list of items to be added (that list is just a
> > > table in memory, not an ASA table)... So far so good.
> > >
> > > I have an ASAConnection that I open at the start of the
> > > application. I use an ASACommand that executes a SELECT
> > > statement to check for the presence of the item to be
> > > added (i.e. it returns only a single value.) This works
> > > fine too but....
> > >
> > > My boss was toying around with it, clicking add/remove
> > > repeatedly. Eventually an exception popped up, saying
> > > "resource governor for 'prepared statements' exceeded".
> > > So somehow it doesn't like the multiple ASACommands
> > > being executed when playing like that. :)
> > >
> > > I searched this newsgroup for this error and there is
> > > talk of "freeing the prepared statements". How do I do
> > > this with the .NET Data Provider for the .NET CF? I've
> > > tried several things:
> > >
> > > - Dispose of the ASACommand object
> > > - Cancel of the ASACommand object (out of desperation)
> > > - Closing the connection after each command
> > > - Disposing of the connection and re-opening a new one
> > > - Force garbage collection after all of the above
> > >
> > > The above for each and every run of the ASACommand (it's
> > > in a separate procedure, so it was relatively easy to
> > > wreck havoc in there.. :))
> > >
> > > I don't think increasing the MAX_STATEMENT_COUNT would
> > > solve the problem - it would only displace it. It is
> > > quite probable that the user could use this several
> > > hundred times - and the Pocket PC has limited resources,
> > > so I figure if I set it to 0, it could run out of memory
> > > during an intensive workday. Beside, I don't even know
> > > how to change MAX_STATEMENT_COUNT on the PDA...
> > > Everything I've seen seems to relate to PCs, not PDAs...
> > :( >
> > > Any help would be greatly appreciated!!!
> > >
> > > thanks,
> > > Michel
> > > metalcrypt666 @ NO hotmail SPAM . com (you know what to
> > > do to clean up the address ;))
> >
> >


Michel Renaud Posted on 2003-08-13 13:18:51.0Z
Sender: 63e8.3f3a39e4.1804289383@sybase.com
From: Michel Renaud
Newsgroups: ianywhere.public.general
Subject: Re: How do I free a prepared statement with .NET Data Provider on PocketPC?
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f3a3abd.63f5.846930886@sybase.com>
References: <3f38f6f2.54ee.846930886@sybase.com><3f395970$1@forums-1-dub> <3f3987b0.3bd3.846930886@sybase.com><3f3a363e$1@forums-2-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 13 Aug 2003 06:18:54 -0700, 10.22.241.42
Lines: 144
NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
Date: 13 Aug 2003 06:18:51 -0700
X-Trace: forums-1-dub 1060780731 10.22.241.42 (13 Aug 2003 06:18:51 -0700)
X-Original-Trace: 13 Aug 2003 06:18:51 -0700, forums-2-dub.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1583
Article PK: 3811

Coincidentally, I just tried my "test app" on Win2K a few
minutes ago. No problem on that platform, I can execute the
command several times without problems. So it seems like
the problem is specific to the ADO.NET Data Provider on
Windows CE. However, I have the latest EBF build for CE, so
I'm pretty much stuck. Any way to have someone on the CE
team check this one out?

By the way, I have an older build of the Win2K version. The
problem I have is not related to the fix Jason mentioned -
I'm only using an ASACommand for this test app, not a
datareader.

thanks,
Michel

> If you can build and run your app on NT/XP/Win2K, you
> might try downloading the most recent EBF for Windows
> (which includes the fix Jason mentioned) and see if that
> fixes your problem. If it does, then you just need a more
> recent EBF for CE.
>
> Whitepapers, TechDocs, bug fixes are all available through
> the iAnywhere Developer Community at
> http://www.ianywhere.com/developer
>
> <Michel Renaud> wrote in message
> > news:3f3987b0.3bd3.846930886@sybase.com... Sorry, I
> > thought I was clear in saying none of them worked. :)
> > I've also looked at the Solved Cases for help but
> nothing there could resolve the problem. I have the
> > latest EBF update for Windows CE (May 14).
> >
> > After posting earlier, I created a single form app in
> > VB.Net that simply runs a SELECT COUNT(*) on an empty
> > table. I open one ASAConnection when the program starts
> > , then I click a button that simply runs the ASACommand
> > with the SELECT query. After doing that 50 times, I get
> > the error. Of course, if I set MAX_STATEMENT_COUNT to 0
> > , I can run that several thousand times before the ASA
> > temp file exceeds the PocketPC's storage limit. Not an
> option. >
> > One of the solved cases mentions something about setting
> > pooling=off and closing the connection to ensure
> > everything is freed, but that is not acceptable on the
> > Pocket PC - that's just too limiting, and more
> > importantly, on re-opening the connection when pooling
> > is off, it has to restart the whole ASA server again.
> > Best way to be lynched by the users. :) The connection
> > must either be pooled, or stay open during the whole
> > session (essentially a whole day.) But during the
> > course of a day, a user can well exceed the number of
> > prepared statements allowed and/or exceed storage space
> because of the ASA temp file. >
> > Maybe it's just something I'm doing wrong... But I
> > wonder why a SELECT is treated as a prepared statement?
> > I can send you the sample project if it can be of any
> help... >
> > thanks,
> > Michel
> >
> >
> >
> >
> > > Of the methods that you tried, which ones did/did not
> > > work? There was an issue where the statement would not
> > > be dropped if the command was deleted before the
> > > reader was closed. This is fixed in ASA 8.0.2 ebf
> > > 4278 and later. If you do not have this ebf, make sure
> > > to close your ASAReader before deleting the ASACommand
> > object. >
> > > --
> > > Jason Hinsperger
> > > International and Sustaining Engineering
> > > iAnywhere Solutions
> > >
> > > Whitepapers, TechDocs, and bug fixes are all available
> > > through the iAnywhere Developer Community at
> > > www.ianywhere.com/developer --
> > >
> > >
> > >
> > > <metalcrypt/allosy> wrote in message
> > > news:3f38f6f2.54ee.846930886@sybase.com...
> > > > Hello,
> > > >
> > > > I've run into a problem developing an application on
> > > > a Pocket PC running the ASA 8.02 .NET Data Provider
> > > > for the Compact Framework, using Visual Basic.NET.
> > > >
> > > > I have a form that lets the user add items by
> > > > clicking on a button. When the add button is
> > > > clicked, I check to see if the item is already in
> > > > the database before adding it to a list of items to
> > > > be added (that list is just a table in memory, not
> > > an ASA table)... So far so good. >
> > > > I have an ASAConnection that I open at the start of
> > > > the application. I use an ASACommand that executes
> > > > a SELECT statement to check for the presence of the
> > > > item to be added (i.e. it returns only a single
> > > > value.) This works fine too but....
> > > >
> > > > My boss was toying around with it, clicking
> > > > add/remove repeatedly. Eventually an exception
> > > > popped up, saying "resource governor for 'prepared
> > > > statements' exceeded". So somehow it doesn't like
> > > > the multiple ASACommands being executed when playing
> > > like that. :) >
> > > > I searched this newsgroup for this error and there
> > > > is talk of "freeing the prepared statements". How
> > > > do I do this with the .NET Data Provider for the
> > > > .NET CF? I've tried several things:
> > > >
> > > > - Dispose of the ASACommand object
> > > > - Cancel of the ASACommand object (out of
> > > > desperation) - Closing the connection after each
> > > > command - Disposing of the connection and re-opening
> > > > a new one - Force garbage collection after all of
> > > the above >
> > > > The above for each and every run of the ASACommand
> > > > (it's in a separate procedure, so it was relatively
> > > > easy to wreck havoc in there.. :))
> > > >
> > > > I don't think increasing the MAX_STATEMENT_COUNT
> > > > would solve the problem - it would only displace it.
> > > > It is quite probable that the user could use this
> > > > several hundred times - and the Pocket PC has
> > > > limited resources, so I figure if I set it to 0, it
> > > > could run out of memory during an intensive workday.
> > > > Beside, I don't even know how to change
> > > > MAX_STATEMENT_COUNT on the PDA... Everything I've
> > > seen seems to relate to PCs, not PDAs... :( >
> > > > Any help would be greatly appreciated!!!
> > > >
> > > > thanks,
> > > > Michel
> > > > metalcrypt666 @ NO hotmail SPAM . com (you know
> > > > what to do to clean up the address ;))
> > >
> > >
>
>


"Bruce Hay" Posted on 2003-08-13 13:52:57.0Z
From: "Bruce Hay" <hay at sybase dot com>
Newsgroups: ianywhere.public.general
References: <3f38f6f2.54ee.846930886@sybase.com><3f395970$1@forums-1-dub> <3f3987b0.3bd3.846930886@sybase.com><3f3a363e$1@forums-2-dub> <3f3a3abd.63f5.846930886@sybase.com>
Subject: Re: How do I free a prepared statement with .NET Data Provider on PocketPC?
Lines: 153
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: hay-xp.sybase.com
X-Original-NNTP-Posting-Host: hay-xp.sybase.com
Message-ID: <3f3a42b9$1@forums-1-dub>
Date: 13 Aug 2003 06:52:57 -0700
X-Trace: forums-1-dub 1060782777 172.31.142.57 (13 Aug 2003 06:52:57 -0700)
X-Original-Trace: 13 Aug 2003 06:52:57 -0700, hay-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1585
Article PK: 3813

Providing the source for the test app that reproduces the problem is the
place to start. You can post it here or open a case via Case Express.
Capturing a request log on CE would also be useful (add -zr all -zo
request.out to server start line, or use sa_server_option() stored procedure
to enable logging).

<Michel Renaud> wrote in message news:3f3a3abd.63f5.846930886@sybase.com...
> Coincidentally, I just tried my "test app" on Win2K a few
> minutes ago. No problem on that platform, I can execute the
> command several times without problems. So it seems like
> the problem is specific to the ADO.NET Data Provider on
> Windows CE. However, I have the latest EBF build for CE, so
> I'm pretty much stuck. Any way to have someone on the CE
> team check this one out?
>
> By the way, I have an older build of the Win2K version. The
> problem I have is not related to the fix Jason mentioned -
> I'm only using an ASACommand for this test app, not a
> datareader.
>
> thanks,
> Michel
>
>
>
> > If you can build and run your app on NT/XP/Win2K, you
> > might try downloading the most recent EBF for Windows
> > (which includes the fix Jason mentioned) and see if that
> > fixes your problem. If it does, then you just need a more
> > recent EBF for CE.
> >
> > Whitepapers, TechDocs, bug fixes are all available through
> > the iAnywhere Developer Community at
> > http://www.ianywhere.com/developer
> >
> > <Michel Renaud> wrote in message
> > > news:3f3987b0.3bd3.846930886@sybase.com... Sorry, I
> > > thought I was clear in saying none of them worked. :)
> > > I've also looked at the Solved Cases for help but
> > nothing there could resolve the problem. I have the
> > > latest EBF update for Windows CE (May 14).
> > >
> > > After posting earlier, I created a single form app in
> > > VB.Net that simply runs a SELECT COUNT(*) on an empty
> > > table. I open one ASAConnection when the program starts
> > > , then I click a button that simply runs the ASACommand
> > > with the SELECT query. After doing that 50 times, I get
> > > the error. Of course, if I set MAX_STATEMENT_COUNT to 0
> > > , I can run that several thousand times before the ASA
> > > temp file exceeds the PocketPC's storage limit. Not an
> > option. >
> > > One of the solved cases mentions something about setting
> > > pooling=off and closing the connection to ensure
> > > everything is freed, but that is not acceptable on the
> > > Pocket PC - that's just too limiting, and more
> > > importantly, on re-opening the connection when pooling
> > > is off, it has to restart the whole ASA server again.
> > > Best way to be lynched by the users. :) The connection
> > > must either be pooled, or stay open during the whole
> > > session (essentially a whole day.) But during the
> > > course of a day, a user can well exceed the number of
> > > prepared statements allowed and/or exceed storage space
> > because of the ASA temp file. >
> > > Maybe it's just something I'm doing wrong... But I
> > > wonder why a SELECT is treated as a prepared statement?
> > > I can send you the sample project if it can be of any
> > help... >
> > > thanks,
> > > Michel
> > >
> > >
> > >
> > >
> > > > Of the methods that you tried, which ones did/did not
> > > > work? There was an issue where the statement would not
> > > > be dropped if the command was deleted before the
> > > > reader was closed. This is fixed in ASA 8.0.2 ebf
> > > > 4278 and later. If you do not have this ebf, make sure
> > > > to close your ASAReader before deleting the ASACommand
> > > object. >
> > > > --
> > > > Jason Hinsperger
> > > > International and Sustaining Engineering
> > > > iAnywhere Solutions
> > > >
> > > > Whitepapers, TechDocs, and bug fixes are all available
> > > > through the iAnywhere Developer Community at
> > > > www.ianywhere.com/developer --
> > > >
> > > >
> > > >
> > > > <metalcrypt/allosy> wrote in message
> > > > news:3f38f6f2.54ee.846930886@sybase.com...
> > > > > Hello,
> > > > >
> > > > > I've run into a problem developing an application on
> > > > > a Pocket PC running the ASA 8.02 .NET Data Provider
> > > > > for the Compact Framework, using Visual Basic.NET.
> > > > >
> > > > > I have a form that lets the user add items by
> > > > > clicking on a button. When the add button is
> > > > > clicked, I check to see if the item is already in
> > > > > the database before adding it to a list of items to
> > > > > be added (that list is just a table in memory, not
> > > > an ASA table)... So far so good. >
> > > > > I have an ASAConnection that I open at the start of
> > > > > the application. I use an ASACommand that executes
> > > > > a SELECT statement to check for the presence of the
> > > > > item to be added (i.e. it returns only a single
> > > > > value.) This works fine too but....
> > > > >
> > > > > My boss was toying around with it, clicking
> > > > > add/remove repeatedly. Eventually an exception
> > > > > popped up, saying "resource governor for 'prepared
> > > > > statements' exceeded". So somehow it doesn't like
> > > > > the multiple ASACommands being executed when playing
> > > > like that. :) >
> > > > > I searched this newsgroup for this error and there
> > > > > is talk of "freeing the prepared statements". How
> > > > > do I do this with the .NET Data Provider for the
> > > > > .NET CF? I've tried several things:
> > > > >
> > > > > - Dispose of the ASACommand object
> > > > > - Cancel of the ASACommand object (out of
> > > > > desperation) - Closing the connection after each
> > > > > command - Disposing of the connection and re-opening
> > > > > a new one - Force garbage collection after all of
> > > > the above >
> > > > > The above for each and every run of the ASACommand
> > > > > (it's in a separate procedure, so it was relatively
> > > > > easy to wreck havoc in there.. :))
> > > > >
> > > > > I don't think increasing the MAX_STATEMENT_COUNT
> > > > > would solve the problem - it would only displace it.
> > > > > It is quite probable that the user could use this
> > > > > several hundred times - and the Pocket PC has
> > > > > limited resources, so I figure if I set it to 0, it
> > > > > could run out of memory during an intensive workday.
> > > > > Beside, I don't even know how to change
> > > > > MAX_STATEMENT_COUNT on the PDA... Everything I've
> > > > seen seems to relate to PCs, not PDAs... :( >
> > > > > Any help would be greatly appreciated!!!
> > > > >
> > > > > thanks,
> > > > > Michel
> > > > > metalcrypt666 @ NO hotmail SPAM . com (you know
> > > > > what to do to clean up the address ;))
> > > >
> > > >
> >
> >


Michel Renaud Posted on 2003-08-13 15:02:29.0Z
Sender: 452b.3f3a4c71.1804289383@sybase.com
From: Michel Renaud
Newsgroups: ianywhere.public.general
Subject: Re: How do I free a prepared statement with .NET Data Provider on PocketPC?
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f3a5305.46d2.846930886@sybase.com>
References: <3f38f6f2.54ee.846930886@sybase.com><3f395970$1@forums-1-dub> <3f3987b0.3bd3.846930886@sybase.com><3f3a363e$1@forums-2-dub> <3f3a3abd.63f5.846930886@sybase.com><3f3a42b9$1@forums-1-dub>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub3f3a5305"
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Aug 2003 08:02:29 -0700
X-Trace: forums-1-dub 1060786949 10.22.241.41 (13 Aug 2003 08:02:29 -0700)
X-Original-Trace: 13 Aug 2003 08:02:29 -0700, 10.22.241.41
Lines: 400
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1588
Article PK: 3816

I don't know anything about Case Express so let's do it
here: The enclosed ZIP file contains a very simple VB.Net
application: It's a form with one button. Click the button
to execute the SELECT statement on the db (I didn't include
the database in this, just use any db and change the SELECT
to query some table - that doesn't matter.)

There's a log file named "request.out" in the ZIP file that
is the result of hitting the button 21 times (to reduce
testing time, I set the MAX_STATEMENT_COUNT to 20.) I also
added request_win2k.log, which is the result from running
the same application on Windows 2000. As you can see, I was
able to exceed 20 when running on that platform, unlike on
WinCE.

Let me know if you need any additional information.

thanks,
Michel

> Providing the source for the test app that reproduces the
> problem is the place to start. You can post it here or
> open a case via Case Express. Capturing a request log on
> CE would also be useful (add -zr all -zo request.out to
> server start line, or use sa_server_option() stored
> procedure to enable logging).
>
> <Michel Renaud> wrote in message
> > news:3f3a3abd.63f5.846930886@sybase.com...
> > Coincidentally, I just tried my "test app" on Win2K a
> few minutes ago. No problem on that platform, I can
> > execute the command several times without problems. So
> > it seems like the problem is specific to the ADO.NET
> > Data Provider on Windows CE. However, I have the latest
> > EBF build for CE, so I'm pretty much stuck. Any way to
> > have someone on the CE team check this one out?
> >
> > By the way, I have an older build of the Win2K version.
> > The problem I have is not related to the fix Jason
> > mentioned - I'm only using an ASACommand for this test
> > app, not a datareader.
> >
> > thanks,
> > Michel
> >
> >
> >
> > > If you can build and run your app on NT/XP/Win2K, you
> > > might try downloading the most recent EBF for Windows
> > > (which includes the fix Jason mentioned) and see if
> > > that fixes your problem. If it does, then you just
> > > need a more recent EBF for CE.
> > >
> > > Whitepapers, TechDocs, bug fixes are all available
> > > through the iAnywhere Developer Community at
> > > http://www.ianywhere.com/developer
> > >
> > > <Michel Renaud> wrote in message
> > > > news:3f3987b0.3bd3.846930886@sybase.com... Sorry, I
> > > > thought I was clear in saying none of them worked.
> > > > :) I've also looked at the Solved Cases for help but
> > > nothing there could resolve the problem. I have the
> > > > latest EBF update for Windows CE (May 14).
> > > >
> > > > After posting earlier, I created a single form app
> > > > in VB.Net that simply runs a SELECT COUNT(*) on an
> > > > empty table. I open one ASAConnection when the
> > > > program starts , then I click a button that simply
> > > > runs the ASACommand with the SELECT query. After
> > > > doing that 50 times, I get the error. Of course, if
> > > > I set MAX_STATEMENT_COUNT to 0 , I can run that
> > > > several thousand times before the ASA temp file
> > > exceeds the PocketPC's storage limit. Not an option.
> > > > > One of the solved cases mentions something about
> > > > setting pooling=off and closing the connection to
> > > > ensure everything is freed, but that is not
> > > > acceptable on the Pocket PC - that's just too
> > > > limiting, and more importantly, on re-opening the
> > > > connection when pooling is off, it has to restart
> > > > the whole ASA server again. Best way to be lynched
> > > > by the users. :) The connection must either be
> > > > pooled, or stay open during the whole session
> > > > (essentially a whole day.) But during the course of
> > > > a day, a user can well exceed the number of prepared
> > > statements allowed and/or exceed storage space because
> > > > of the ASA temp file. > Maybe it's just something
> > > > I'm doing wrong... But I wonder why a SELECT is
> > > > treated as a prepared statement? I can send you the
> > > sample project if it can be of any help... >
> > > > thanks,
> > > > Michel
> > > >
> > > >
> > > >
> > > >
> > > > > Of the methods that you tried, which ones did/did
> > > > > not work? There was an issue where the statement
> > > > > would not be dropped if the command was deleted
> > > > > before the reader was closed. This is fixed in
> > > > > ASA 8.0.2 ebf 4278 and later. If you do not have
> > > > > this ebf, make sure to close your ASAReader before
> > > > deleting the ASACommand object. >
> > > > > --
> > > > > Jason Hinsperger
> > > > > International and Sustaining Engineering
> > > > > iAnywhere Solutions
> > > > >
> > > > > Whitepapers, TechDocs, and bug fixes are all
> > > > > available through the iAnywhere Developer
> > > > > Community at www.ianywhere.com/developer --
> > > > >
> > > > >
> > > > >
> > > > > <metalcrypt/allosy> wrote in message
> > > > > news:3f38f6f2.54ee.846930886@sybase.com...
> > > > > > Hello,
> > > > > >
> > > > > > I've run into a problem developing an
> > > > > > application on a Pocket PC running the ASA 8.02
> > > > > > .NET Data Provider for the Compact Framework,
> > > > > using Visual Basic.NET. >
> > > > > > I have a form that lets the user add items by
> > > > > > clicking on a button. When the add button is
> > > > > > clicked, I check to see if the item is already
> > > > > > in the database before adding it to a list of
> > > > > > items to be added (that list is just a table in
> > > > > memory, not an ASA table)... So far so good. >
> > > > > > I have an ASAConnection that I open at the start
> > > > > > of the application. I use an ASACommand that
> > > > > > executes a SELECT statement to check for the
> > > > > > presence of the item to be added (i.e. it
> > > > > > returns only a single value.) This works fine
> > > > > too but.... >
> > > > > > My boss was toying around with it, clicking
> > > > > > add/remove repeatedly. Eventually an exception
> > > > > > popped up, saying "resource governor for
> > > > > > 'prepared statements' exceeded". So somehow it
> > > > > > doesn't like the multiple ASACommands being
> > > > > executed when playing like that. :) >
> > > > > > I searched this newsgroup for this error and
> > > > > > there is talk of "freeing the prepared
> > > > > > statements". How do I do this with the .NET
> > > > > > Data Provider for the .NET CF? I've tried
> > > > > several things: >
> > > > > > - Dispose of the ASACommand object
> > > > > > - Cancel of the ASACommand object (out of
> > > > > > desperation) - Closing the connection after each
> > > > > > command - Disposing of the connection and
> > > > > > re-opening a new one - Force garbage collection
> > > > > after all of the above >
> > > > > > The above for each and every run of the
> > > > > > ASACommand (it's in a separate procedure, so it
> > > > > > was relatively easy to wreck havoc in there..
> > > > > :)) >
> > > > > > I don't think increasing the MAX_STATEMENT_COUNT
> > > > > > would solve the problem - it would only displace
> > > > > > it. It is quite probable that the user could
> > > > > > use this several hundred times - and the Pocket
> > > > > > PC has limited resources, so I figure if I set
> > > > > > it to 0, it could run out of memory during an
> > > > > > intensive workday. Beside, I don't even know
> > > > > > how to change MAX_STATEMENT_COUNT on the PDA...
> > > > > Everything I've seen seems to relate to PCs, not
> > > > > > PDAs... :( > Any help would be greatly
> > > > > appreciated!!! >
> > > > > > thanks,
> > > > > > Michel
> > > > > > metalcrypt666 @ NO hotmail SPAM . com (you know
> > > > > > what to do to clean up the address ;))
> > > > >
> > > > >
> > >
> > >
>
>


"Bruce Hay" Posted on 2003-08-13 16:02:30.0Z
From: "Bruce Hay" <hay at sybase dot com>
Newsgroups: ianywhere.public.general
References: <3f38f6f2.54ee.846930886@sybase.com><3f395970$1@forums-1-dub> <3f3987b0.3bd3.846930886@sybase.com><3f3a363e$1@forums-2-dub> <3f3a3abd.63f5.846930886@sybase.com><3f3a42b9$1@forums-1-dub> <3f3a5305.46d2.846930886@sybase.com>
Subject: Re: How do I free a prepared statement with .NET Data Provider on PocketPC?
Lines: 187
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: hay-xp.sybase.com
X-Original-NNTP-Posting-Host: hay-xp.sybase.com
Message-ID: <3f3a6116$1@forums-1-dub>
Date: 13 Aug 2003 09:02:30 -0700
X-Trace: forums-1-dub 1060790550 172.31.142.57 (13 Aug 2003 09:02:30 -0700)
X-Original-Trace: 13 Aug 2003 09:02:30 -0700, hay-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1589
Article PK: 3818

The request log shows the same symptoms as the problem that was fixed
earlier. The ExecuteScalar call in your app is causing a DataReader to be
created and called internally. The nature of the problem was such that it
might not show up on NT, as it depended on whether or not some freed memory
had been already re-used before being referenced. I have requested that a
newer CE EBF be posted. Watch for it to show up on the download site within
the next few days.

<Michel Renaud> wrote in message news:3f3a5305.46d2.846930886@sybase.com...
> I don't know anything about Case Express so let's do it
> here: The enclosed ZIP file contains a very simple VB.Net
> application: It's a form with one button. Click the button
> to execute the SELECT statement on the db (I didn't include
> the database in this, just use any db and change the SELECT
> to query some table - that doesn't matter.)
>
> There's a log file named "request.out" in the ZIP file that
> is the result of hitting the button 21 times (to reduce
> testing time, I set the MAX_STATEMENT_COUNT to 20.) I also
> added request_win2k.log, which is the result from running
> the same application on Windows 2000. As you can see, I was
> able to exceed 20 when running on that platform, unlike on
> WinCE.
>
> Let me know if you need any additional information.
>
> thanks,
> Michel
>
> > Providing the source for the test app that reproduces the
> > problem is the place to start. You can post it here or
> > open a case via Case Express. Capturing a request log on
> > CE would also be useful (add -zr all -zo request.out to
> > server start line, or use sa_server_option() stored
> > procedure to enable logging).
> >
> > <Michel Renaud> wrote in message
> > > news:3f3a3abd.63f5.846930886@sybase.com...
> > > Coincidentally, I just tried my "test app" on Win2K a
> > few minutes ago. No problem on that platform, I can
> > > execute the command several times without problems. So
> > > it seems like the problem is specific to the ADO.NET
> > > Data Provider on Windows CE. However, I have the latest
> > > EBF build for CE, so I'm pretty much stuck. Any way to
> > > have someone on the CE team check this one out?
> > >
> > > By the way, I have an older build of the Win2K version.
> > > The problem I have is not related to the fix Jason
> > > mentioned - I'm only using an ASACommand for this test
> > > app, not a datareader.
> > >
> > > thanks,
> > > Michel
> > >
> > >
> > >
> > > > If you can build and run your app on NT/XP/Win2K, you
> > > > might try downloading the most recent EBF for Windows
> > > > (which includes the fix Jason mentioned) and see if
> > > > that fixes your problem. If it does, then you just
> > > > need a more recent EBF for CE.
> > > >
> > > > Whitepapers, TechDocs, bug fixes are all available
> > > > through the iAnywhere Developer Community at
> > > > http://www.ianywhere.com/developer
> > > >
> > > > <Michel Renaud> wrote in message
> > > > > news:3f3987b0.3bd3.846930886@sybase.com... Sorry, I
> > > > > thought I was clear in saying none of them worked.
> > > > > :) I've also looked at the Solved Cases for help but
> > > > nothing there could resolve the problem. I have the
> > > > > latest EBF update for Windows CE (May 14).
> > > > >
> > > > > After posting earlier, I created a single form app
> > > > > in VB.Net that simply runs a SELECT COUNT(*) on an
> > > > > empty table. I open one ASAConnection when the
> > > > > program starts , then I click a button that simply
> > > > > runs the ASACommand with the SELECT query. After
> > > > > doing that 50 times, I get the error. Of course, if
> > > > > I set MAX_STATEMENT_COUNT to 0 , I can run that
> > > > > several thousand times before the ASA temp file
> > > > exceeds the PocketPC's storage limit. Not an option.
> > > > > > One of the solved cases mentions something about
> > > > > setting pooling=off and closing the connection to
> > > > > ensure everything is freed, but that is not
> > > > > acceptable on the Pocket PC - that's just too
> > > > > limiting, and more importantly, on re-opening the
> > > > > connection when pooling is off, it has to restart
> > > > > the whole ASA server again. Best way to be lynched
> > > > > by the users. :) The connection must either be
> > > > > pooled, or stay open during the whole session
> > > > > (essentially a whole day.) But during the course of
> > > > > a day, a user can well exceed the number of prepared
> > > > statements allowed and/or exceed storage space because
> > > > > of the ASA temp file. > Maybe it's just something
> > > > > I'm doing wrong... But I wonder why a SELECT is
> > > > > treated as a prepared statement? I can send you the
> > > > sample project if it can be of any help... >
> > > > > thanks,
> > > > > Michel
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > > Of the methods that you tried, which ones did/did
> > > > > > not work? There was an issue where the statement
> > > > > > would not be dropped if the command was deleted
> > > > > > before the reader was closed. This is fixed in
> > > > > > ASA 8.0.2 ebf 4278 and later. If you do not have
> > > > > > this ebf, make sure to close your ASAReader before
> > > > > deleting the ASACommand object. >
> > > > > > --
> > > > > > Jason Hinsperger
> > > > > > International and Sustaining Engineering
> > > > > > iAnywhere Solutions
> > > > > >
> > > > > > Whitepapers, TechDocs, and bug fixes are all
> > > > > > available through the iAnywhere Developer
> > > > > > Community at www.ianywhere.com/developer --
> > > > > >
> > > > > >
> > > > > >
> > > > > > <metalcrypt/allosy> wrote in message
> > > > > > news:3f38f6f2.54ee.846930886@sybase.com...
> > > > > > > Hello,
> > > > > > >
> > > > > > > I've run into a problem developing an
> > > > > > > application on a Pocket PC running the ASA 8.02
> > > > > > > .NET Data Provider for the Compact Framework,
> > > > > > using Visual Basic.NET. >
> > > > > > > I have a form that lets the user add items by
> > > > > > > clicking on a button. When the add button is
> > > > > > > clicked, I check to see if the item is already
> > > > > > > in the database before adding it to a list of
> > > > > > > items to be added (that list is just a table in
> > > > > > memory, not an ASA table)... So far so good. >
> > > > > > > I have an ASAConnection that I open at the start
> > > > > > > of the application. I use an ASACommand that
> > > > > > > executes a SELECT statement to check for the
> > > > > > > presence of the item to be added (i.e. it
> > > > > > > returns only a single value.) This works fine
> > > > > > too but.... >
> > > > > > > My boss was toying around with it, clicking
> > > > > > > add/remove repeatedly. Eventually an exception
> > > > > > > popped up, saying "resource governor for
> > > > > > > 'prepared statements' exceeded". So somehow it
> > > > > > > doesn't like the multiple ASACommands being
> > > > > > executed when playing like that. :) >
> > > > > > > I searched this newsgroup for this error and
> > > > > > > there is talk of "freeing the prepared
> > > > > > > statements". How do I do this with the .NET
> > > > > > > Data Provider for the .NET CF? I've tried
> > > > > > several things: >
> > > > > > > - Dispose of the ASACommand object
> > > > > > > - Cancel of the ASACommand object (out of
> > > > > > > desperation) - Closing the connection after each
> > > > > > > command - Disposing of the connection and
> > > > > > > re-opening a new one - Force garbage collection
> > > > > > after all of the above >
> > > > > > > The above for each and every run of the
> > > > > > > ASACommand (it's in a separate procedure, so it
> > > > > > > was relatively easy to wreck havoc in there..
> > > > > > :)) >
> > > > > > > I don't think increasing the MAX_STATEMENT_COUNT
> > > > > > > would solve the problem - it would only displace
> > > > > > > it. It is quite probable that the user could
> > > > > > > use this several hundred times - and the Pocket
> > > > > > > PC has limited resources, so I figure if I set
> > > > > > > it to 0, it could run out of memory during an
> > > > > > > intensive workday. Beside, I don't even know
> > > > > > > how to change MAX_STATEMENT_COUNT on the PDA...
> > > > > > Everything I've seen seems to relate to PCs, not
> > > > > > > PDAs... :( > Any help would be greatly
> > > > > > appreciated!!! >
> > > > > > > thanks,
> > > > > > > Michel
> > > > > > > metalcrypt666 @ NO hotmail SPAM . com (you know
> > > > > > > what to do to clean up the address ;))
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >
>


Michel Renaud Posted on 2003-08-13 16:23:17.0Z
Sender: 49a2.3f3a656b.1804289383@sybase.com
From: Michel Renaud
Newsgroups: ianywhere.public.general
Subject: Re: How do I free a prepared statement with .NET Data Provider on PocketPC?
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f3a65f5.49b8.846930886@sybase.com>
References: <3f38f6f2.54ee.846930886@sybase.com><3f395970$1@forums-1-dub> <3f3987b0.3bd3.846930886@sybase.com><3f3a363e$1@forums-2-dub> <3f3a3abd.63f5.846930886@sybase.com><3f3a42b9$1@forums-1-dub> <3f3a5305.46d2.846930886@sybase.com><3f3a6116$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Aug 2003 09:23:17 -0700
X-Trace: forums-1-dub 1060791797 10.22.241.41 (13 Aug 2003 09:23:17 -0700)
X-Original-Trace: 13 Aug 2003 09:23:17 -0700, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1591
Article PK: 3820

Ah! Little behind-the-scenes activity! :)

I'll keep an eye out for the EBF update. Thanks for your
help.

> The request log shows the same symptoms as the problem
> that was fixed earlier. The ExecuteScalar call in your app
> is causing a DataReader to be created and called
> internally. The nature of the problem was such that it
> might not show up on NT, as it depended on whether or not
> some freed memory had been already re-used before being
> referenced. I have requested that a newer CE EBF be
> posted. Watch for it to show up on the download site
> within the next few days.


"Bruce Hay" Posted on 2003-08-15 14:11:00.0Z
From: "Bruce Hay" <hay at sybase dot com>
Newsgroups: ianywhere.public.general
References: <3f38f6f2.54ee.846930886@sybase.com><3f395970$1@forums-1-dub> <3f3987b0.3bd3.846930886@sybase.com><3f3a363e$1@forums-2-dub> <3f3a3abd.63f5.846930886@sybase.com><3f3a42b9$1@forums-1-dub> <3f3a5305.46d2.846930886@sybase.com><3f3a6116$1@forums-1-dub> <3f3a65f5.49b8.846930886@sybase.com>
Subject: Re: How do I free a prepared statement with .NET Data Provider on PocketPC?
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: hay-xp.sybase.com
Message-ID: <3f3ce9fd@forums-2-dub>
X-Original-Trace: 15 Aug 2003 07:11:09 -0700, hay-xp.sybase.com
NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
Date: 15 Aug 2003 07:11:00 -0700
X-Trace: forums-1-dub 1060956660 10.22.241.42 (15 Aug 2003 07:11:00 -0700)
X-Original-Trace: 15 Aug 2003 07:11:00 -0700, forums-2-dub.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1612
Article PK: 3841

The CE EBF is now available.

<Michel Renaud> wrote in message news:3f3a65f5.49b8.846930886@sybase.com...
> Ah! Little behind-the-scenes activity! :)
>
> I'll keep an eye out for the EBF update. Thanks for your
> help.
>
> > The request log shows the same symptoms as the problem
> > that was fixed earlier. The ExecuteScalar call in your app
> > is causing a DataReader to be created and called
> > internally. The nature of the problem was such that it
> > might not show up on NT, as it depended on whether or not
> > some freed memory had been already re-used before being
> > referenced. I have requested that a newer CE EBF be
> > posted. Watch for it to show up on the download site
> > within the next few days.


Michel Renaud Posted on 2003-08-25 16:17:44.0Z
Sender: 4043.3f4a3683.1804289383@sybase.com
From: Michel Renaud
Newsgroups: ianywhere.public.general
Subject: Re: How do I free a prepared statement with .NET Data Provider on PocketPC?
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f4a36a8.4049.846930886@sybase.com>
References: <3f38f6f2.54ee.846930886@sybase.com><3f395970$1@forums-1-dub> <3f3987b0.3bd3.846930886@sybase.com><3f3a363e$1@forums-2-dub> <3f3a3abd.63f5.846930886@sybase.com><3f3a42b9$1@forums-1-dub> <3f3a5305.46d2.846930886@sybase.com><3f3a6116$1@forums-1-dub> <3f3a65f5.49b8.846930886@sybase.com><3f3ce9fd@forums-2-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Aug 2003 09:17:44 -0700
X-Trace: forums-1-dub 1061828264 10.22.241.41 (25 Aug 2003 09:17:44 -0700)
X-Original-Trace: 25 Aug 2003 09:17:44 -0700, 10.22.241.41
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1663
Article PK: 3887

The most recent EBF I see is dated May 14?????

> The CE EBF is now available.
>
> <Michel Renaud> wrote in message
> > news:3f3a65f5.49b8.846930886@sybase.com... Ah! Little
> behind-the-scenes activity! :) >
> > I'll keep an eye out for the EBF update. Thanks for
> > your help.
> >
> > > The request log shows the same symptoms as the problem
> > > that was fixed earlier. The ExecuteScalar call in your
> > > app is causing a DataReader to be created and called
> > > internally. The nature of the problem was such that it
> > > might not show up on NT, as it depended on whether or
> > > not some freed memory had been already re-used before
> > > being referenced. I have requested that a newer CE EBF
> > > be posted. Watch for it to show up on the download
> > > site within the next few days.
>
>


Michel Renaud Posted on 2003-09-03 12:42:08.0Z
Sender: 6b69.3f55e15d.1804289383@sybase.com
From: Michel Renaud
Newsgroups: ianywhere.public.general
Subject: Re: How do I free a prepared statement with .NET Data Provider on PocketPC?
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f55e1a0.6b78.846930886@sybase.com>
References: <3f38f6f2.54ee.846930886@sybase.com><3f395970$1@forums-1-dub> <3f3987b0.3bd3.846930886@sybase.com><3f3a363e$1@forums-2-dub> <3f3a3abd.63f5.846930886@sybase.com><3f3a42b9$1@forums-1-dub> <3f3a5305.46d2.846930886@sybase.com><3f3a6116$1@forums-1-dub> <3f3a65f5.49b8.846930886@sybase.com><3f3ce9fd@forums-2-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 3 Sep 2003 05:42:08 -0700
X-Trace: forums-1-dub 1062592928 10.22.241.41 (3 Sep 2003 05:42:08 -0700)
X-Original-Trace: 3 Sep 2003 05:42:08 -0700, 10.22.241.41
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1693
Article PK: 3914

The CE EBF is still not available as of Sept. 3 (most recent
one is dated May 14.) Help? :)

thanks,
Michel

> The CE EBF is now available.
>
> <Michel Renaud> wrote in message
> > news:3f3a65f5.49b8.846930886@sybase.com... Ah! Little
> behind-the-scenes activity! :) >
> > I'll keep an eye out for the EBF update. Thanks for
> > your help.
> >
> > > The request log shows the same symptoms as the problem
> > > that was fixed earlier. The ExecuteScalar call in your
> > > app is causing a DataReader to be created and called
> > > internally. The nature of the problem was such that it
> > > might not show up on NT, as it depended on whether or
> > > not some freed memory had been already re-used before
> > > being referenced. I have requested that a newer CE EBF
> > > be posted. Watch for it to show up on the download
> > > site within the next few days.
>
>


"Bruce Hay" Posted on 2003-09-08 13:13:26.0Z
From: "Bruce Hay" <hay at sybase dot com>
Newsgroups: ianywhere.public.general
References: <3f38f6f2.54ee.846930886@sybase.com><3f395970$1@forums-1-dub> <3f3987b0.3bd3.846930886@sybase.com><3f3a363e$1@forums-2-dub> <3f3a3abd.63f5.846930886@sybase.com><3f3a42b9$1@forums-1-dub> <3f3a5305.46d2.846930886@sybase.com><3f3a6116$1@forums-1-dub> <3f3a65f5.49b8.846930886@sybase.com><3f3ce9fd@forums-2-dub> <3f55e1a0.6b78.846930886@sybase.com>
Subject: Re: How do I free a prepared statement with .NET Data Provider on PocketPC?
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Original-NNTP-Posting-Host: hay-xp.sybase.com
Message-ID: <3f5c80d5@forums-2-dub>
X-Original-Trace: 8 Sep 2003 06:15:01 -0700, hay-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 8 Sep 2003 06:10:50 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 8 Sep 2003 06:13:26 -0700
X-Trace: forums-1-dub 1063026806 10.22.108.75 (8 Sep 2003 06:13:26 -0700)
X-Original-Trace: 8 Sep 2003 06:13:26 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1716
Article PK: 3937

There was a problem with the previous EBF, causing it to be withdrawn after
my posting. Build 4308 is now available for CE on the download site. Sorry
for the long delay. Thank you for your patience.

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

<Michel Renaud> wrote in message news:3f55e1a0.6b78.846930886@sybase.com...
> The CE EBF is still not available as of Sept. 3 (most recent
> one is dated May 14.) Help? :)
>
> thanks,
> Michel
>
> > The CE EBF is now available.
> >
> > <Michel Renaud> wrote in message
> > > news:3f3a65f5.49b8.846930886@sybase.com... Ah! Little
> > behind-the-scenes activity! :) >
> > > I'll keep an eye out for the EBF update. Thanks for
> > > your help.
> > >
> > > > The request log shows the same symptoms as the problem
> > > > that was fixed earlier. The ExecuteScalar call in your
> > > > app is causing a DataReader to be created and called
> > > > internally. The nature of the problem was such that it
> > > > might not show up on NT, as it depended on whether or
> > > > not some freed memory had been already re-used before
> > > > being referenced. I have requested that a newer CE EBF
> > > > be posted. Watch for it to show up on the download
> > > > site within the next few days.
> >
> >