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.

Using iANYWHERE .NET

3 posts in General Discussion Last posting was on 2003-09-30 14:55:40.0Z
PaulMacCnj Posted on 2003-09-26 13:27:44.0Z
From: "PaulMacCnj" <paul.machiaverna@i-stat.com>
Newsgroups: ianywhere.public.general
Subject: Using iANYWHERE .NET
Lines: 22
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: 65.162.128.158
X-Original-NNTP-Posting-Host: 65.162.128.158
Message-ID: <3f743ed0$1@forums-1-dub>
Date: 26 Sep 2003 06:27:44 -0700
X-Trace: forums-1-dub 1064582864 65.162.128.158 (26 Sep 2003 06:27:44 -0700)
X-Original-Trace: 26 Sep 2003 06:27:44 -0700, 65.162.128.158
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1804
Article PK: 4092

I've encountered an issue while testing the iANYWHERE provider for .NET.
This is essentially what I'm doing from the Web Service application:

1) A connection is made to the database.
2) A SQL text based query is issued to the database to read data. This data
is stored in a dataset object.
3) A stored procedure is called to read additional data. This procedure
returns the data as a result set, which is stored in a dataset.

Both the SQL text base query and stored procedure calls are made using
AsaCommand and AsaDataReader objects. The problem is when the stored
procedure AsaDataReader.Read method is called a "Cursor not open" error
results. If I bypass the text based query, the call to the stored procedure
works fine. Is it because I'm using the same connection for both queries?

Incidentally, this worked fine when using OleDb with ASAProvider specified.
Sybase tech support suggested that I use the native .NET provider instead,
but now I'm having problems.

Paul Mac


Jason Hinsperger Posted on 2003-09-29 14:43:08.0Z
From: "Jason Hinsperger" <NOJason_HinspergerSPAM@hotmail.com>
Newsgroups: ianywhere.public.general
References: <3f743ed0$1@forums-1-dub>
Subject: Re: Using iANYWHERE .NET
Lines: 44
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
X-Original-NNTP-Posting-Host: hinsperg-pc1.sybase.com
Message-ID: <3f7845a3$1@forums-2-dub>
X-Original-Trace: 29 Sep 2003 07:45:55 -0700, hinsperg-pc1.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Sep 2003 07:38:25 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Sep 2003 07:43:08 -0700
X-Trace: forums-1-dub 1064846588 10.22.108.75 (29 Sep 2003 07:43:08 -0700)
X-Original-Trace: 29 Sep 2003 07:43:08 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1812
Article PK: 4086

What version/build of ASA are you using?
As far as I can tell from my testing, this works ok with ASA 8.0.2 (recent
ebf) and ASA 9.0.0
Can you post some sample code? I am not clear on the order of events, or
exactly what methods you are calling when.

--
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
--

"PaulMacCnj" <paul.machiaverna@i-stat.com> wrote in message
news:3f743ed0$1@forums-1-dub...
> I've encountered an issue while testing the iANYWHERE provider for .NET.
> This is essentially what I'm doing from the Web Service application:
>
> 1) A connection is made to the database.
> 2) A SQL text based query is issued to the database to read data. This
data
> is stored in a dataset object.
> 3) A stored procedure is called to read additional data. This procedure
> returns the data as a result set, which is stored in a dataset.
>
> Both the SQL text base query and stored procedure calls are made using
> AsaCommand and AsaDataReader objects. The problem is when the stored
> procedure AsaDataReader.Read method is called a "Cursor not open" error
> results. If I bypass the text based query, the call to the stored
procedure
> works fine. Is it because I'm using the same connection for both queries?
>
> Incidentally, this worked fine when using OleDb with ASAProvider
specified.
> Sybase tech support suggested that I use the native .NET provider instead,
> but now I'm having problems.
>
> Paul Mac
>
>


PaulMacCnj Posted on 2003-09-30 14:55:40.0Z
From: "PaulMacCnj" <paul.machiaverna@i-stat.com>
Newsgroups: ianywhere.public.general
References: <3f743ed0$1@forums-1-dub> <3f7845a3$1@forums-2-dub>
Subject: Re: Using iANYWHERE .NET
Lines: 191
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0007_01C38740.B8456C40"
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: 65.162.128.158
X-Original-NNTP-Posting-Host: 65.162.128.158
Message-ID: <3f79996c@forums-1-dub>
Date: 30 Sep 2003 07:55:40 -0700
X-Trace: forums-1-dub 1064933740 65.162.128.158 (30 Sep 2003 07:55:40 -0700)
X-Original-Trace: 30 Sep 2003 07:55:40 -0700, 65.162.128.158
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1820
Article PK: 17402

Hi Jason,
 
The database is Sybase Adaptive Server Anywhere Database Engine Version 8.0.2.4308.
 
I've already called the Sybase tech support and have been assigned a case number.  A solution is still pending, but the problem appears to be with stored procedures that return a null result set.  The AsaDataReader.Read throws a "Cursor not open" AsaException.  I'm waiting to hear back from Sybase to determine what a stored procedure should return if there is nothing that meets the criteria for the data.  Of course, there is a kluge solution of passing a "flag" result set (row) that the application can test to determine if there is no data to read.  However, there should be a more elegant soution especially because the OleDbDataReader has no problems dealing with a null result set.
 
Paul Mac
 
 
"Jason Hinsperger" <NOJason_HinspergerSPAM@hotmail.com> wrote in message news:3f7845a3$1@forums-2-dub...
> What version/build of ASA are you using?
> As far as I can tell from my testing, this works ok with ASA 8.0.2 (recent
> ebf) and ASA 9.0.0
> Can you post some sample code?  I am not clear on the order of events, or
> exactly what methods you are calling when.
>
> --
> 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
> --
>
> "PaulMacCnj" <paul.machiaverna@i-stat.com> wrote in message
> news:3f743ed0$1@forums-1-dub...
> > I've encountered an issue while testing the iANYWHERE provider for .NET.
> > This is essentially what I'm doing from the Web Service application:
> >
> > 1) A connection is made to the database.
> > 2) A SQL text based query is issued to the database to read data.  This
> data
> > is stored in a dataset object.
> > 3) A stored procedure is called to read additional data.  This procedure
> > returns the data as a result set, which is stored in a dataset.
> >
> > Both the SQL text base query and stored procedure calls are made using
> > AsaCommand and AsaDataReader objects.  The problem is when the stored
> > procedure AsaDataReader.Read method is called a "Cursor not open" error
> > results.  If I bypass the text based query, the call to the stored
> procedure
> > works fine.  Is it because I'm using the same connection for both queries?
> >
> > Incidentally, this worked fine when using OleDb with ASAProvider
> specified.
> > Sybase tech support suggested that I use the native .NET provider instead,
> > but now I'm having problems.
> >
> > Paul Mac
> >
> >
>
>