Solved

Accessing data across two physically separate servers

Posted on 1998-01-08
2
275 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sybase - sp_cacheconfig 1 989
Sybase initialize new disk in Solaris 10 failed 2 936
Crystal Reports VB6 11 1,056
SQL Query  Syntax 3 89
One of the biggest threats facing all high-value targets are APT's.  These threats include sophisticated tactics that "often starts with mapping human organization and collecting intelligence on employees, who are nowadays a weaker link than network…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

785 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