Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Database


    

Blue Forest http://www.lslnet.com at 11:08 on July 8, 2006


Help, Sybase RPC -- hastily, expert help

I must be allocated between the two Sybase remote stored procedure call, according to the document Sybase done to the document are as follows :
Local Server : TEST (sender server)
Remote Server : R_TEST (receiver server)

Local Server (TEST) :
1.sp_addserver TEST, local
Sp_addserver R_TEST, null, R_TEST

2.add remote file server entry in interfaces

3.sp_congifure "remote access", 1
Sp_configure "number of remote logins", 100
Sp_configure "number of remote connections," 50


Remote Server (R_TEST) :
1.sp_addserver TEST, null, TEST

2.sp_configure "remote access", 1

3.sp_addremotelogin TEST, sa, sa (sp_addremotelogin sender_server_name, receive_server_login, sender_server_login)

Local Server&Remote Server** **restart


Note :

1.sp_addremotelogin
(1) sp_addremotelogin TEST
MONITOR TEST model : all Login with the corresponding R_TEST of all Login. Note : TEST and the same definition must R_TEST Login.
(2) sp_addremoteserver TEST, staff_rtest
N:1 model of all Login : TEST and R_TEST's only login---staff_rtest correspond.
(3) sp_addremotelogin TEST, sa, sa
The 1:1 mode : TEST sa sa with the corresponding R_TEST

2.sp_remoteoption
----turn Off the password checking with sp_remoteoption
(If the two server Login password is not the same need to receive server上 Enforcement)
Sp_remoteoption [sender_server_name, receive_server_login_name, sender_server_login_name, opt_name, {true|false}]

Sp_remoteoption TEST, staff_rtest, staff_test, trusted and true


In accordance with the above, the log in Sybase emerged as follows :
2>; exec sybase97.db97new.dbo.de_test
3>; go
00:00000:00023:2004/12/16 15:43:20.31 Kernel Network type 'tcp' not found in Ne
Twork tables
00:00000:00023:2004/12/16 15:43:20.31 Kernel Network type 'tcp' not found in Ne
Twork tables
00:00000:00023:2004/12/16 15:43:20.31 Kernel Network type 'tcp' not found in Ne
Twork tables
00:00000:00023:2004/12/16 15:43:20.31 server Failed to connect to remote server
132.112.64.3 5000 for site sybase97 sybase97 tcp ether. Trying the next query e
Ntry of this server, if any.
00:00000:00023:2004/12/16 15:43:20.31 server Error : 7235, Severity : 17, State :
0
00:00000:00023:2004/12/16 15:43:20.31 server No entry found for the other query
Remote server sybase97-site sybase97. Aborting this site handler, as no remot
E server responded. Please make sure the remote server is accepting connections.
Msg 7205, Level 17, State 2 :
Server 'ZJ112' Line 2 :
Can 't open a connection to site' sybase97 '. See the error log file in the SQL
Server boot directory.
Msg 7205, Level 18, State 3 :
Server 'ZJ112' Line 2 :
Can 't open a connection to site' sybase97 '. See the error log file in the SQL
Server boot directory.


Is there a problem? Sybase files or to the right? Or the name server configuration is the problem? Please Supreme guidance, thank you.

Help, Sybase RPC -- hastily, expert help

Equipped dscp?
Best use of remote server. Sybase System this is not very stable.



 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com