[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3134
  • Last Modified:

Error Accessing Orcale database using SQL navigator

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!!!!!!!!!!

2 Solutions

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

Reinstall SQL navigator. See if it'ss showing some errors while being installed. That's the best way to go for it.
SMadhaviAuthor Commented:
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!!!!!!!!!

SMadhaviAuthor Commented:
I got it working finally. It was some version specific problem
try this:

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

best regards

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now