Sybase ODBC - ODBC native error 7221

Author

ODBC native error 7221

Michael

2005-05-03, 8:23 pm

Hi,

We're using the latest Sybase ODBC drivers (5.0.0.56) to
access a 12.5.2/EBF 12054 server from VB6. When we call a
stored proc that does an RPC to another server, it fails
with

"Login to site '<site>' failed. (7221)"

Calling the proc from isql or java using jConnect works
fine. I saw some earlier discussion on this refer to an EBF
but I think that was for an earlier version so we should
have that fix.

Can anyone shed any light on this?

Thanks,
Michael

Paul

2005-05-04, 11:23 am

Hi Michael,

Someone just told me about this and I believe there is a bug in the ODBC
Driver (Sybase ASE ODBC Driver). I also found that setting the ASE to
enable cis rpc handling:

sp_configure 'cis rpc handling', 1

will also solve this problem. If necessary you should log a Sybase tech
Support case. If one is already opened and you need this bug reported
please indicate so to the Tech Support Engineer so we can get that going.

-PV

<Michael> wrote in message news:4277fdd4.2eb8.1681692777@sybase.com...
> Hi,
>
> We're using the latest Sybase ODBC drivers (5.0.0.56) to
> access a 12.5.2/EBF 12054 server from VB6. When we call a
> stored proc that does an RPC to another server, it fails
> with
>
> "Login to site '<site>' failed. (7221)"
>
> Calling the proc from isql or java using jConnect works
> fine. I saw some earlier discussion on this refer to an EBF
> but I think that was for an earlier version so we should
> have that fix.
>
> Can anyone shed any light on this?
>
> Thanks,
> Michael

Michael

2005-05-04, 11:23 am

Thanks Paul, we set that option and it now works with the
4.2 and the 5.0 ODBC drivers.

It might be our support engineer who raised this to you -
I'll let him know of your response and that the fix worked,
and ask that he put in a bug report.

Once again, thanks very much for your help, this is a
time-critical issue for us as we're migrating off an
unstable 11.5 instance.

Regards,
Michael

> Hi Michael,
>
> Someone just told me about this and I believe there is a
> bug in the ODBC Driver (Sybase ASE ODBC Driver). I also
> found that setting the ASE to enable cis rpc handling:
>
> sp_configure 'cis rpc handling', 1
>
> will also solve this problem. If necessary you should log
> a Sybase tech Support case. If one is already opened and
> you need this bug reported please indicate so to the Tech
> Support Engineer so we can get that going.
>
> -PV
>
> <Michael> wrote in message
>
>

Paul

2005-05-04, 8:23 pm

Hi Michael,

Yup I got the case! Apparently there is another pressing issue so I will
work on that as well - I just got the repro and will proceed.

-Paul

<Michael> wrote in message news:4278f8dc.392b.1681692777@sybase.com...[color=darkred]
> Thanks Paul, we set that option and it now works with the
> 4.2 and the 5.0 ODBC drivers.
>
> It might be our support engineer who raised this to you -
> I'll let him know of your response and that the fix worked,
> and ask that he put in a bug report.
>
> Once again, thanks very much for your help, this is a
> time-critical issue for us as we're migrating off an
> unstable 11.5 instance.
>
> Regards,
> Michael
>
>
>

Sponsored Links