naveensc1@indiatimes.com (Naveen) wrote in message news:<af604cc.0308270734.4febf13f@posting.google.c om>...
> 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

While it would be nice if that syntax was supported, it is not.
The way to access tables on remote servers is to create a local
proxy table that maps to the table on the remote server, and access
the local proxy table is if it were a local table. Read the
ASE CIS User's Guide for details on proxy tables.

-bret