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.

String function native exception (ASA 9.0.1252)

8 posts in General Discussion Last posting was on 2004-02-06 16:50:07.0Z
Craig Hyatt Posted on 2004-02-05 04:12:26.0Z
Sender: 5755.4021c514.1804289383@sybase.com
From: Craig Hyatt
Newsgroups: ianywhere.public.general
Subject: String function native exception (ASA 9.0.1252)
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <4021c523.5757.846930886@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 4 Feb 2004 20:22:59 -0800, 10.22.241.42
Lines: 35
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 4 Feb 2004 19:55:08 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 4 Feb 2004 20:12:26 -0800
X-Trace: forums-1-dub 1075954346 10.22.108.75 (4 Feb 2004 20:12:26 -0800)
X-Original-Trace: 4 Feb 2004 20:12:26 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2427
Article PK: 5566

Hi all,

I'm using:

ASA 9.0.1252
Pocket PC 2002/2003 Emulators

and getting following error message:

A native exception occurred.
ExceptionCode: 0xc0000005
ExceptionAddress: 0x372c362c
Reading: 0x372c362c
OK to terminate
CANCEL to debug

when executing a "select STRING" query.

1. "select STRING(1,2,3)" works fine
2. "select
STRING('abcdefghijklmnopqrstuvwxyz','abcdefghijklmnopqrstuvwxyz'
,'abcdefghijklmnopqrstuvwxyz','abcdefghijklmnopqrstuvwxyz','abcdefghijklmnopqrstuvwxyz'
,'abcdefghijklmnopqrstuvwxyz','abcdefghijklmnopqrstuvwxyz','abcdefghijklmnopqrstuvwxyz')
;" does not!

The number of parameters to STRING doesn't seem to be the
problem. I think it is the their total length. Is there a
limit to the length of parameters? Shouldn't it fail more
gracefully?

Any thoughts?

Thanks,

Craig


Breck Carter [TeamSybase] Posted on 2004-02-05 12:49:49.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: String function native exception (ASA 9.0.1252)
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <cod420d817srequ7huv4iefb65fu8s1mml@4ax.com>
References: <4021c523.5757.846930886@sybase.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 5 Feb 2004 05:00:23 -0800, bcarter.sentex.ca
Lines: 57
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Feb 2004 04:32:28 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Feb 2004 04:49:49 -0800
X-Trace: forums-1-dub 1075985389 10.22.108.75 (5 Feb 2004 04:49:49 -0800)
X-Original-Trace: 5 Feb 2004 04:49:49 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2428
Article PK: 5565

What client software was used to run that query? An application? If
so, please show the code surrounding the SELECT; it's not clear
*where* the exception is coming from... perhaps it is failing when the
result is being placed in a host variable or application-side buffer.

In my experience the STRING() function is utterly reliable, and
capable of handling an unlimited number of parameters and string
length... it is a very popular and heavily used function.

You can run ISQL on the desktop to connect to the ASA CE version of
dbsrv9.exe, if you want to try the same SELECT from a different
client.

Breck

On 4 Feb 2004 20:12:26 -0800, Craig Hyatt wrote:

>Hi all,
>
>I'm using:
>
>ASA 9.0.1252
>Pocket PC 2002/2003 Emulators
>
>and getting following error message:
>
>A native exception occurred.
>ExceptionCode: 0xc0000005
>ExceptionAddress: 0x372c362c
>Reading: 0x372c362c
>OK to terminate
>CANCEL to debug
>
>when executing a "select STRING" query.
>
>1. "select STRING(1,2,3)" works fine
>2. "select
>STRING('abcdefghijklmnopqrstuvwxyz','abcdefghijklmnopqrstuvwxyz'
>,'abcdefghijklmnopqrstuvwxyz','abcdefghijklmnopqrstuvwxyz','abcdefghijklmnopqrstuvwxyz'
>,'abcdefghijklmnopqrstuvwxyz','abcdefghijklmnopqrstuvwxyz','abcdefghijklmnopqrstuvwxyz')
>;" does not!
>
>The number of parameters to STRING doesn't seem to be the
>problem. I think it is the their total length. Is there a
>limit to the length of parameters? Shouldn't it fail more
>gracefully?
>
>Any thoughts?
>
>Thanks,
>
>Craig

--
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com


