I am doing some testing using NUnit, some of which connects to an Oracle DB (Yes I realize it's not really unit testing, but it sure makes other testing easy). I have a 64-bit machine, but everything is set to x86 and I'm using System.Data.OracleClient to do my connections. All connects and works fine using SQL Developer, the database code in a website, and a Console app running the method in question. But when I try to run it using NUnit, I get
ORA-06413: Connection not open
Most everything dealing with this error talks about having the client in the (x86) folder (which it's not), or other illegal characters in the path, which I don't see.
Any other ideas?
Maybe NUnit-console.exe you use is written for .NET 2.0 and thus it loads CLR 2.0. That means that all other DLLs are run under CLR 2.0
Haha got it! It was an (x86) problem. It was because NUnit was running from the Program Files (x86) folder, much like the ODP.NET client would. I re-installed NUNit to my AppData folder and voila, things started working.
I did uninstall NUnite from Program File (x86) and reinstall NUnite to apps folder. It works for me.