I am trying to connect to my Oracle database from my new PC. I just installed Visual Studio and ODAC. But when I try to make a simple connection, I get an exception with an empty message, an empty source, an empty number, only with an error code that is -2147467259.
OracleConnection Prueba;
Prueba = new OracleConnection("Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XXX.XXX.XXX.XXX)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XXXX)));User Id=XXX;Password=XXX;Pooling=true;Max Pool Size=10;Min Pool Size=1");
Prueba.Open();
Exception Details This is the Exception.ToString () code:
"Oracle.DataAccess.Client.OracleException at Oracle.DataAccess.Client.OracleException.HandleErrorHelper (Int32 errCode, OracleConnection connection, IntPtr opsErrCtx, OpoSqlValCtx * pOpoSqlValCtx, Object src,
StringHard..Oracle.Reclate.Interror.AccessOrder.Oracle.Reclate.Oracle.Reclate.rartext.curl.curve errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
in Oracle.DataAccess.Client.OracleConnection.Open ()
in OracleConnectionS.Program.Main (String [] args) in C: \ Users \ Simetri \ Documents \ Visual Studio 2010 \ Projects \ OracleConnection \ OracleConnection \ Program.cs: 19 "Lines
Any idea on why this could happen?
UPDATE
If I run visual studio as an administrator, I don't get an exception, and I can just connect to the database.
FULL CONTROL Oracle C:\Oracle. Visual Studio ( ), .
- 64- Windows 7
- Visual Studio 2010
- SQL * PLUS