Error in test Connection VB-oracle--- OracleClient n networking comps not found

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mask
    New Member
    • Sep 2007
    • 17

    Error in test Connection VB-oracle--- OracleClient n networking comps not found

    I wish to connect to Oracle thru VB6 using ADO, test connection fails and the error which comes is as Test Connection failed because of error in initialising provider-oracle client and networking components were not found.How can this problem be solved ?
    thx n regards
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    first check if u are able to conenct to oracle from the client or not.

    Please specify the oracle service name also in the connection string.

    Comment

    • mask
      New Member
      • Sep 2007
      • 17

      #3
      Originally posted by debasisdas
      first check if u are able to conenct to oracle from the client or not.

      Please specify the oracle service name also in the connection string.
      i am using the wizard so no where the service name is asked, where should i give it in that case?i am able to connect to orcale thru the client.
      thx

      Comment

      • debasisdas
        Recognized Expert Expert
        • Dec 2006
        • 8119

        #4
        Originally posted by mask
        i am using the wizard so no where the service name is asked, where should i give it in that case?i am able to connect to orcale thru the client.
        thx
        can you post your ADO connection string for my reference please.

        Comment

        • QVeen72
          Recognized Expert Top Contributor
          • Oct 2006
          • 1445

          #5
          Hi,

          In Client did u Configure "Local Net Service"..?
          Did u get msg "Test Connection Successful".... ?


          REgards
          Veena

          Comment

          Working...