Re: Accessing Remote Server Objects
This is a discussion on Re: Accessing Remote Server Objects within the Sybase forums, part of the Database Server Software category; --> I would suggest setting up a proxy table on GEO to reference the table on HOLD1. GEO> sp_addobjectdef 'HOLD1.dbname.owner.tablename', ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 02:53 PM
| ||||
| ||||
 Re: Accessing Remote Server Objects I would suggest setting up a proxy table on GEO to reference the table on HOLD1. GEO> sp_addobjectdef 'HOLD1.dbname.owner.tablename', 'local_table_name' GEO> go GEO> create existing table local_table_name (colname coltype, colname, coltype ....) GEO> go Then access the proxy table (select * from local_table_name ...) - Orion Naveen wrote: > Hi > I am using Sybase Adaptive Server. I have two database servers HOLD1 > (ver 11.9.2) and GEO (ver 12.0). I need to remotely access tables in > HOLD1 from procedures in GEO server. I have set up Remote Servers and > I can use HOLD1...sp_who when connected to GEO it give me result of > users in HOLD1. > > But when I use Select * from HOLD1...[tablename] it gives me an error > saying 'contains more than the maximum number of prefixes. The > maximum is 2' > > When I give Select * from HOLD1..[tablename] it says object not found. > > I cannot run other procedures creted in HOLD1 also > Please Help. > > regards and thanks > Naveen      |
Linear Mode
