Link to home
Start Free TrialLog in
Avatar of SMadhavi
SMadhaviFlag for Canada

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of jayaprakashbindi
jayaprakashbindi

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SMadhavi

ASKER

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

I got it working finally. It was some version specific problem
Avatar of raajbaid
raajbaid

try this:

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

best regards