Stored procedure using Sybase 15 client on 12.5.1 server does not work

[muyb...@hotmail.com]

Hi,

I am using ADO to run the following stored procedure:

create procedure TESTADO1( @input varchar(255), @result varchar(255)
output )
as
begin
select @result = @input
end

Here is the code I use:

_variant_t vTmp = _T("Hello");
_ParameterPtr pParameter1 = spCmd->CreateParameter( _T("VALUE_IN1"),

adVarChar,

adParamInput,

255 ,

vTmp );
spCmd->Parameters->Append( pParameter1 );

_variant_t vVALUE_OUT2;
_ParameterPtr pParameter5 = spCmd->CreateParameter( _T("VALUE_OUT2"),

adVarChar,

adParamOutput,

255,

vVALUE_OUT2 );
spCmd->Parameters->Append( pParameter5 );

spCmd->ActiveConnection = pConnection; //Connection created earlier
using ADO

spCmd->Execute( NULL, NULL, adCmdStoredProc );

This code works fine when I connect to a Sybase 15 server, but throws
an exception (E_FAIL, nothing useful) when I try it on a 12.5.1
server.

I am using a 15 client. A 12.5 client running this code succeeds with
a Sybase 12.5.1 server and with a Sybase 15 server. Could there be a
bug in the ODBC support in the 15 client when working with 12.5.x
servers? I thought ODBC just wraps the native driver, which would
imply that if it works for one server version, it would work for all?

Thanks!

[Cory Sane]

Hi,

There have been 14 ESD's to the ASE 15.0 client.
A quick fix would be to load latest ESD and try again.

The client fixes are listed as "Software Developer Kit" - and any recent SDK
15.0 ESD can be applied to most any ASE 15.0.x client. run "isql -v" on
your current system to see the patch level that would match an older SDK
version.

<muyb...@hotmail.com> wrote in message
news:affc2fff-53f6-4c6f...@e53g2000hsa.googlegroups.com...

[muyb...@hotmail.com]

It seems that installing the meta data procs form Sybase\DataAccess
\ODBC\SP resolves the problem. After installing those, things seemed
to be working better.