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.

Trouble retrieving HTML Dw with Stored Procedure source and Arguments.

4 posts in General Discussion (old) Last posting was on 2000-03-28 21:11:12.0Z
Jamie White Posted on 2000-03-28 18:19:22.0Z
Newsgroups: sybase.public.easerver
From: "Jamie White" <jwhite@naroyal.com>
Subject: Trouble retrieving HTML Dw with Stored Procedure source and Arguments.
Date: Tue, 28 Mar 2000 13:19:22 -0500
Lines: 23
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 199.79.243.60
Message-ID: <347_eliC1IOm$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25456
Article PK: 155539

I'm having a lot of trouble retieving when my dataobject is a stored
procedure with arguments. I am able to retrieve SQL selects that have
arguments, and I can retrieve stored procedures that do not have arguments.
I'm using MS SQL Server 7.0, PB 7.0, and ASP w/ VB Script.

Stored Procedure:
sp_web_test ( myNum integer )

ASP:
<%...
objDW.RetrieveEx( "2" )
...%>

Error Message:

Error on Retrieve(): -1 Select error: SQLSTATE = 22005 [Microsoft][ODBC SQL
Server Driver]Invalid character value for cast specification.

Thanks,
Jamie White


Jim O'Neil [Sybase] Posted on 2000-03-28 18:37:59.0Z
Newsgroups: sybase.public.easerver
Date: Tue, 28 Mar 2000 13:37:59 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Trouble retrieving HTML Dw with Stored Procedure source and Arguments.
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 19
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38E0FC07.7245969E@sybase.com>
References: <347_eliC1IOm$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25450
Article PK: 154305

Try setting the DBParm StripParmNames='YES' as part of the DBParm in your
SetTrans function.

Jamie White wrote:

> I'm having a lot of trouble retieving when my dataobject is a stored
> procedure with arguments. I am able to retrieve SQL selects that have
> arguments, and I can retrieve stored procedures that do not have arguments.
> I'm using MS SQL Server 7.0, PB 7.0, and ASP w/ VB Script.
>
> Stored Procedure:
> sp_web_test ( myNum integer )
>
> ASP:
> <%...
> objDW.RetrieveEx( "2" )
> ...%>
>
> Error Message:
>
> Error on Retrieve(): -1 Select error: SQLSTATE = 22005 [Microsoft][ODBC SQL
> Server Driver]Invalid character value for cast specification.
>
> Thanks,
> Jamie White


Jamie White Posted on 2000-03-28 18:48:02.0Z
Newsgroups: sybase.public.easerver
From: "Jamie White" <jwhite@naroyal.com>
Subject: Re: Trouble retrieving HTML Dw with Stored Procedure source and Arguments.
Date: Tue, 28 Mar 2000 13:48:02 -0500
Lines: 20
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: 199.79.243.60
Message-ID: <347_WyMk2YOm$GA.285@forums.sybase.com>
References: <347_eliC1IOm$GA.285@forums.sybase.com> <347_38E0FC07.7245969E@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25448
Article PK: 155538

That did it! Where did you get such a great piece of information from? I
always have trouble finding info on ODBC connection strings and parms.

Jamie

Jim O'Neil [Sybase] wrote in message <38E0FC07.7245969E@sybase.com>...
>Try setting the DBParm StripParmNames='YES' as part of the DBParm in your
>SetTrans function.
>
>Jamie White wrote:
>
>> I'm having a lot of trouble retieving when my dataobject is a stored
>> procedure with arguments. I am able to retrieve SQL selects that have
>> arguments, and I can retrieve stored procedures that do not have
arguments.
>> I'm using MS SQL Server 7.0, PB 7.0, and ASP w/ VB Script.


Jim O'Neil [Sybase] Posted on 2000-03-28 21:11:12.0Z
Newsgroups: sybase.public.easerver
Date: Tue, 28 Mar 2000 16:11:12 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Trouble retrieving HTML Dw with Stored Procedure source and Arguments.
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 29
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38E11FEF.9037D346@sybase.com>
References: <347_eliC1IOm$GA.285@forums.sybase.com> <347_38E0FC07.7245969E@sybase.com> <347_WyMk2YOm$GA.285@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25432
Article PK: 155526

>> Where did you get such a great piece of information from?

Well that would be compromising my job security now, wouldn't it ;>)
Actually, it seemed to be a common error with SQLServer 7.0 balking on the
parameter names sent across in the execute request. The parm was added in
some post 7.0 GA build, so I doubt the documentation has caught up with it.

--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc

Jamie White wrote:

> That did it! Where did you get such a great piece of information from? I
> always have trouble finding info on ODBC connection strings and parms.
>
> Jamie
>
> Jim O'Neil [Sybase] wrote in message <38E0FC07.7245969E@sybase.com>...
> >Try setting the DBParm StripParmNames='YES' as part of the DBParm in your
> >SetTrans function.
> >
> >Jamie White wrote:
> >
> >> I'm having a lot of trouble retieving when my dataobject is a stored
> >> procedure with arguments. I am able to retrieve SQL selects that have
> >> arguments, and I can retrieve stored procedures that do not have
> arguments.
> >> I'm using MS SQL Server 7.0, PB 7.0, and ASP w/ VB Script.