Xref: alice comp.databases.oracle.server:39593 Path: alice!news-feed.fnsi.net!newsfeed.ecrc.net!newsfeed.nacamar.de!dispose.news.demon.net!demon!news.demon.co.uk!demon!coalole.demon.co.uk!Diane From: Diane Newsgroups: comp.databases.oracle.server Subject: Re: accessing one database from another Date: Tue, 2 Feb 1999 19:11:52 +0000 Message-ID: References: <794mum$5ts$1@nnrp1.dejanews.com> X-Trace: news.demon.co.uk 917983029 nnrp-04:4502 NO-IDENT coalole.demon.co.uk:193.237.0.12 X-Complaints-To: abuse@demon.net MIME-Version: 1.0 X-Newsreader: Turnpike (32) Version 3.05 Lines: 14 In article <794mum$5ts$1@nnrp1.dejanews.com>, browns_99@hotmail.com writes >I was wonder if there is a way to have SQL Server connect to another database >and pull a table from that other database (Oracle or DB2). This way I would >only need to look at one database for all my data. > >Thanks in advance > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Don't know if it works with sql server but you can create database links between Oracle databases - check the documentation for full details -- Diane