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
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" <shaojin...@163.com> wrote in message
> 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
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.
>> 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
<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
> > 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
> 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
> Rob V [Sybase] 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"
> >> 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
|
