MSSQL Link Server connection failure to Oracle 817

From: Denham Eva <EvaD_at_TFMC.co.za>
Date: Tue, 28 Oct 2003 03:09:24 -0800
Message-ID: <F001.005D4CF1.20031028030924@fatcity.com>

Hello,

To my surprise I see there alot of us on this list, use MSSQL and Oracle in the same environment.

So please forgive me for asking this but it is a huge issue here at my work. The problem is like this, we have a MSSQL 2000 box connecting to Oracle 817, via Linked servers using OLEDB. The jobs will run fine for awhile, but then suddenly fail with the following error

Executed as user: TFMC\Administrator. OLE DB provider 'MSDASQL' reported an error. [SQLSTATE 42000] (Error 7399) Driver's SQLSetConnectAttr failed] [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed.

OK, this is specifically the MS driver being used here, but when Oracle drivers are used, we have the same issues. Both Databases are on HP/Compaq servers, and the Windows 2000 platform. I have loaded the newest patches for OLEDB on the MSSQL for the Oracle Client, but nothing helps.

Has anyone experienced this issue before?

Regards
Denham Eva
Oracle DBA
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Denham Eva
  INET: EvaD_at_TFMC.co.za

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 28 2003 - 05:09:24 CST