-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: girja27
Message 1 in Discussion
Im implementing Transaction support in an application using Transactionscope
(have done this for other providers with no issues ) , for Oracle 10g
Database , with Oracle Client 11g installed on my system . The Code is as
simple as below . But the instant the Oracle connection attempts to Open , I
get different errors , for different Oracle Providers , for the same action
(Opening the Oracle connection within a Transactionscope ) . Googling for the
error returned a lot of people who have faced the isssues but no solution.
Any idea what could be the reason . has it got to do with some kind of
settings/ configurations.
DbProviderFactory factory
=DbProviderFactories.GetFactory("System.Data.OracleClient");
//DbProviderFactory factory =
DbProviderFactories.GetFactory("Oracle.DataAccess.Client");
string constr =@"Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP)(HOST = ind-mhp1w3s0015)(PORT = 1521))) (CONNECT_DATA =
(SERVICE_NAME = XE)));User Id=refapp;Password=refapp;enlist=true";
using (TransactionScope scope
=newTransactionScope(TransactionScopeOption.RequiresNew))
{
//using (DbConnection conn1 = factory.CreateConnection())
using(OracleConnection oraconn =newOracleConnection(constr))
{
oraconn.Open();
}
}
1) Data provider internal error(-3000) [System.String] :-Provider
:Oracle.DataAccess.Client
2) "Attempted to read or write protected memory. This is often an
indication that other memory is corrupt." Provider:- System.Data.OracleClient
Thanks & Regards
Girija
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
