Null Exception on Connection Open
 629402Mar 19 2008 — edited Mar 20 2008
629402Mar 19 2008 — edited Mar 20 2008In C# using the following code I get a blank exception, on the Open call.
string oradb = "user id=test;Password=testing;Data Source=myserver;";
cOra = new OracleConnection(oradb);
cOra.Open();
Stack Trace:
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
at Oracle.DataAccess.Client.OracleConnection.Open()
at iCatgeorize.iCategorize.button1_Click(Object sender, EventArgs e) in c:\projects\iCatgeorize\iCatgeorize\Form1.cs:line 54
My local OCI works perfectly using C++ applications, I have tried everything to get this to work but it all fails in the same place.
I'm using OCI DLL 10.2.0.1 and ODP 2.102.2.20 both which were from the ODAC installer.
I'm at a loss as to why this is happening, this a fresh oracle client install with no other settings. We have run into a similar issue on our production servers throwing blank exceptions if a call to the OCI DLL is made before the ODP one can be established, I am not sure if this is something similar.
Any help would be appreciated :p