Craig Hyatt Posted on 2004-02-05 16:35:41.0Z
Sender: 5faa.402271be.1804289383@sybase.com
From: Craig Hyatt
Newsgroups: ianywhere.public.general
Subject: Re: String function native exception (ASA 9.0.1252)
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <40227357.5fbb.846930886@sybase.com>
References: <4021c523.5757.846930886@sybase.com><cod420d817srequ7huv4iefb65fu8s1mml@4ax.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 5 Feb 2004 08:46:15 -0800, 10.22.241.42
Lines: 38
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Feb 2004 08:18:18 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Feb 2004 08:35:41 -0800
X-Trace: forums-1-dub 1075998941 10.22.108.75 (5 Feb 2004 08:35:41 -0800)
X-Original-Trace: 5 Feb 2004 08:35:41 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2430
Article PK: 5567

Hi Breck,

Yes, this is a C# application.

Here is a simple snippet that demonstrates the behaviour I'm
seeing:

String sql = "select STRING(1);";
String sql2 = "select
STRING(1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7
,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7
,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7
,8,9,0,1,2,3,4,5,6,7,8,9,0);";
AsaConnection ac = new AsaConnection("DBF=\\Program
Files\\Sybase\\ASA\\asademo.db;UID=DBA;PWD=SQL;");
AsaDataAdapter aa = new AsaDataAdapter(sql2, ac);
DataSet ds = new DataSet();
try
{
aa.Fill(ds);
}
catch (iAnywhere.Data.AsaClient.AsaException ex)
{
System.Windows.Forms.MessageBox.Show(ex.ToString());
}
ac.Close();

1. Both queries (sql, sql2) work fine on my pc using ISQL
to a database on my pc.
2. The first works fine in my application on the emulator
to a database on the emulator.
3. The second causes the native exception in my application
on the emulator to a database on the emulator.

Is there a way to connect ISQL on my pc to the database on
the emulator to test this?

Craig


Breck Carter [TeamSybase] Posted on 2004-02-05 18:59:16.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: String function native exception (ASA 9.0.1252)
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <ve3520leq7ca5s244q49eh4o0t8j9lvl5v@4ax.com>
References: <4021c523.5757.846930886@sybase.com><cod420d817srequ7huv4iefb65fu8s1mml@4ax.com> <40227357.5fbb.846930886@sybase.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 5 Feb 2004 11:09:51 -0800, bcarter.sentex.ca
Lines: 52
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Feb 2004 10:41:53 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Feb 2004 10:59:16 -0800
X-Trace: forums-1-dub 1076007556 10.22.108.75 (5 Feb 2004 10:59:16 -0800)
X-Original-Trace: 5 Feb 2004 10:59:16 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2431
Article PK: 5568

If you start dbsrv9.exe, and the emulator has a tcp/ip address, you
should be able to make a "network connection" to the engine.
Alternatively, you could put everything on an actual device and
connect to it there from the desktop.

Breck

On 5 Feb 2004 08:35:41 -0800, Craig Hyatt wrote:

>Hi Breck,
>
>Yes, this is a C# application.
>
>Here is a simple snippet that demonstrates the behaviour I'm
>seeing:
>
>String sql = "select STRING(1);";
>String sql2 = "select
>STRING(1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7
>,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7
>,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7
>,8,9,0,1,2,3,4,5,6,7,8,9,0);";
>AsaConnection ac = new AsaConnection("DBF=\\Program
>Files\\Sybase\\ASA\\asademo.db;UID=DBA;PWD=SQL;");
>AsaDataAdapter aa = new AsaDataAdapter(sql2, ac);
>DataSet ds = new DataSet();
>try
>{
> aa.Fill(ds);
>}
>catch (iAnywhere.Data.AsaClient.AsaException ex)
>{
> System.Windows.Forms.MessageBox.Show(ex.ToString());
>}
>ac.Close();
>
>1. Both queries (sql, sql2) work fine on my pc using ISQL
>to a database on my pc.
>2. The first works fine in my application on the emulator
>to a database on the emulator.
>3. The second causes the native exception in my application
>on the emulator to a database on the emulator.
>
>Is there a way to connect ISQL on my pc to the database on
>the emulator to test this?
>
>Craig

--
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com


Craig Hyatt Posted on 2004-02-05 22:00:17.0Z
Sender: 6450.4022be5c.1804289383@sybase.com
From: Craig Hyatt
Newsgroups: ianywhere.public.general
Subject: Re: String function native exception (ASA 9.0.1252)
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <4022bf6c.6459.846930886@sybase.com>
References: <4021c523.5757.846930886@sybase.com><cod420d817srequ7huv4iefb65fu8s1mml@4ax.com> <40227357.5fbb.846930886@sybase.com><ve3520leq7ca5s244q49eh4o0t8j9lvl5v@4ax.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 5 Feb 2004 14:10:52 -0800, 10.22.241.42
Lines: 70
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 5 Feb 2004 13:42:53 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 5 Feb 2004 14:00:17 -0800
X-Trace: forums-1-dub 1076018417 10.22.108.75 (5 Feb 2004 14:00:17 -0800)
X-Original-Trace: 5 Feb 2004 14:00:17 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2432
Article PK: 5570

Yep, both of the queries below work just fine via ISQL
connected to the database on a device.

So I decided to try the actual (unsimplified) query that was
originally breaking in our application via ISQL, at which
point
I got a new error:

Interactive SQL
The following error occurred while fetching results:
[Sybase][ODBC Driver][Adaptive Server Anywhere]
Dynamic memory exhausted

So I presume the native exception is a result of running out
of memory.

> If you start dbsrv9.exe, and the emulator has a tcp/ip
> address, you should be able to make a "network connection"
> to the engine. Alternatively, you could put everything on
> an actual device and connect to it there from the desktop.
>
> Breck
>
> On 5 Feb 2004 08:35:41 -0800, Craig Hyatt wrote:
>
> >Hi Breck,
> >
> >Yes, this is a C# application.
> >
> >Here is a simple snippet that demonstrates the behaviour
> I'm >seeing:
> >
> >String sql = "select STRING(1);";
> >String sql2 = "select
> >STRING(1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,
> 6,7
> >,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,
> 6,7
> >,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,
> 6,7 >,8,9,0,1,2,3,4,5,6,7,8,9,0);";
> >AsaConnection ac = new AsaConnection("DBF=\\Program
> >Files\\Sybase\\ASA\\asademo.db;UID=DBA;PWD=SQL;");
> >AsaDataAdapter aa = new AsaDataAdapter(sql2, ac);
> >DataSet ds = new DataSet();
> >try
> >{
> > aa.Fill(ds);
> >}
> >catch (iAnywhere.Data.AsaClient.AsaException ex)
> >{
> > System.Windows.Forms.MessageBox.Show(ex.ToString());
> >}
> >ac.Close();
> >
> >1. Both queries (sql, sql2) work fine on my pc using
> ISQL >to a database on my pc.
> >2. The first works fine in my application on the
> emulator >to a database on the emulator.
> >3. The second causes the native exception in my
> application >on the emulator to a database on the
> emulator. >
> >Is there a way to connect ISQL on my pc to the database
> on >the emulator to test this?
> >
> >Craig
>
> --
> bcarter@risingroad.com
> Mobile and Distributed Enterprise Database Applications
> www.risingroad.com


Breck Carter [TeamSybase] Posted on 2004-02-06 11:53:13.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: String function native exception (ASA 9.0.1252)
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <5su6205turtptf2h517gll98emvf76uqa1@4ax.com>
References: <4021c523.5757.846930886@sybase.com><cod420d817srequ7huv4iefb65fu8s1mml@4ax.com> <40227357.5fbb.846930886@sybase.com><ve3520leq7ca5s244q49eh4o0t8j9lvl5v@4ax.com> <4022bf6c.6459.846930886@sybase.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 6 Feb 2004 03:53:13 -0800
X-Trace: forums-1-dub 1076068393 64.7.134.118 (6 Feb 2004 03:53:13 -0800)
X-Original-Trace: 6 Feb 2004 03:53:13 -0800, bcarter.sentex.ca
Lines: 102
X-Authenticated-User: TeamPS
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2437
Article PK: 5575

Try the following search on Google - Groups:

"dynamic memory exhausted" pocket group:sybase.public.sqlanywhere.*

One of the threads has this message which may apply:

=====
Virtually all memory used by the engine during runtime is located
inside
the cache itself and on CE the database cache CANNOT grow (the code to
do it isn't even compiled into the server). A few things such as
communication buffers are allocated outside of the cache but they are
generally small. Find the smallest cache size that you can reliably
run
the server with and you will have the smallest footprint possible.
What
made you think that the cache size was increasing?

John Smirnios
Senior Software Developer
iAnywhere Solutions Engineering
=====

Breck

On 5 Feb 2004 14:00:17 -0800, Craig Hyatt wrote:

>Yep, both of the queries below work just fine via ISQL
>connected to the database on a device.
>
>So I decided to try the actual (unsimplified) query that was
>originally breaking in our application via ISQL, at which
>point
>I got a new error:
>
>Interactive SQL
>The following error occurred while fetching results:
>[Sybase][ODBC Driver][Adaptive Server Anywhere]
>Dynamic memory exhausted
>
>So I presume the native exception is a result of running out
>of memory.
>
>> If you start dbsrv9.exe, and the emulator has a tcp/ip
>> address, you should be able to make a "network connection"
>> to the engine. Alternatively, you could put everything on
>> an actual device and connect to it there from the desktop.
>>
>> Breck
>>
>> On 5 Feb 2004 08:35:41 -0800, Craig Hyatt wrote:
>>
>> >Hi Breck,
>> >
>> >Yes, this is a C# application.
>> >
>> >Here is a simple snippet that demonstrates the behaviour
>> I'm >seeing:
>> >
>> >String sql = "select STRING(1);";
>> >String sql2 = "select
>> >STRING(1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,
>> 6,7
>> >,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,
>> 6,7
>> >,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,
>> 6,7 >,8,9,0,1,2,3,4,5,6,7,8,9,0);";
>> >AsaConnection ac = new AsaConnection("DBF=\\Program
>> >Files\\Sybase\\ASA\\asademo.db;UID=DBA;PWD=SQL;");
>> >AsaDataAdapter aa = new AsaDataAdapter(sql2, ac);
>> >DataSet ds = new DataSet();
>> >try
>> >{
>> > aa.Fill(ds);
>> >}
>> >catch (iAnywhere.Data.AsaClient.AsaException ex)
>> >{
>> > System.Windows.Forms.MessageBox.Show(ex.ToString());
>> >}
>> >ac.Close();
>> >
>> >1. Both queries (sql, sql2) work fine on my pc using
>> ISQL >to a database on my pc.
>> >2. The first works fine in my application on the
>> emulator >to a database on the emulator.
>> >3. The second causes the native exception in my
>> application >on the emulator to a database on the
>> emulator. >
>> >Is there a way to connect ISQL on my pc to the database
>> on >the emulator to test this?
>> >
>> >Craig
>>
>> --
>> bcarter@risingroad.com
>> Mobile and Distributed Enterprise Database Applications
>> www.risingroad.com

--
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com


Craig Hyatt Posted on 2004-02-06 16:23:16.0Z
Sender: 6eaa.4023c153.1804289383@sybase.com
From: Craig Hyatt
Newsgroups: ianywhere.public.general
Subject: Re: String function native exception (ASA 9.0.1252)
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <4023c1f4.6ebc.846930886@sybase.com>
References: <4021c523.5757.846930886@sybase.com><cod420d817srequ7huv4iefb65fu8s1mml@4ax.com> <40227357.5fbb.846930886@sybase.com><ve3520leq7ca5s244q49eh4o0t8j9lvl5v@4ax.com> <4022bf6c.6459.846930886@sybase.com><5su6205turtptf2h517gll98emvf76uqa1@4ax.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 6 Feb 2004 08:33:56 -0800, 10.22.241.42
Lines: 114
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 6 Feb 2004 08:05:50 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 6 Feb 2004 08:23:16 -0800
X-Trace: forums-1-dub 1076084596 10.22.108.75 (6 Feb 2004 08:23:16 -0800)
X-Original-Trace: 6 Feb 2004 08:23:16 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2442
Article PK: 5588

Increasing the cache size (I chose 2M) allows the query to
run without exception both:

1. Via ISQL on my pc to the database on the device
2. Via my application on the device to the database on the
device

Still no luck with the emulator.

Thanks for all your help!

> Try the following search on Google - Groups:
>
> "dynamic memory exhausted" pocket
> group:sybase.public.sqlanywhere.*
>
> One of the threads has this message which may apply:
>
> =====
> Virtually all memory used by the engine during runtime is
> located inside
> the cache itself and on CE the database cache CANNOT grow
> (the code to do it isn't even compiled into the server). A
> few things such as communication buffers are allocated
> outside of the cache but they are generally small. Find
> the smallest cache size that you can reliably run
> the server with and you will have the smallest footprint
> possible. What
> made you think that the cache size was increasing?
>
> John Smirnios
> Senior Software Developer
> iAnywhere Solutions Engineering
> =====
>
> Breck
>
> On 5 Feb 2004 14:00:17 -0800, Craig Hyatt wrote:
>
> >Yep, both of the queries below work just fine via ISQL
> >connected to the database on a device.
> >
> >So I decided to try the actual (unsimplified) query that
> was >originally breaking in our application via ISQL, at
> which >point
> >I got a new error:
> >
> >Interactive SQL
> >The following error occurred while fetching results:
> >[Sybase][ODBC Driver][Adaptive Server Anywhere]
> >Dynamic memory exhausted
> >
> >So I presume the native exception is a result of running
> out >of memory.
> >
> >> If you start dbsrv9.exe, and the emulator has a tcp/ip
> >> address, you should be able to make a "network
> connection" >> to the engine. Alternatively, you could put
> everything on >> an actual device and connect to it there
> from the desktop. >>
> >> Breck
> >>
> >> On 5 Feb 2004 08:35:41 -0800, Craig Hyatt wrote:
> >>
> >> >Hi Breck,
> >> >
> >> >Yes, this is a C# application.
> >> >
> >> >Here is a simple snippet that demonstrates the
> behaviour >> I'm >seeing:
> >> >
> >> >String sql = "select STRING(1);";
> >> >String sql2 = "select
> >>
> >STRING(1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,
> >> 6,7 >>
> >,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,
> >> 6,7 >>
> >,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,
> >> 6,7 >,8,9,0,1,2,3,4,5,6,7,8,9,0);"; >> >AsaConnection
> ac = new AsaConnection("DBF=\\Program >>
> >Files\\Sybase\\ASA\\asademo.db;UID=DBA;PWD=SQL;"); >>
> >AsaDataAdapter aa = new AsaDataAdapter(sql2, ac); >>
> >DataSet ds = new DataSet(); >> >try
> >> >{
> >> > aa.Fill(ds);
> >> >}
> >> >catch (iAnywhere.Data.AsaClient.AsaException ex)
> >> >{
> >> >
> System.Windows.Forms.MessageBox.Show(ex.ToString()); >> >}
> >> >ac.Close();
> >> >
> >> >1. Both queries (sql, sql2) work fine on my pc using
> >> ISQL >to a database on my pc.
> >> >2. The first works fine in my application on the
> >> emulator >to a database on the emulator.
> >> >3. The second causes the native exception in my
> >> application >on the emulator to a database on the
> >> emulator. >
> >> >Is there a way to connect ISQL on my pc to the
> database >> on >the emulator to test this?
> >> >
> >> >Craig
> >>
> >> --
> >> bcarter@risingroad.com
> >> Mobile and Distributed Enterprise Database Applications
> >> www.risingroad.com
>
> --
> bcarter@risingroad.com
> Mobile and Distributed Enterprise Database Applications
> www.risingroad.com


Breck Carter [TeamSybase] Posted on 2004-02-06 16:50:07.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: String function native exception (ASA 9.0.1252)
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <c6g72092o7qsnnu9hl5kc2idmqlqjst5qf@4ax.com>
References: <4021c523.5757.846930886@sybase.com><cod420d817srequ7huv4iefb65fu8s1mml@4ax.com> <40227357.5fbb.846930886@sybase.com><ve3520leq7ca5s244q49eh4o0t8j9lvl5v@4ax.com> <4022bf6c.6459.846930886@sybase.com><5su6205turtptf2h517gll98emvf76uqa1@4ax.com> <4023c1f4.6ebc.846930886@sybase.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 6 Feb 2004 08:50:07 -0800
X-Trace: forums-1-dub 1076086207 64.7.134.118 (6 Feb 2004 08:50:07 -0800)
X-Original-Trace: 6 Feb 2004 08:50:07 -0800, bcarter.sentex.ca
Lines: 131
X-Authenticated-User: TeamPS
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2443
Article PK: 5579

I haven't had much experience with the emulator because it didn't
support the Symbol scanner I was using, so I can't offer any
suggestions. What you should do, is start a *new* thread asking "how
do I get ASA CE to stop failing on the emulator when it works on the
device"... a new thread will get more attention than a reply here;
busy folks tend to think that replies have already helped :)

Breck

On 6 Feb 2004 08:23:16 -0800, Craig Hyatt wrote:

>Increasing the cache size (I chose 2M) allows the query to
>run without exception both:
>
>1. Via ISQL on my pc to the database on the device
>2. Via my application on the device to the database on the
>device
>
>Still no luck with the emulator.
>
>Thanks for all your help!
>
>> Try the following search on Google - Groups:
>>
>> "dynamic memory exhausted" pocket
>> group:sybase.public.sqlanywhere.*
>>
>> One of the threads has this message which may apply:
>>
>> =====
>> Virtually all memory used by the engine during runtime is
>> located inside
>> the cache itself and on CE the database cache CANNOT grow
>> (the code to do it isn't even compiled into the server). A
>> few things such as communication buffers are allocated
>> outside of the cache but they are generally small. Find
>> the smallest cache size that you can reliably run
>> the server with and you will have the smallest footprint
>> possible. What
>> made you think that the cache size was increasing?
>>
>> John Smirnios
>> Senior Software Developer
>> iAnywhere Solutions Engineering
>> =====
>>
>> Breck
>>
>> On 5 Feb 2004 14:00:17 -0800, Craig Hyatt wrote:
>>
>> >Yep, both of the queries below work just fine via ISQL
>> >connected to the database on a device.
>> >
>> >So I decided to try the actual (unsimplified) query that
>> was >originally breaking in our application via ISQL, at
>> which >point
>> >I got a new error:
>> >
>> >Interactive SQL
>> >The following error occurred while fetching results:
>> >[Sybase][ODBC Driver][Adaptive Server Anywhere]
>> >Dynamic memory exhausted
>> >
>> >So I presume the native exception is a result of running
>> out >of memory.
>> >
>> >> If you start dbsrv9.exe, and the emulator has a tcp/ip
>> >> address, you should be able to make a "network
>> connection" >> to the engine. Alternatively, you could put
>> everything on >> an actual device and connect to it there
>> from the desktop. >>
>> >> Breck
>> >>
>> >> On 5 Feb 2004 08:35:41 -0800, Craig Hyatt wrote:
>> >>
>> >> >Hi Breck,
>> >> >
>> >> >Yes, this is a C# application.
>> >> >
>> >> >Here is a simple snippet that demonstrates the
>> behaviour >> I'm >seeing:
>> >> >
>> >> >String sql = "select STRING(1);";
>> >> >String sql2 = "select
>> >>
>> >STRING(1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,
>> >> 6,7 >>
>> >,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,
>> >> 6,7 >>
>> >,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,
>> >> 6,7 >,8,9,0,1,2,3,4,5,6,7,8,9,0);"; >> >AsaConnection
>> ac = new AsaConnection("DBF=\\Program >>
>> >Files\\Sybase\\ASA\\asademo.db;UID=DBA;PWD=SQL;"); >>
>> >AsaDataAdapter aa = new AsaDataAdapter(sql2, ac); >>
>> >DataSet ds = new DataSet(); >> >try
>> >> >{
>> >> > aa.Fill(ds);
>> >> >}
>> >> >catch (iAnywhere.Data.AsaClient.AsaException ex)
>> >> >{
>> >> >
>> System.Windows.Forms.MessageBox.Show(ex.ToString()); >> >}
>> >> >ac.Close();
>> >> >
>> >> >1. Both queries (sql, sql2) work fine on my pc using
>> >> ISQL >to a database on my pc.
>> >> >2. The first works fine in my application on the
>> >> emulator >to a database on the emulator.
>> >> >3. The second causes the native exception in my
>> >> application >on the emulator to a database on the
>> >> emulator. >
>> >> >Is there a way to connect ISQL on my pc to the
>> database >> on >the emulator to test this?
>> >> >
>> >> >Craig
>> >>
>> >> --
>> >> bcarter@risingroad.com
>> >> Mobile and Distributed Enterprise Database Applications
>> >> www.risingroad.com
>>
>> --
>> bcarter@risingroad.com
>> Mobile and Distributed Enterprise Database Applications
>> www.risingroad.com

--
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com