I'm trying to export from SQLExpress 2012 to Oracle 11g using the export wizard in SQL Server Management Studio. When I try to configure the Oracle OLE DB provider and test it, I get the error "Test connection failed because of an error initializing provider".
If I test the OLE DB using the tip in this article, the test is successful.
I have a linked server configured from SQL Server to the Oracle database using OLE DB which does connect.
I mostly work with Oracle, so maybe there's a configuration issue here, or maybe I'm missing a piece somewhere linking SQL Server to Oracle OLE DB? Why would OLE DB work in one place but not in the export tool?