SharePoint connect to Oracle Database
We are running a SharePoint 2007 farm and we have staff that want to use a dataview to connect to an Oracle Database as well as a SQL database. The SLQ connection worked fine. When we try an Oracle Connection using a custom connection string we recieve an error retriving the list of databases. Some of the information I have read mentions installing the Oracle Client on the SP Web Front End servers and others do not. Is there a way to connect to an Oracle database without installing the Oracle Cleint on the SP Web Front End servers? I've read about using BDC, but that seems to involve having the Oracle.dll in the GAC which I believe would require the Oracle client to be installed.
October 29th, 2010 4:55pm

I think you can do it in 2 steps. First import required Oracle DB to sharepoint list. second use DataView WebPart to connect SharePoint List to OracleDB List. chek the following link. MCTS SharePoint 2007 -WSS 3.0
Free Windows Admin Tool Kit Click here and download it now
October 29th, 2010 8:17pm

You might want to consider writing a wcf service that exposes read/write oracle data and deploy the service on an application server, consume this service via BDCMicrosoft Certified Master | SharePoint 2007 Blog
October 29th, 2010 10:03pm

hi i am also having same can i connect to oracle database. I want to update a field in oracle table based on the selection of a List item status. Is there any possibilities to connect to oracle server.I tried by using oracle connection in sharepoint designer.But it is coming in designer only when loading the page it is giving error unknow error. Please reply soon.... haritha
Free Windows Admin Tool Kit Click here and download it now
May 23rd, 2012 1:47am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics