ODBC Connectivity

Posted on 2004-11-20
Last Modified: 2013-12-11
Hi everyone,
I am getting the following error while configuring the Microsoft ODBC for Oracle in win98.
"The oracle(tm) or networking components were not found.These components are supplied by Oracle Corporation and are a part of the Oracle version 7.3(or greater) client software installation. You will be unable to use this driver untill these components are installed"

I have tried configuring it after installing the oracle 7.3 components ,SQL *net components,but all in vain.
Please help urgently on this issue

Question by:ahit
    LVL 7

    Expert Comment

    You need Oracle Client software, more precisely Oracle*Net, because you cannot access Oracle databases through ODBC directly as you can with JDBC.

    Share and Enjoy   Christoph
    LVL 7

    Expert Comment

    When you installed the 7.3 sqlnet, did you specifically include an oracle protocol adapter? it wont install one unless you specifically ask it to, so you get sqlnet, but it cant talk to your network.

    If you have, you need to break the problem down a bit -
    using just the oracle client, try to tnsping your target database
    then try connecting from sqlplus
    then look at odbc

    let us know how far you get, and post any errors along the way.

    Author Comment

    When i am trying to start sqlplus

     i am getting the follwoing error:
    A required .Dll file, KG734.DLL was not found.


    LVL 7

    Accepted Solution

    Sounds like you have a corrupt / incomplete installation.
    If possible, remove the 7.3 home, and reinstall it

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
    This video shows how to recover a database from a user managed backup

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now