Two weeks ago I was working at a Customer who have a Small Farm of SharePoint on 64 Bit.
- Windows Server 2008
- SQL Server 2008
- SharePoint 2007 with SP2
Customer also have an Oracle ERP and like other customers in Saudi Arabia 🙂 wanted to provide some data E.G. Salary and Vacation (Every one’s Favorite). Custom has Oracle 10 G which is 32 bit so I simply written the web parts to show the data on a 32bit notebook which had 32 Bit Oracle 10G Client already installed. the Web Part worked nicely locally but the real problem started when we deployed it to the production. Below are things that we tried for 10 Days.
- Downloaded the Oracle 10 G Client 32 Bit for Windows Vista – Failed
- Downloaded the Oracle 10 G Client 64 Bit for Windows Vista – Failed
- Downloaded the Oracle 10 G Client 64 Bit for Windows Server 2003 – Failed
- Downloaded the Oracle 10 G Client 64 Bit for Windows Server 2008 – Failed
- Tried to Install Microsoft Oracle Data Access Provider – Failed
- Tried to install ODBC Drivers – Failed
- Try Various other solutions provided on the web + Oracle Forums but nothing works.
Let me tell you the problem. The problem was the registration of Oracle ODBC Drivers which is 32 bit only. I tried to use the 64bit ODBC but it does not work. I was getting the "THE Driver is not registered on the local machine" all the time. After 10 days of hard work a very different idea stuck me just hour before a meeting where we were going to finalize a plan to move to 32 bit environment. The idea was to use Oracle 11 G 64 bit Client for Windows Server 2008. I downloaded the client and install the full installation and it worked (I was suggesting it …ffffew). Just after installing 11G client I went to ODBC administration and saw Oracle Drivers in the system DSN. After configuring Oracle .NET Client, the web parts worked like a charm and customer was very happy.
So In case you have a 64Bit SharePoint Environment and wanted to access Oracle 10 G Data. Install Oracle 11G 64Bit Client for Windows Server 2008. It will work.