Issues with Oracle Provider for OLE DB in SQL Server
979595Dec 12 2012 — edited Dec 12 2012Hello,
I am experiencing several issues with the oracle driver that allows SQL Server to import data from Oracle. My main problem is that I am trying to install the option for one of my clients that is using Windows Server Standard with SQL SERVER 2008. When you go into SSIS wizard, there is not an option for Oracle Provider for OLE DB (I tried the Microsoft driver but unfortunately that one does not work right either).
I tried installing 10g on this machine but it failed immediately on install when trying to open saying "unknown, unknown, unknown" for reason. Next, I tried installing 11g and this ran correctly but it did not add the option in SQL Server so it didn't make a difference to me (in the install it said that the package contained it).
I have also been using my computer for testing so I wouldn't have to test on their server. I was able to install 10g on my computer successfully and added this added the option in SQL Server that I am wanting. However, I tried to completely uninstall 10g from my machine (first through the uninstall tool from setup, then deleting it from where the folder was stored on my drive, then from the registry in all of the places. Now, if I go into SQL Server the option is still there but if I try to select it I get an error saying the files needed to run aren't there (expected that). What I am wanting to do is get rid of that option completely and install 11g on my personal computer to see if it adds the option in SQL Server.
So my two problems are:
1: How to get the option added on the server's SQL Server for "Provider for OLE DB"?
2: How to get rid of where 10g added "Provider for OLE DB" on my personal computer now that 10g is uninstalled?
Sorry for how complicated this is and maybe I am just making this way more complicated than it has to be!