Oracle error occurred, but the error message could not be retrieved from oracle

dragank

Hai frndz, This is the Error I am getting when I am trying to connect to Oracle (ver 7.0), from VB .NET application (.net ver 2003 and 2002) "Oracle error occurred, but the error message could not be retrieved from oracle" The connection string is: Provider = MSDAORA;User ID=xyz;Passowrd=xyz;Data Source=123; But it is working in few machines but not in few. What should i do? Should I configure Oracle client in any other way. I tried the following methods ==================== 1) I found some solutions in net. There it was given to check the Oracle_Home path in REGEDIT. I checked. The path is correct. 2) Then, one more solution was given, telling try with OLEDB. That also is giving error. 3) I tried by giving large value for "command.connectiontimeout". Not working. 4) The program is connecting in DEBUG mode. But not thru EXE. Please help me in solving this...I am struggling to finish my module with regards and please, karthik

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

MythicalMe21y ago
I really had no idea if you were aware it was a typo or not. You might have cut and paste right from your code into the message box and was unaware of the problem. To you it would seem like a silly mistake that you wouldn't make. I earnestly wish that all of my code didn't have silly mistakes that drove me batty for days on end. Apparently they don't plague you! My original assessment was that the problem was not a programming error but an Oracle setup error. If the code works in debug mode and runs in release on some machines then it would indicate that the problem is external. If ODBC and OLEDB are giving the same result then I would have to conclude that Oracle is not configured properly.
dragank21y ago
That was a typographical mistake. Even then i had specified the methods i followed. U should have atleast guesses that i wouldn't have done such a silly mistake. Anyway, thanks for your reply. Now consider that "Passowrd" as "Password" and try to solve my problem. with regards, dk
MythicalMe21y ago
If your connection string is an exact copy of the one you have in the program then change "Passowrd" to "Password".