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 to call stored procedure

2 posts in General Discussion Last posting was on 2003-09-26 13:52:20.0Z
Chand Posted on 2003-09-18 13:49:14.0Z
Sender: 2ad.3f69b839.1804289383@sybase.com
From: Chand
Newsgroups: ianywhere.public.general
Subject: How to call stored procedure
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f69b85b.2ae.846930886@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 18 Sep 2003 06:51:23 -0700, 10.22.241.42
Lines: 16
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 18 Sep 2003 06:45:37 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 18 Sep 2003 06:49:14 -0700
X-Trace: forums-1-dub 1063892954 10.22.108.75 (18 Sep 2003 06:49:14 -0700)
X-Original-Trace: 18 Sep 2003 06:49:14 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1776
Article PK: 17328

Hi,

I written one application in C# using Sybase iAnywhere
database and its version is 8.0.2.

Question 1: Is there any way to connect database at (Insert,
update, fetch ) query time and if i do so then it takes time
to connect every time. and I don't want to keep open
connection. what is the best solution.

Question 2: I wrote one stored procedure in database and
that procedure expect three parameters and it returns some
record so how do i call this procedure with parameter in C#.

Thanks for reading
Chandresh Patel


PaulMacCnj Posted on 2003-09-26 13:52:20.0Z
From: "PaulMacCnj" <paul.machiaverna@i-stat.com>
Newsgroups: ianywhere.public.general
References: <3f69b85b.2ae.846930886@sybase.com>
Subject: Re: How to call stored procedure
Lines: 27
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: <3f744494$1@forums-1-dub>
Date: 26 Sep 2003 06:52:20 -0700
X-Trace: forums-1-dub 1064584340 65.162.128.158 (26 Sep 2003 06:52:20 -0700)
X-Original-Trace: 26 Sep 2003 06:52:20 -0700, 65.162.128.158
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1805
Article PK: 4091

Chandresh,

Have you downloaded the help file for the iANYWHERE .NET provider? The file
is dbdnen8.zip and is available on the Sybase website.

Paul

<Chand> wrote in message news:3f69b85b.2ae.846930886@sybase.com...
> Hi,
>
> I written one application in C# using Sybase iAnywhere
> database and its version is 8.0.2.
>
> Question 1: Is there any way to connect database at (Insert,
> update, fetch ) query time and if i do so then it takes time
> to connect every time. and I don't want to keep open
> connection. what is the best solution.
>
> Question 2: I wrote one stored procedure in database and
> that procedure expect three parameters and it returns some
> record so how do i call this procedure with parameter in C#.
>
> Thanks for reading
> Chandresh Patel