SEO

Hi All,

I have two ASE servers running on Sun boxes at version 12.0 and 12.5.
I wanted to create a proxy table from version 12.0 ASE on my ASE v 12.5.
So I went about setting up both servers for rpc/remote login etc. as per
instructions in Rob Verschoor's QRef guide. I think I arranged
everything correctly and I now find I can connect from my 12.5 server to
12.0. Since, the following test:
exec ASE12...sp_who; - works!

However, despite exactly the same setup on my ASE12 server the above
test fails from my ASE12 server, i.e.
exec ASE12_5...sp_who;

generates the following error:
" Msg 7205, Level 17, State 2
Server 'ASE12_5', Line 1
Can't open a connection to site 'ASE12'. See the error log..."

So to my question:
Is it possible to connect from 12.5 to 12.0 server? If so, please can
some one suggest what I'm missing.


I look forward to any replies.

Many thanks.
Naran.

Check out the settings for CIS RPCs are different in both servers.
(this is a config option) -- maybe your 12.0 is doing classic RPCs,
but your 12.5 is trying to do CIS RPCs. When CIS RPCs are enabled, the
RPC is done in a different way, namely using CIS. This requires a
different configuration setup (with external logins instread of remote
logins).
Try preceding your RPC with the command 'set cis_rpc_handling off' to
force the classic site handler RPCs.
Also, it may be that your 12.0 server is actually doing CIS RPCs; if
your 12.5 doesn't work, this may be due to a different external
login/password configuration.
Assuming of course, that your interfaces file definitions are
correct...

In case you have my book "Tips, Tricks & Recipes for Sybase ASE", see
section 12.8 for a discussion of CIS RPCs and 'classic' site handler
RPCs.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

"Naran Hirani" <N.Hirani@hgmp.mrc.ac.uk> wrote in message
news:bivcac$seh$1@niobium.hgmp.mrc.ac.uk...
> Hi All,
>
> I have two ASE servers running on Sun boxes at version 12.0 and
12.5.
> I wanted to create a proxy table from version 12.0 ASE on my ASE v
12.5.
> So I went about setting up both servers for rpc/remote login etc. as
per
> instructions in Rob Verschoor's QRef guide. I think I arranged
> everything correctly and I now find I can connect from my 12.5
server to
> 12.0. Since, the following test:
> exec ASE12...sp_who; - works!
>
> However, despite exactly the same setup on my ASE12 server the above
> test fails from my ASE12 server, i.e.
> exec ASE12_5...sp_who;
>
> generates the following error:
> " Msg 7205, Level 17, State 2
> Server 'ASE12_5', Line 1
> Can't open a connection to site 'ASE12'. See the error log..."
>
> So to my question:
> Is it possible to connect from 12.5 to 12.0 server? If so, please
can
> some one suggest what I'm missing.
>
>
> I look forward to any replies.
>
> Many thanks.
> Naran.
>