|
|
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 |
|
There is no answer at this time. |
|
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. |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |