Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Cannot Get Data from Oracle for My Tabular Model

Proposed Answer Cannot Get Data from Oracle for My Tabular Model

  • Wednesday, March 20, 2013 11:04 PM
     
     
    Sign In to Vote
    0

    I've created a tabular model project in Visual Studio 2012.  I go to the Model, and say Import from Data Source, and select Oracle, using the provider "Oracle Provider for OLEDB".  The test connection succeeds.  I then "write a query that will specify the data to import", and the query validates.  But when I click finish, I consistently get the error:

    The provider 'OraOLEDB.Oracle' is not registered.

    The following system error occurred:  Class not registered

    I have the Oracle 11g 32 bit client installed both on my machine, and the SQL 2012 server.  I cannot figure out why I get this error, considering that the test connection succeeds.  I even have powerpivot in my excel on my machine, and use this exact same provider and query, and it works.

    Any help?

     

All Replies

  • Thursday, March 21, 2013 7:41 PM
     
     Proposed Answer
    Sign In to Vote
    0
    Is the SQL Server 64 bits ? You may need to install the Oracle driver for 64 bits.

    MVP MCT MCTS Daniel Calbimonte

    http://elpaladintecnologico.blogspot.com

     
  • Friday, March 22, 2013 11:46 AM
     
     
    Sign In to Vote
    0

    I believe our SQL Server is 64 bit, so this seems a logical thing to try.  I guess I would have expected it to error differently, considering we have the Oracle OLE DLL regsvr32 on the SQL Server, I would think it would not have said not registered, but fail for something if it is 32 versus 64 bit incompatability, but I cannot think of any other good reasons, so we will try your suggestion.