Is it possible to read data from another server ?

[Tison]

I have 2 ASE servers P1 and P2.
Can I run the following command on P1 ;
"SELECT * FROM P2.DATABASE.DBO.TABLENAME"

I know about CIS but then I have to define the table as a remote object AND the my remote database name changes every time so I have to drop and recreate the objectdef.

Basically, what is the simplist way to read data across servers ?

 

[JeanNiBee]

Hey

That is the simplest way. Why does the remote object name change 'everytime'?

If you are referencing the logical server name then you should have no problems.


-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR][/COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects