SMadhavi
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Copy ORACLE_HOME/bin/ociw32.dll
best regards
ASKER
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!!!!!!!!!