So your app can connect to the DB from another PC but not from your PC?Originally Posted by kandas.soft
Copy his TSNNames.ora file. Compare it to yours with a utility like BeyondCompare (has free trial) and ensure they are EXACTLY the same.
If they are then get your IT Operations to check your PC/account has the same permissions / priveliges as your collegue's PC/account.
"Man alone suffers so excruciatingly in the world that he was compelled to invent laughter."
Friedrich Nietzsche
"I spent a lot of my money on booze, birds and fast cars......the rest I squandered."
George Best
"If you are going through hell....keep going."
Winston Churchill
It was not because of access rights. I had admin rights in my system.
Finally the problem is solved.
Actually in my system there were 2 installations one was oracle 8 and other was oracle 10g. Since my program needs only oracle 8. I uninstalled oracle 10g.
Now my program is able to connect with database.
Many thanks to all of u.
