none
64bit MSDAORA.DLL for Oracle Connectivity

    Question

  • Hi,

    I have an 64 bit machine with 2008R2 Enterprise Edition SQL Server. InOrder to connect to Oracle, I need MSDAORA 64 bit version DLL to get registered. Where can i download this DLL and how to register it.

    Please let me know ASAP, Thanks in Advance.

    Srini..

    Monday, September 13, 2010 3:43 PM

Answers

  • There is no MSDAORA 64 bit

    Per this connect item

    https://connect.microsoft.com/SQLServer/feedback/details/267677/x64-version-of-msdaora-driver-please?wa=wsignin1.0

    Posted by Microsoft on 10/19/2007 at 1:02 PM

    Microsoft OLEDB Provider for Oracle and Microsoft ODBC driver for Oracle
    If you are using Oracle data sources, you should migrate to the Oracle-supplied provider and driver. Microsoft OLEDB Provider for Oracle (msdaora.dll) and Microsoft ODBC driver for Oracle (msorcl32.dll) are built by using Oracle Call Interface (OCI) version 7. Oracle no longer supports applications that use OCI version 7 calls, and these technologies are deprecated

    You need to use X64 provider from ORACLE

     

    • Marked as answer by KJian_ Thursday, September 23, 2010 6:13 AM
    Monday, September 13, 2010 5:09 PM

All replies

  • There is no MSDAORA 64 bit

    Per this connect item

    https://connect.microsoft.com/SQLServer/feedback/details/267677/x64-version-of-msdaora-driver-please?wa=wsignin1.0

    Posted by Microsoft on 10/19/2007 at 1:02 PM

    Microsoft OLEDB Provider for Oracle and Microsoft ODBC driver for Oracle
    If you are using Oracle data sources, you should migrate to the Oracle-supplied provider and driver. Microsoft OLEDB Provider for Oracle (msdaora.dll) and Microsoft ODBC driver for Oracle (msorcl32.dll) are built by using Oracle Call Interface (OCI) version 7. Oracle no longer supports applications that use OCI version 7 calls, and these technologies are deprecated

    You need to use X64 provider from ORACLE

     

    • Marked as answer by KJian_ Thursday, September 23, 2010 6:13 AM
    Monday, September 13, 2010 5:09 PM
  • Thanks for your reply. I installed 9.2 client in my 64 bit machine and installed 10.2 Data Access Component, it installed successfully but am not able to see the OraOLEDB.Oracle Provider in the providers list. What could be the reason?

    Tuesday, September 14, 2010 8:50 PM
  • Hi Srini,

    you may get better answer if you post your question related to Oracle Provider at

    http://forums.oracle.com

     

    Wednesday, September 15, 2010 2:12 PM
  • Install Oracle client 10/11 g

    This will work fine with all MS softwares.

    BabluV

    Thursday, May 31, 2012 9:53 AM