Google Answers Logo
View Question
 
Q: ADO.NET 2.0 System.Data.OracleClient ( No Answer,   2 Comments )
Question  
Subject: ADO.NET 2.0 System.Data.OracleClient
Category: Computers
Asked by: maxm007-ga
List Price: $10.00
Posted: 16 Jun 2006 02:55 PDT
Expires: 16 Jul 2006 02:55 PDT
Question ID: 738639
This question is about ADO.NET 2.0.  I'm using
System.Data.OracleClient to connect to an Oracle 9i Database. I'm
executing a script and the following statement gives me an ORA-12828
error :
CREATE BITMAP INDEX IQLBIIX_IQDU_FLAG_CL0 ON "IQDU_FLAG" (
"LOYALTY_AMOUNT_REFUND_FLAG" ) TABLESPACE IQTBS_55_DI_INDEXES PCTFREE
0 MAXTRANS 255  STORAGE ( INITIAL 16K NEXT 10M MINEXTENTS 1 MAXEXTENTS
2147483645   PCTINCREASE 0)  PARALLEL ( DEGREE 4 )  NOLOGGING

A collegue of mine uses System.Data.ODBC to connect to that Oracle
database and he adds an MTS=F attribute to the connection string and
everything works fine.  I do not want to use ODBC and I want it to
work using OracleClient and I want it to make it work by code.  I have
been looking for an equivalent of MTS=f for the OracleClient
connection string but I have not found anything like that.

Thanks
Answer  
There is no answer at this time.

Comments  
Subject: Re: ADO.NET 2.0 System.Data.OracleClient
From: kaef-ga on 21 Jun 2006 03:24 PDT
 
you can see in 

http://www.connectionstrings.com/
Subject: Re: ADO.NET 2.0 System.Data.OracleClient
From: saikatsen-ga on 04 Jul 2006 00:19 PDT
 
Answer = 
This is because System.Data.OracleClient does not support parallel
transactions. Try removing the PARALLEL ( DEGREE 4 ) part from the
query and try again - it should work.

I am not a google researcher, so unfortunately I won't get paid for
answering this, but would like to know if it solves your problem.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy