Not able to connect to Oracle using OleDbConnection

Last post 11-05-2009 7:38 AM by swarooppavi. 2 replies.

Sort Posts:

  • Not able to connect to Oracle using OleDbConnection

    11-05-2009, 1:26 AM
    • Member
      1 point Member
    • swarooppavi
    • Member since 06-12-2009, 5:15 AM
    • Posts 17

    Hi,

    My application is using OleDbConnection to connect with oracle. In my local development environment I am able to use it with out any problem. But when I push to Staging server, I am facing connection Issue. On the staging server Oracle Application server is running and I am able to use SQLPLUS to connect with the Oracle server. The error which I am getting is as follows.

    Error Message:Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.

    Provider is unable to function until these components are installed.


    Thanks in advance


  • Re: Not able to connect to Oracle using OleDbConnection

    11-05-2009, 3:36 AM
    • Member
      426 point Member
    • garuka
    • Member since 07-16-2009, 9:46 AM
    • UK
    • Posts 149

    Do you have oracle client installed in your test environment?

    If not please install that and give it a try

    Thanks
    /Garuka
    _____________________________________
    Please Mark as answer if it helps you
  • Re: Not able to connect to Oracle using OleDbConnection

    11-05-2009, 7:38 AM
    Answer
    • Member
      1 point Member
    • swarooppavi
    • Member since 06-12-2009, 5:15 AM
    • Posts 17

    I have downloaded Oracle9i Release 2 Provider for OLE DB Version 9.2.0.7.0 (including ODAC) from http://www.oracle.com/technology/software/tech/windows/ole_db/htdocs/utilsoft.htm and now it is working fine. Thanks a lot 

Page 1 of 1 (3 items)