Error Accessing Orcale database using SQL navigator

Posted on 2005-04-25
Last Modified: 2012-08-13
I am installing SQL navigator on my machine and am trying to connect to the oracle database on the network.
I can conncet to the database using sql plus

But when I try to connect using the SQl navigator I get a error 1 : [Load interface dll's failed]

I also have SQL plus on my machine.  I can connect to the same databse using SQl Plus.
ie my Tnsnames.ora file is properly configured.

Can anyone help please!!!!!!!!!!

Question by:SMadhavi

    Accepted Solution


    I think you need to start the oracle agent service on ur oracle sytem where s/w installed ..

    LVL 11

    Assisted Solution

    Reinstall SQL navigator. See if it'ss showing some errors while being installed. That's the best way to go for it.

    Author Comment

    I have tried installing it many times and every time I get the same error message.

    All my other colleagues can connect to the database using SQL navigator. I can connect to the same database from my machine using SQL plus!!!!!!

    I think this problem is my machine specific!!!!!!!!!


    Author Comment

    I got it working finally. It was some version specific problem
    LVL 1

    Expert Comment

    try this:

    Copy ORACLE_HOME/bin/ociw32.dll to ora73.dll in the same directory. In my case it worked.

    best regards

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Suggested Solutions

    I guess that all of us know that caching the data usually increase the performance, but I worried if all of us are aware about the risk that caching the data provides and how to minimize this.  That’s the reason why I decided to write this short art…
    This article describes some very basic things about SQL Server filegroups.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    754 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

    16 Experts available now in Live!

    Get 1:1 Help Now