MS SQL 7 SP2 & Oracle 8 -> crash

From: Peter Hiemenz <PeterHiemenz_at_compuserve.com>
Date: Wed, 23 Aug 2000 21:54:39 +0200
Message-ID: <VA.000000b0.2e59d6d4@privat-ysaxh9ne>

I cannot succeed installing Oracle SQL Net drivers 7.3.3 on an NT 4 SP 5 PC with installed MS SQL Server 7.0 SP2.

I think I need SQL Net drivers to replicate MS SQL Server data into an Oracle database. Otherwise I get an error when trying to setup a linked server. I tried to setup the connection using either MS ODBC driver for Oracle (from MDAC 2.1) or MS OLE DB Provider for Oracle.

I also have problems retrieving data in an C++ developed app accessing data using OLE DB driver. Trying OLE DB for ODBC I get an OLE DB error in an function ?SQLAttrib? telling me that a parameter is not supported.

Has anyone succeded accessing Oracle data using OLE DB technology? Is it possible with Net 8 drivers?

TIA, Peter Hiemenz
Hilden near Dusseldorf

HMS Planung & Automation GmbH, Duisburg, Germany

mailto:Peter.Hiemenz_at_t-online.de Received on Wed Aug 23 2000 - 14:54:39 CDT