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 use open client in powersite?

2 posts in General Discussion (old) Last posting was on 2000-02-16 15:39:17.0Z
john Posted on 2000-02-14 09:10:35.0Z
Newsgroups: sybase.public.easerver
Reply-To: "john" <wujun@990.net>
From: "john" <wujun@990.net>
Subject: how to use open client in powersite?
Date: Mon, 14 Feb 2000 17:10:35 +0800
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
NNTP-Posting-Host: 202.102.97.181
Message-ID: <347_8MRt94Fe$GA.324@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28591
Article PK: 154690

hi,
i have a problem about how to use open client in powersite.
when i use a htmlDatawindow ActiveX object , it only use a ODBC database
connection.
i want to use a store procedure on a Sybase SQL Server. the following error
is appears :

ERROR: Retrieve Failed = -1 *****
Select error: SQLSTATE = 01S01 [INTERSOLV][ODBC SQL Server driver]Error in
row.

My store procedure is :
********************
create procedure p_test
@code varchar(2)
as
begin
create table #abc(a integer)

end


Dave Wolf [Sybase] Posted on 2000-02-16 15:39:17.0Z
Newsgroups: sybase.public.easerver
From: "Dave Wolf [Sybase]" <dwolf@sybase.com>
Subject: Re: how to use open client in powersite?
Date: Wed, 16 Feb 2000 10:39:17 -0500
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: dwolf-nt.sybase.com 157.133.41.127
Message-ID: <347_h5Uy6RJe$GA.184@forums.sybase.com>
References: <347_8MRt94Fe$GA.324@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28570
Article PK: 154687

That looks like a Microsoft ODBC driver not a Sybase ASE Driver.

Dave Wolf
Internet Applications Division

john <wujun@990.net> wrote in message
news:8MRt94Fe$GA.324@forums.sybase.com...
> hi,
> i have a problem about how to use open client in powersite.
> when i use a htmlDatawindow ActiveX object , it only use a ODBC database
> connection.
> i want to use a store procedure on a Sybase SQL Server. the following
error
> is appears :
>
> ERROR: Retrieve Failed = -1 *****
> Select error: SQLSTATE = 01S01 [INTERSOLV][ODBC SQL Server driver]Error in
> row.
>
> My store procedure is :
> ********************
> create procedure p_test
> @code varchar(2)
> as
> begin
> create table #abc(a integer)
>
> end
>
>
>