SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-01-2008, 01:43 PM
| ||||
| ||||
 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      |
|
03-01-2008, 01:43 PM
| |||
| |||
| Re: Accessing external data from SQL Server <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 |
|
03-01-2008, 01:44 PM
| |||
| |||
| Re: Accessing external data from SQL Server 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 > |
|
03-01-2008, 01:44 PM
| ||||
| ||||
| Re: Accessing external data from SQL Server 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. |
Linear Mode
