2 Replies Latest reply: Apr 29, 2010 10:52 AM by Anil Konduri RSS

    Test connection failed because of an error in initializing provider

    Anil Konduri

      Hi

      I am trying to connect Oracle DB in the script page

      OLE DB --> Connect

      In Data Link Properties Window

      Provider Tab -->Oracle Provider for OLE DB

      Connections page --> Datasource, Username & pwd

      Then following error is populating

      "Test Connection is failed because of an error in initializing provider. ORA-12154 TNS:could not resolve the connect identifier specified"

      what could be the reason for this error? and how to resolve it?

      Thanks in advance