connecting sharepoint solution with oracle 10g RRS feed

  • Question

  • Hi All,

    I have a requirement where I need to fetch data from oracle 10g dataabase to MOSS 2007. When I try to make a solution for this: it gave me an error stating that oracle data acecess file should be greator than 8i. 

    but when I install oracle client version on my dev machine, this issue sorted out.  now I am moving my solution from dev to test machine where oracle clinet version is not installed. it is throwing an error that unable toload oracle.dataaccess.dll library. What should I do to remove it? Do I need to install oracle client on each environment inorder to run my solution. Does installtion of assembly would work for me in this case.

    I think this is not a good solution to install oracle client on production environment . There must be a way out to solve this issue.

    Please suggest if some one experience it.





    • Moved by Serge Luca [MVP]MVP Thursday, July 1, 2010 4:24 PM MOSS question (maybe in the BDC forum?) (From:SharePoint 2010 - Using Visual Studio with SharePoint and other programming)
    • Moved by Mike Walsh FIN Thursday, July 1, 2010 5:47 PM Moving to BDC. While it is not certain it is BDC, it IS certain that it is not a general question (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
    Thursday, July 1, 2010 4:15 PM


  • Hello vibha4281684,

    You'll need to install the client software on your SharePoint server. This is the same concept when working with SPD and database connections. We need to provide the underlying functionality to talk to the external database. Take a look at this post, it talks about consuming MySQL databases with SPD.


    Depending on the client install portion you might be able to include the DLLs in your solution but each installer has it's own needs. It might be easier to include a batch file that will just execute the oracle client exe instead of worrying about placing DLLs in the GAC manually.

    Dalibor K
    Microsoft Online Community Support
    • Marked as answer by Seven M Saturday, July 10, 2010 6:01 AM
    Friday, July 9, 2010 12:34 AM