Solved

Accessing data across two physically separate servers

Posted on 1998-01-08
2
274 Views
Last Modified: 2008-03-17
Hi,
I am using sybase server (version 11.0.2). From server A, I want to access data in server B. Server A and server B are two separate servers. How can I do this?
Thanks for your answer.
Osho.
0
Comment
Question by:osho121097
2 Comments
 
LVL 2

Accepted Solution

by:
jbiswas earned 100 total points
ID: 1098209
This can be done in two concievable ways.
i) Using Remote procedure calls(RPC's).
ii) Using a Sybase Replicatiopn Server to replicate the data to the local server and then using that data.

Remote Procedure Calls: Executing an RPC sends the results of the remote process to the calling process.

To enable RPCs, the System Administrator and System Security Officer of each Adaptive Server must use sp_addserver to list the local server and remote server in the system table master..sysservers. Also list the remote server in the interfaces file or Directory Service for the local server. Reboot the server to reset the global variable @@servername.
Similarly on the remote server use sp_addserver to list the server originating the RPC in the system table master..sysservers. Also add the login(sp_addlogin or sp_addremotelogin based on who issues the command(sa/sso)) for the person executing the RPC, add user(sp_adduser) for the database and grant the right permissions.


ii)If you have the Sybase Replication server installed on Server B just do a one directional replication( or bi-directional based on whether you wanna modify data in Server B) to Server A and populate tables for which you need the data for. Plain vanilla.......
0
 
LVL 10

Expert Comment

by:bret
ID: 1098210
Umm.  A better way may be to use Omni SQL Server, or upgrade to ASE 11.5, which has Omni built in.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Fine Tune your automatic Updates for Ubuntu / Debian
A customer recently asked me about anti-malware and the different deployment options available for his business. Daily news about cyberattacks, zero-day vulnerabilities, and companies that suffered a security breach made him wonder if the endpoint a…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Edureka is one of the fastest growing and most effective online learning sites.  We are here to help you succeed.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now