ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle internal error(-3000) when not using tnsnames.ora

429515Nov 9 2005 — edited Jun 26 2007

Hi,

When I specify Data Source in the connection string using the alias defined in tnsnames.ora, everything works fine.
If I specify Data Source like this instead:
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = titan)(PORT = 1521)) )(CONNECT_DATA = (SERVER=DEDICATED) (SERVICE_NAME = ORCL)))
it works for simple test cases, but in some applications I get this exception:

Oracle.DataAccess.Client.OracleException Data provider internal error(-3000) [System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
at Oracle.DataAccess.Client.OpsCon.Open(IntPtr& opsConCtx, IntPtr& opsErrCtx, OpoConValCtx* pOpoConValCtx, OpoConRefCtx& pOpoConRefCtx)
at Oracle.DataAccess.Client.ConnectionDispenser.CreateConnectionPool(OpoConCtx& opoConCtx)] at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleConnection.Open()
...

The only other parameters specified in the connection string are user and password.
I am using Oracle.DataAccess, Version=10.1.0.400 and connect to Orace 9i.

Is this a known bug?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 24 2007

Added on Nov 9 2005

#odp-net

1 comment

1,542 views