Browse by Tags

• ASP.Net

• ORA-02041: client database did not begin a transaction

  When using OracleClient connect to Oracle 8i and using database link, error "ORA-02041: client database did not begin a transaction" occur even for single select statement. This is unfortunately a known problem, there is a QFE ready which you can get by contacting PSS for Q830173, you also need to add a new keyword to the connection string, (please verify with PSS what the actual string is). As part of this workaround you cannot use Distributed Transactions on that particular connection... Posted Jun 07 2007, 08:09 PM by wicky with | with no comments Filed under: ASP.Net, Win.Net, Database

• 使用非默认的Oracle Client

  CDA需要使用Oracle 10g Client，而同一台机器上的其他程序暂时都是使用Oracle 8i Client，默认Client是Oracle 8.1.7。如何是好呢？ 一个简单的解决方案： Web.config: <appSettings> <add key="oracleClientPath" value="c:\oracle\ora10g\bin" /> </appSettings> Global.asax: void Application_Start( object sender, EventArgs e) { Application.Lock(); ... string oracle = Config.OracleClientPath; if (!String.IsNullOrEmpty(oracle)) { string path = Environment.GetEnvironmentVariable( "path" ); path = String.Format( "{0}{1}{2}" , oracle, (oracle[oracle... Posted Jun 28 2006, 04:59 PM by wicky with | with no comments Filed under: ASP.Net, Win.Net, Database