Home Forums SQL Server 2005 Working with Oracle The OLE DB provider "OraOLEDB.Oracle" has not been registered. RE: The OLE DB provider "OraOLEDB.Oracle" has not been registered.

  • December 12, 2014 at 1:58 am

    #1764299

    Hi,

    To register provider you need one more oracle product instantclient-sqlplus-win-x86-64-11.2.0.1.0.zip and make some changes in register. All details are described in this article. http://nampark.wordpress.com/2011/01/20/installing-64-bit-odac-11-2-to-microsoft-sql-server-2008-r2-x64-for-replication/

    Hope it helps. (I used this article to create oracle linked server to SQL 2014, Oracle version is 11)

    ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*Brevity is the soul of wit.