Re: MS SQL 7 SP2 & Oracle 8 -> crash

"Peter Hiemenz" <PeterHiemenz_at_compuserve.com> wrote in message news:VA.000000b0.2e59d6d4_at_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.

You need SQL NET or NET 8 to configure the linked server. Also you need to make ODBC connections.

> 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?

 I'm not using OLEDB but ODBC is working fine.
>
> 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 - 17:41:14 CDT