connecting sharepoint solution with oracle 10g

• Question

• 

  

  0

  Sign in to vote

  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.

  Thanks

  Vibha

   

   

  • 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