REPOST: SQL Server7 db link to Oracle8i

From: Frank Burns <fburns2112_at_yahoo.com>
Date: 27 Jan 2002 14:53:17 -0800
Message-ID: <3$--$%%%%--$-%$-_$@news.noc.cabal.int>

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: fburns2112_at_yahoo.com (Frank Burns) Control: cancel <2880a691.0201271453.396e1d2c_at_posting.google.com> Subject: cmsg cancel <2880a691.0201271453.396e1d2c_at_posting.google.com> Date: Mon, 28 Jan 2002 01:56:50 GMT Message-ID: <cancel.2880a691.0201271453.396e1d2c_at_posting.google.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!news.fh-hannover.de!news-han1.dfn.de!news-nue1.dfn.de!newsfeed.r-kom.de!newsfeed.freenet.de!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40719887

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 - 16:53:17 CST