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

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