Accessing external data from SQL Server

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@.gmail.comwrote in message
news:1174488978.618140.16840@.e65g2000hsc.googlegro ups.com...

Quote:

Originally Posted by

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
>

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@.gmail.comwrote in message
news:1174488978.618140.16840@.e65g2000hsc.googlegro ups.com...

Quote:

Originally Posted by

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
>

|||On Mar 22, 12:51 am, "Jack Vamvas" <DEL_TO_RE...@.del.comwrote:

Quote:

Originally Posted by

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.tanv...@.gmail.comwrote in message
>
news:1174488978.618140.16840@.e65g2000hsc.googlegro ups.com...
>

Quote:

Originally Posted by

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.

>

Quote:

Originally Posted by

Regards,
Tanveer

I already have the Sybase SQL drivers installed. Thanks a bunch for
your help.