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.

Examples of using Stored Procedures

4 posts in General Discussion Last posting was on 2003-11-05 14:00:54.0Z
Eric Juntti Posted on 2003-11-03 20:22:21.0Z
Sender: 59f4.3fa6b85d.1804289383@sybase.com
From: Eric Juntti
Newsgroups: ianywhere.public.general
Subject: Examples of using Stored Procedures
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fa6ba23.5a02.846930886@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 3 Nov 2003 12:27:15 -0800, 10.22.241.42
Lines: 12
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Nov 2003 12:14:12 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Nov 2003 12:22:21 -0800
X-Trace: forums-1-dub 1067890941 10.22.108.75 (3 Nov 2003 12:22:21 -0800)
X-Original-Trace: 3 Nov 2003 12:22:21 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2000
Article PK: 4225

I am new to Sybase ASA 9.0 and I am trying to find some
examples of using stored procedures with Visual Basic.NET
2002. I found 1 example in a document called "SQL Anywhere
Version 9.0 ASP.NET/ADO.NET Tutorial For Visual Studio.NET",
but in step #8 where it tells you to select
"iAnywhere.Data.ASAClient" as a referenced component, it is
not in the selection list. Is this because I am using the
Developer edition (free download from the web)? Also, I am
having problems connecting to the database - I keep getting
invalid User ID or password messages, even though my
connection tests OK and I have a valid User ID and password.
I can't seem to get past the basics.


Chris Keating (iAnywhere Solutions) Posted on 2003-11-03 23:58:34.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <3fa6ba23.5a02.846930886@sybase.com>
Subject: Re: Examples of using Stored Procedures
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
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <3fa6ecd3$1@forums-2-dub>
X-Original-Trace: 3 Nov 2003 16:03:31 -0800, keating-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Nov 2003 15:50:25 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Nov 2003 15:58:34 -0800
X-Trace: forums-1-dub 1067903914 10.22.108.75 (3 Nov 2003 15:58:34 -0800)
X-Original-Trace: 3 Nov 2003 15:58:34 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2001
Article PK: 4226

Did you ensure that you install the .NET driver? It may be optionally
installed particularly if you install ASA9 prior to the .NET software.

To (re)install
1) run the install
2) navigate to the Select Components wizard page
3) expand the Adaptive Server Anywhere branch
4) ensure that ADO.NET Data Provider is checked.
5) complete the install

/ck

<Eric Juntti> wrote in message news:3fa6ba23.5a02.846930886@sybase.com...
> I am new to Sybase ASA 9.0 and I am trying to find some
> examples of using stored procedures with Visual Basic.NET
> 2002. I found 1 example in a document called "SQL Anywhere
> Version 9.0 ASP.NET/ADO.NET Tutorial For Visual Studio.NET",
> but in step #8 where it tells you to select
> "iAnywhere.Data.ASAClient" as a referenced component, it is
> not in the selection list. Is this because I am using the
> Developer edition (free download from the web)? Also, I am
> having problems connecting to the database - I keep getting
> invalid User ID or password messages, even though my
> connection tests OK and I have a valid User ID and password.
> I can't seem to get past the basics.


Eric Juntti Posted on 2003-11-05 14:00:54.0Z
Sender: 5b8.3fa901cd.1804289383@sybase.com
From: Eric Juntti
Newsgroups: ianywhere.public.general
Subject: Re: Examples of using Stored Procedures
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3fa90296.5c9.846930886@sybase.com>
References: <3fa6ba23.5a02.846930886@sybase.com><3fa6ecd3$1@forums-2-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 Nov 2003 06:00:54 -0800
X-Trace: forums-1-dub 1068040854 10.22.241.41 (5 Nov 2003 06:00:54 -0800)
X-Original-Trace: 5 Nov 2003 06:00:54 -0800, 10.22.241.41
Lines: 41
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2024
Article PK: 17415

I tried reinstalling and it now works. I can now refernce
the iAnywhere data provider and the example code works.
Don't know what happened because there didn't appear to be
any option on the installation specific to this. May have
been the order of installation (Visual Studio vs. ASA).

> Did you ensure that you install the .NET driver? It may be
> optionally installed particularly if you install ASA9
> prior to the .NET software.
>
> To (re)install
> 1) run the install
> 2) navigate to the Select Components wizard page
> 3) expand the Adaptive Server Anywhere branch
> 4) ensure that ADO.NET Data Provider is checked.
> 5) complete the install
>
> /ck
>
> <Eric Juntti> wrote in message
> > news:3fa6ba23.5a02.846930886@sybase.com... I am new to
> > Sybase ASA 9.0 and I am trying to find some examples of
> > using stored procedures with Visual Basic.NET 2002. I
> > found 1 example in a document called "SQL Anywhere
> Version 9.0 ASP.NET/ADO.NET Tutorial For Visual
> > Studio.NET", but in step #8 where it tells you to select
> > "iAnywhere.Data.ASAClient" as a referenced component, it
> > is not in the selection list. Is this because I am
> > using the Developer edition (free download from the
> > web)? Also, I am having problems connecting to the
> > database - I keep getting invalid User ID or password
> > messages, even though my connection tests OK and I have
> > a valid User ID and password. I can't seem to get past
> the basics.
>
>


Chris Keating (iAnywhere Solutions) Posted on 2003-11-04 00:18:48.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <3fa6ba23.5a02.846930886@sybase.com>
Subject: Re: Examples of using Stored Procedures
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: keating-xp.sybase.com
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <3fa6f068$1@forums-1-dub>
Date: 3 Nov 2003 16:18:48 -0800
X-Trace: forums-1-dub 1067905128 172.31.140.66 (3 Nov 2003 16:18:48 -0800)
X-Original-Trace: 3 Nov 2003 16:18:48 -0800, keating-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2002
Article PK: 4227

Can you post a sample of what you have that is failing?

<Eric Juntti> wrote in message news:3fa6ba23.5a02.846930886@sybase.com...
> I am new to Sybase ASA 9.0 and I am trying to find some
> examples of using stored procedures with Visual Basic.NET
> 2002. I found 1 example in a document called "SQL Anywhere
> Version 9.0 ASP.NET/ADO.NET Tutorial For Visual Studio.NET",
> but in step #8 where it tells you to select
> "iAnywhere.Data.ASAClient" as a referenced component, it is
> not in the selection list. Is this because I am using the
> Developer edition (free download from the web)? Also, I am
> having problems connecting to the database - I keep getting
> invalid User ID or password messages, even though my
> connection tests OK and I have a valid User ID and password.
> I can't seem to get past the basics.