Browse by Tags

• Win.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

• "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" with Oracle 9i/10g

  Problem Description ------------------- When running an application using the Oracle9i Release 2 (9.2.0.1.0) install of client software and that attempts to connect to an Oracle database with the Authenticated User privilege (such as when you use Microsoft's Internet Information Server (IIS)) through any of the following programmatic interfaces 1. Oracle Provider for OLE DB 2. Microsoft OLE DB Provider for Oracle 3. Oracle ODBC Driver 4. Microsoft ODBC for Oracle 5. Oracle Objects for OLE (OO4O)... Posted Jun 28 2006, 01:26 PM by wicky with | with no comments Filed under: ASP.Net, Database