none
Not able to connect to Oracle 10G server. RRS feed

  • Question

  • Hi All

    I have installed Oracle Clinet 10G and i am able to connect to oracle server using sql plus, but  not through Microsoft OLEDB data provider for Oracle.

    Error : Test Connection Failed because of an error initializing provider, oracle error occured,
    but error message could not be reterived from Oracle.

    also before installing Oracle clinet i have SQL Server 2005 and 2008 client in  my system.

    How can i connect with oracle server using Microsoft OLEDB data provider for Oracle.


    How would i know what excatly is the issue?
    • Edited by developer_rk Friday, September 23, 2011 5:53 AM update
    Friday, September 23, 2011 5:25 AM

Answers

  • Hi All

    Issue resolved.

    Steps

    1) Deleted Oracle resistry.

    2) Unistalled SQL server 2008 Client

    3) Uninstall then re-install oracle Client.

    4) Installed Sql server Clinet 2008 again.

     

     

     

    • Marked as answer by developer_rk Friday, September 23, 2011 11:41 AM
    Friday, September 23, 2011 11:41 AM