Hi,

Is it possible to set up a SQL Server 2000 server and a Sybase 11.5.1
server so that the SQL Server tables can be accessed from Sybase. So I
could write a query such as:

select *
from SQLSERVER2000.mydb.mytable

on the Sybase server?

Thanks in advance for any pointers.
Tom

On Fri, 16 Jul 2004 07:44:17 -0700, Thomas Richards wrote:

You need to use a product from Sybase called "Direct Connect" - although
I'm not sure if you can find it for ASE 11.5.x anymore.

Then you create a "proxy" table on the local server that points at the
table on the remote server, and you then query data in the proxy table as
if it is a local table.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html