Error with loopback server when Install MDA tables

[doraemonsj]

Hi, all
When I install MDA tables on Sybase ASE 12.5, an problem occurs.

First, I add a 'loopbac' server alias name using 'sp_addserver
loopback, null, @@servername (same as the output of select
@@servername and @@servername is also in the interfaces file);
After that, I issue sp_helpserver loopback to check, the output as
follows:
loopback vivi
ASEnterprise
no timeouts, no net password encryption, writable , rpc
security model
A
2 1000

Then, test this configuration using: loopback...sp_who, an error
occured:
Msg 7211, Level 18, State 1:
Server 'vivi', Line 1:
Can't open a connection to site 'vivi' because 'set up channel'
message was not
acknowledged.

I tried to solve this problem as following steps:
1. sp_serveroption <server_name>, "timeouts", false
try again, same error
2. check the errorlog, nothing displayed related to the error.

The version on my test machine is:
1> select @@version
2> go
Adaptive Server Enterprise/12.5/SWR 9617 GA/P/Linux Intel/Linux
2.2.14-5.0smp i6
86/main/1647/32-bit/OPT/Fri Jun 1 15:04:59 2001

How to get through this?

Thanks in
advance.

[Rob V [Sybase]]

Make sure 'cis rpc handling' is enabled, disconnect your client session,
reconnect and try again.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

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

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:r...@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

"doraemonsj" <shaoj...@163.com> wrote in message
news:0b027c88-9328-4905...@2g2000prl.googlegroups.com...

[Leonid Gvirtz]

Hi

As far as I remember, MDA tables are available since version 12.5.0.3, but you are using version 12.5 GA without any EBFs installed. I would suggest upgrading to at least ASE 12.5.0.3 before you try to use MDA tables.

Hope it helps
Leonid Gvirtz

[doraemonsj]

Hi, thanks so much. After I set 'cis rpc handling' to true and try
again, loopback...sp_who works.

On 7月3日, 下午8时01分, "Rob V [Sybase]"

<r...@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY> wrote:
> Make sure 'cis rpc handling' is enabled, disconnect your client session,
> reconnect and try again.
>
> HTH,
>
> Rob V.
> -----------------------------------------------------------------
> Rob Verschoor
>
> Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
> and Replication Server 15.0.1/12.5 // TeamSybase
>
> Author of Sybase books (order online atwww.sypron.nl/shop):
> "Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
> "The Complete Sybase ASE Quick Reference Guide"
> "The Complete Sybase Replication Server Quick Reference Guide"
>

> mailto:r...@YOUR.SPAM.sypron.nl.NOT.FOR.MEhttp://www.sypron.nl

> Sypron B.V., Amersfoort, The Netherlands
> Chamber of Commerce 27138666
> -----------------------------------------------------------------
>

> "doraemonsj" <shaojin...@163.com> wrote in message

> > advance.- 隐藏被引用文字 -
>
> - 显示引用的文字 -

[doraemonsj]

You are right, MDA tables are available since version 12.5.0.3, I
should upgrade the server, thanks a lot for your help!

> > "doraemonsj" <shaojin...@163.com> wrote in message