Hi,
I have a Sybase dataserver containing lots of (huge) tables that I
would like to access from SQL Server (two different applications,
using two different datasources, now want to talk to each other). MS
Access has a feature for 'linking' external data. Can I do similar
stuff in SQL Server?
Basically, I am trying to avoid having to duplicate the data in both
the dataservers and worry about keeping them in sync.

Regards,
Tanveer

<arshad.tanveer (AT) gmail (DOT) com> wrote

Yes, look up linked servers in Books-Online. I haven't done this with
Sybase but would be surprised if you can't.





--
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com

You can , but I think that MS SQL 2000 doesn't come with the drivers , you
have to install the SYBASE odbc drivers

--

Jack Vamvas
___________________________________
Advertise your IT vacancies for free at - http://www.ITjobfeed.com



<arshad.tanveer (AT) gmail (DOT) com> wrote

On Mar 22, 12:51 am, "Jack Vamvas" <DEL_TO_RE... (AT) del (DOT) com> wrote:
I already have the Sybase SQL drivers installed. Thanks a bunch for
your help.