How to install Microsoft OLE DB Provider for Oracle in Windows Server 2012R2x64

0

Someone knows how I can install Microsoft OLE DB Provider for Oracle in Windows Server 2012R2x64, I read everywhere that this can not be done because:

  

This provider is already obsolete and without support

     

There is no version for x64

     

It is advisable to use the ORACLE providers

     

A million other reasons.

Well the dilemma is that I have a giant web system that uses MSDAORA and must be migrated to WS2012R2, in the connection chain I change the provider to ORAOLEDB.ORACLE, but so far in the tests with this chain change only it works like 70% of the codes that interact with the BD.

The point is that as it is a giant system, if I continue with the path of changing providers, the tests would take longer and much much much code would have to be modified, AND THAT IS NOT THE IDEA. What you want to do is migrate the application to a WS2012R2x64 if possible with 0% code modification, and for this I want somehow (maybe unofficially) to install the MSDAORA on a WS2012R2x64, someone knows how I can achieve said installation ???

Best regards to all.

    
asked by RSillerico 20.09.2016 в 15:53
source

1 answer

1

Microsoft Data Access Components (MDAC) was designed for x86 platforms on Windows 2000, 98, ME and NT the latest revision is 2.8 SP1 is dated 05/10/2005 from then on they were integrated into the following operating systems as Windows Data Access Components (WDAC)

If your database is in Oracle, install the Oracle ODBC drivers and access any relational database

link

instead of using OLEDB, or ODAC:

link

If your application is in .NET, use the Oracle provider directly:

link

    
answered by 26.06.2017 в 09:52