REPOST: Re: SQL Server7 db link to Oracle8i

Contact Oracle with respect to their "transparent gateway" products.

But if you want information in Oracle? Why bring SQL Server into the picture? What value does it add?

Daniel Morgan

Frank Burns wrote:

> Goal - to setup a linked server in SQL Server7 (sp3 - MDAC v2.5 - on
> Win2000) to be able to read tables in Oracle8i (v8.1.5 - on Sun
> Solaris) that stores data with clobs.
>
> MS Oracle OLE/ODBC drivers do not support this. I have installed
> Oracle OLE v8.1.7 drivers on the Win2000 server, but am unable to
> setup this connection correctly. The latest error came back as a MS
> error:7356. After extensive searching for this error code, I am
> unable to come up with anything real to follow.
>
> Any help would be appreciated. Thanks in advance.

• WAS CANCELLED BY =======: From: "Daniel A. Morgan" <damorgan_at_exesolutions.com> Control: cancel <3C5434EE.92D9C35A_at_exesolutions.com> Subject: cmsg cancel <3C5434EE.92D9C35A_at_exesolutions.com> Date: Mon, 28 Jan 2002 02:38:35 GMT Message-ID: <cancel.3C5434EE.92D9C35A_at_exesolutions.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!xmission!news.svpal.org!nntp.cifnet.net!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40720018

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Sun Jan 27 2002 - 11:12:14 CST