Wednesday, March 20, 2013 11:04 PM
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.
Thursday, March 21, 2013 7:41 PMIs the SQL Server 64 bits ? You may need to install the Oracle driver for 64 bits.
MVP MCT MCTS Daniel Calbimontehttp://elpaladintecnologico.blogspot.com
- Proposed As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Friday, March 22, 2013 2:13 AM
Friday, March 22, 2013 11:46 AM
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.