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

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

Madhavi
0
SMadhavi
Asked:
SMadhavi
2 Solutions
 
jayaprakashbindiCommented:


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

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

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

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

best regards
0

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